NIC settings for SQL 2005 and Windows 2003?

10 Aug 2006 3:56 PM

DBA Dude

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

10 Aug 2006 4:23 PM

Arnie Rowland

Check in sqlserver.connect for response.

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

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

Show quote

"DBA Dude" <c***@aham.com> wrote in message
news:%23ShCFWJvGHA.3936@TK2MSFTNGP04.phx.gbl...
> 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
>