NIC settings for SQL 2005 and Windows 2003?

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 DABCheck sqlserver.connect for response.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"DBA Dude" <code@.aham.com> wrote in message
news:OtsE3VJvGHA.4972@.TK2MSFTNGP05.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
>|||This can be know if you know what you will be handle on the Server if going
to be only SQL Server DB and nothing Else use this setting.
"Maximize data throughput for network applications."
if on the server will be hosted another Things not only DBs.
put it as "Maximize date throughput for file sharing."
But very important of a Network Performance is that must be at the Maximun
level of data transfer 100 Full or 1GB Full. thats will be addressed by the
Network Admin.
Regards,
Santos Martinez,MCSE, MCDBA, MCTS
IT Community Staff of Puerto Rico
http://www.itcspr.org
"Arnie Rowland" wrote:

> Check sqlserver.connect for response.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "DBA Dude" <code@.aham.com> wrote in message
> news:OtsE3VJvGHA.4972@.TK2MSFTNGP05.phx.gbl...
>
>