Re: NIC settings for SQL 2005 and windows 2003?

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

  • Windows Impersonation authentication to SQL Server?
    ... Impersonation will each Windows Domain user accounts need to be granted ... all be tracked and displayed in SQL Profiler? ... or SQL security but the article is discussing Windows security. ...
    (microsoft.public.sqlserver.security)
  • Re: Windows Authentication to SQL Server?
    ... oranges in trying to convert an asp.net app which uses forms authentication ... mode throughout the app with one SQL login account into SQL Server versus ... converting the asp.net app into a full individual Windows authentication ... Ultimate goal would be to see the individual windows ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • [TOOL] Resources for Combating the Slammer Worm
    ... installations of Microsoft® SQL Server™ and the Microsoft SQL Server ... SQL Server 2000 SQL Scan Tool ... runs on computers running Windows 2000 or higher and can identify ... Check runs on computers running Windows 98, Windows ME, Windows NT 4.0, ...
    (Securiteam)
  • Re: connection options to yukon
    ... If you use TLS you can increase the security of your SQL auth ... connection but unless you're good at setting up groups/schema/logins/users, ... Windows auth is slower as the domain must ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ANNOUNCEMENT: New SQL Server security tool - SQL Server 2000 Scan Tool
    ... windows user that they aren't running this code? ... > SQL Scan will scan a computer, a domain or a range of IP addresses. ... > Jerry Bryant - MCSE, ... > rights. ...
    (microsoft.public.security)
Loading