Re: NIC settings for SQL 2005 and windows 2003?

Can't argue with dem dere MVP's -but sounds specious to me...

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"DBA Dude" <code@xxxxxxxx> wrote in message
news:OlCxvMMvGHA.4436@xxxxxxxxxxxxxxxxxxxxxxx
Hi Arnie

It would seem so, but this fellow Microsoft MVP in SQL, say's that isn't
true. That when you combine the SQL 2005 with windows 2003, you sould
always use the ""Maximize date throughput for file sharing" setting.

Anyone else have opinions?

Thanks



"Arnie Rowland" <arnie@xxxxxxxx> wrote in message
news:u$ndEiJvGHA.1436@xxxxxxxxxxxxxxxxxxxxxxx
If the primary use of the server is SQL Server, then it is a 'network
application'
(If the primary use is file storage, then it is 'file sharing'.)

Typically, for an OLTP database you want smaller TCP packets, for an OLAP
database, larger TCP packets.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"DBA Dude" <code@xxxxxxxx> wrote in message
news:OsqdVVJvGHA.2436@xxxxxxxxxxxxxxxxxxxxxxx
All

Anyone know what is truly recommended for the NIC settings for SQL 2005
when installed on Windows 2003?

Microsoft SQL MVP and SQL author: Mark L. states that the NIC should be
set to:

"Maximize date throughput for file sharing."

However, MSDN article states that the setting should be:

"Maximize data throughput for network applications."

Anyone have any definitive resource on actually what it should be set
at?

Thank you

DBA DAB







.

Relevant Pages

  • Re: Windows Authentication or SQL Server Authentication
    ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... then go for Windows Authentication. ... I have a new software package that is running on SQL 2005 Standard. ...
    (microsoft.public.sqlserver.security)
  • Re: Schema Problems
    ... So there's no secure way to allow creation of objects but not deletion of ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... in SQL Server 2005 we have a new feature as DDL Triggers. ...
    (microsoft.public.sqlserver.security)
  • Re: English Query
    ... English Query has been discontinued for SQL 2005, ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ...
    (microsoft.public.sqlserver.olap)
  • Re: Modifying Data Directly through Studio Manager
    ... Enterprise manager (in SQL 2000) never had a problem ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... 'tool' to allow your customers to manage their data. ...
    (microsoft.public.sqlserver.tools)
  • Re: Can you have two SQL instances with the same on the same cluster?
    ... Most good judgment comes from experience. ... You can't help someone get up a hill without getting a little closer to the ... and am ready to start installation of SQL 2000 and SQL ... I'm installing both SQL2000 and 2005 on the same cluster to make our ...
    (microsoft.public.sqlserver.clustering)