all groups > sql server connect > august 2006 >
You're in the

sql server connect

group:

NIC settings for SQL 2005 and windows 2003?


Re: NIC settings for SQL 2005 and windows 2003? Arnie Rowland
8/10/2006 9:17:45 AM
sql server connect:
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


[quoted text, click to view]

NIC settings for SQL 2005 and windows 2003? DBA Dude
8/10/2006 11:54:57 AM
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

Re: NIC settings for SQL 2005 and windows 2003? Arnie Rowland
8/10/2006 3:14:07 PM
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


[quoted text, click to view]

Re: NIC settings for SQL 2005 and windows 2003? Arnie Rowland
8/10/2006 4:27:12 PM
From: http://msdn2.microsoft.com/en-us/library/ms191471.aspx

Maximize data throughput for network applications (the option that SQL
Server automatically sets)

From:
http://technet2.microsoft.com/WindowsServer/en/library/78a4be20-3f57-4b8d-a921-ac5d93665ff41033.mspx?mfr=true
Maximize data throughput for network applications
Optimizes systems for distributed applications that typically do their
own memory caching (such as SQL Server, which sets this option by default).

But maybe, just maybe, there is a reason for someone offering a countering
opinion... (I'd love to hear it.)

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


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


[quoted text, click to view]

Re: NIC settings for SQL 2005 and windows 2003? DBA Dude
8/10/2006 5:23:09 PM
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



[quoted text, click to view]

Re: NIC settings for SQL 2005 and windows 2003? Sue Hoegemeier
8/10/2006 8:23:15 PM
You need to have it set to network resources to enable AWE
with SQL Server 2005:
http://msdn2.microsoft.com/en-us/library/ms179301.aspx

-Sue

On Thu, 10 Aug 2006 22:03:25 -0400, "DBA Dude"
[quoted text, click to view]
Re: NIC settings for SQL 2005 and windows 2003? DBA Dude
8/10/2006 10:03:25 PM
Hey Arnie

I had read both of those articles as well. This is why I posted this message
in this newsgroup.

Tough to argue with it.. but then again, these are written by technical
writers, not tech's, and that is also tough to believe over an MVP.

Anyhow, thanks for taking the time. I need more people to speak on this
becaues I always go with real-work experience, rather than the Microsoft "do
it our way, not the right way" adage.
Take care..

[quoted text, click to view]

Re: NIC settings for SQL 2005 and windows 2003? Sue Hoegemeier
8/11/2006 11:55:44 AM
I wouldn't assume it is incorrect. Prior to SQL Server 2005,
some people bragged about how you actually could get rid of
the sa login. And they did. Of course I only saw one post
back from someone who said it totally hosed them - which it
would have done to others.
The people I know who write for Microsoft are actually very
technical, very knowledgeable, and more technical than most
people. I'd be leery of generalizing them as something like
"tech writers who wouldn't know stuff in the real world".
If you feel something in books online is incorrect, click
the send feedback link in the top right and send it in. They
truly welcome any and all feedback.

-Sue

On Fri, 11 Aug 2006 12:09:37 -0400, "DBA Dude"
[quoted text, click to view]
Re: NIC settings for SQL 2005 and windows 2003? DBA Dude
8/11/2006 12:09:37 PM
Hi Sue

Actually, that's incorrect. I have 3 SQL 2005 servers with AWE set and none
are set with the "Maximize data throughput for network applications" and
it's working just fine. Microsoft articles are written by tech writers, so
they wouldn't know this stuff in the real world apparently (judging from
these articles that are not correct.)

I really believe Microsoft should have hard-core tech's go through each of
their articles, one by one, and check out this erroneous errors.




[quoted text, click to view]

Re: NIC settings for SQL 2005 and windows 2003? DBA Dude
8/11/2006 3:06:20 PM
Sue

I appreciate your defense of technical writers, but they are just that,
technical writers, not do'ers. Hence, they write things (like this below)
that are not correct. Yes, I have already sent them feedback on this article
and many others.

Believe me, I know how tough it is to find a hard-core tech that is willing
to write a how-to book as well.

I've been working right next to techincal writers for years now, and none
were actual tech's. It's two different skill sets. Unfortunately, that's a
problem in the end though.




[quoted text, click to view]

Re: NIC settings for SQL 2005 and windows 2003? Keith Kratochvil
8/14/2006 9:41:42 AM
This Books Online article mentions that the SQL Server setup configures the
setting for network applications "enabling the server to accommodate more
connections. Although maximizing throughput for network applications is
recommended, you can change this setting."
http://msdn2.microsoft.com/en-us/library/ms191471.aspx

This article http://msdn2.microsoft.com/en-us/library/ms179301.aspx
mentions:
"If the Maximize data throughput for file sharing option is selected in
Network Connection, the operating system gives priority to applications that
perform buffered input/output (I/O) operations by caching their I/O pages in
file system cache. This option may limit memory available to SQL Server for
normal
operation."

It also mentions [When setting up AWE] "The Maximize data throughput for
network application option of Network Connection in Control Panel must be
selected."


I remember reading an article (I can't find the link now) that mentioned you
should choose file sharing. I don't remember where I found the article or
the reasoning behind their suggestion, but I would be tempted to go with the
"network applications" selection.

--
Keith Kratochvil


[quoted text, click to view]

Re: NIC settings for SQL 2005 and windows 2003? Sue Hoegemeier
8/14/2006 11:31:21 AM
But you have been getting responses from SQL MVPs : )

-Sue

On Mon, 14 Aug 2006 12:13:49 -0400, "DBA Dude"
[quoted text, click to view]
Re: NIC settings for SQL 2005 and windows 2003? DBA Dude
8/14/2006 12:13:49 PM
The odd thing is the only thing you're all recommending are articles by
Microsoft. Not actual performance testing on your own. Thus, i tend to
believe the Microsoft SQL MVP's who have actually done performance testing
with both settings.


[quoted text, click to view]

Re: NIC settings for SQL 2005 and windows 2003? Kalen Delaney
8/14/2006 3:48:51 PM
Who is this Mark L MVP and where did you read this recommendation?

--
HTH
Kalen Delaney, SQL Server MVP


[quoted text, click to view]

Re: NIC settings for SQL 2005 and windows 2003? DBA Dude
8/14/2006 4:20:04 PM
I haven't noticed any responses from MS SQL MVP's, other than the person who
suggested it in the first place.

My point is that you can't always go on techincal writers messages. You
sometimes have to go with the pro's who actually do the testing and
performance.

Experience counts!

[quoted text, click to view]

Re: NIC settings for SQL 2005 and windows 2003? Roy Harvey
8/14/2006 5:17:52 PM
[quoted text, click to view]

I count three. Not all MVPs put it in their sig line.

Re: NIC settings for SQL 2005 and windows 2003? Arnie Rowland
8/15/2006 12:36:06 PM
I'm still wondering why we don't know the name of the mysterious "Mark L",
an alleged "MVP", or the location of his "testing and benchmarking"
documentation. I would think that many of us here would benefit from the
sharing of such 'important' information that apparently contradicts what we
all seem to believe.

Without the opportunity to review the 'testing and benchmarking', I really
can't change my opinions and recommendations.

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

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


[quoted text, click to view]

Re: NIC settings for SQL 2005 and windows 2003? DBA Dude
8/15/2006 1:43:25 PM
Great. I like to hear from them. The more people that tune in, the better.

Have any of these MVP's done benchmarking to determine the best performance?
It appears they haven't because all they have done is reference MSDN
articles.

It's not the article that makes the best argument, it's the performance
testing and benchmarking.

At this time, I'm afraid I have to go with the performance testing and
benchmarking recommendation, not the MSDN articles written by tech writers.




[quoted text, click to view]

Re: NIC settings for SQL 2005 and windows 2003? Kalen Delaney
8/15/2006 3:09:43 PM
That should be interesting.

This page on the OFFICIAL Microsoft MVP Site shows that there is no SQL
Server MVP named Mark L
https://mvp.support.microsoft.com/communities/mvp.aspx?adv=1&name=mark&competency=Windows+Server+System+-+SQL+Server

The only Mark is Mark Allison.
--
HTH
Kalen Delaney, SQL Server MVP


[quoted text, click to view]

Re: NIC settings for SQL 2005 and windows 2003? DBA Dude
8/15/2006 5:53:46 PM
I'm trying to get in touch with him right now so he can speak for himself.

Stay tuned!



[quoted text, click to view]

Re: NIC settings for SQL 2005 and windows 2003? Arnie Rowland
8/16/2006 10:53:19 AM
Your comment is totally out of line.

Ever heard the expression 'wrote the book'. Well, Kalen 'wrote the book'.
You should check it out and then, perhaps, sheepishly, demur.

We are always open to new information. Several of us would like to know more
about who, what, how (you know, details) of any performance testing that
brings in new information. There actually may be something there -but we
need to be able to trace it down.

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

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


[quoted text, click to view]

Re: NIC settings for SQL 2005 and windows 2003? Sue Hoegemeier
8/16/2006 11:16:10 AM
I usually pull out of threads like this but that comment is
so inappropriate and out of line. All she asked for was who
Mark L was as no one seems to know a Mark L who is an SQL
Server MVP. Never heard of him, never seen his name on any
of the MVP stuff we get, not listed by Microsoft as an MVP,
etc.
If I were you, I would hope that not too many people read
this thread and your comment. Kalen has put a ton of time,
energy - and yes benchmarking and testing - into helping
more people that you can imagine in the SQL Server
community. Being that rude to someone who is so well thought
of, highly regarded, incredibly respect and totally
deserving of those opinions is just so far beyond stupid.
You made yourself look pretty bad.

-Sue

On Wed, 16 Aug 2006 12:26:48 -0400, "DBA Dude"
[quoted text, click to view]
Re: NIC settings for SQL 2005 and windows 2003? DBA Dude
8/16/2006 12:26:48 PM
wow, you really do believe everything you read don't you!

Can't always judge a book by it's page you know...

And I would suggest to you that you do your own benchmarking and peformance
test, and THEN get back to me.

It doesn't appear you rightly deserve your "MVP" to me.. sorry.

[quoted text, click to view]

Re: NIC settings for SQL 2005 and windows 2003? DBA Dude
8/16/2006 2:25:46 PM
Sue,

You're making yourself look bad. Your mind is closed and thus, you're not
open to something beyond what you might believe. This puts you at the
disadvantage - in everything you do.

Good luck, as you're going to need it.


[quoted text, click to view]

Re: NIC settings for SQL 2005 and windows 2003? DBA Dude
8/16/2006 2:27:01 PM
It's not out of line. In fact, I don't believe a person who is so closed
minded should be a paper "MVP". It goes against the very nature of it. Thus,
Kalen has the power to corrupt young minds and to me, that's way out of
line.

[quoted text, click to view]

Re: NIC settings for SQL 2005 and windows 2003? Scott Morris
8/16/2006 2:41:48 PM
[quoted text, click to view]

Perhaps below is the person referenced - Mark Long, a MS certified
Instructor.

http://www.vtc.com/modules/products/authorInfo.php?author=161

Re: NIC settings for SQL 2005 and windows 2003? DBA Dude
8/16/2006 5:25:53 PM
yes, that's him, because that email address shown is the one I communicate
with him wiht. He's also an MCDBA


[quoted text, click to view]

Re: NIC settings for SQL 2005 and windows 2003? DBA Dude
8/17/2006 10:37:21 AM
Jeez "Scott", I "wonder" how you knew that? :>)


[quoted text, click to view]