Showing posts with label settings. Show all posts
Showing posts with label settings. Show all posts

Monday, March 12, 2012

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...
> > 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
> >
>
>

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...
>
>

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 DABIf 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@.aham.com> wrote in message
news:OsqdVVJvGHA.2436@.TK2MSFTNGP06.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
>|||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@.1568.com> wrote in message
news:u$ndEiJvGHA.1436@.TK2MSFTNGP02.phx.gbl...
> 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@.aham.com> wrote in message
> news:OsqdVVJvGHA.2436@.TK2MSFTNGP06.phx.gbl...
>|||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@.aham.com> wrote in message
news:OlCxvMMvGHA.4436@.TK2MSFTNGP05.phx.gbl...
> 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@.1568.com> wrote in message
> news:u$ndEiJvGHA.1436@.TK2MSFTNGP02.phx.gbl...
>|||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/Windo...3.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
"DBA Dude" <code@.aham.com> wrote in message
news:OlCxvMMvGHA.4436@.TK2MSFTNGP05.phx.gbl...
> 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@.1568.com> wrote in message
> news:u$ndEiJvGHA.1436@.TK2MSFTNGP02.phx.gbl...
>|||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..
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:%236KFDSNvGHA.324@.TK2MSFTNGP06.phx.gbl...
> 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/Windo...3.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
>
> "DBA Dude" <code@.aham.com> wrote in message
> news:OlCxvMMvGHA.4436@.TK2MSFTNGP05.phx.gbl...
>|||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"
<Brainb@.Yahoo.com> wrote:

>Hey Arnie
>I had read both of those articles as well. This is why I posted this messag
e
>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 "d
o
>it our way, not the right way" adage.
>Take care..
>"Arnie Rowland" <arnie@.1568.com> wrote in message
>news:%236KFDSNvGHA.324@.TK2MSFTNGP06.phx.gbl...
>|||Lines: 138
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
NNTP-Posting-Host: c-69-143-20-148.hsd1.va.comcast.net 69.143.20.148
Xref: leafnode.mcse.ms microsoft.public.sqlserver.connect:524
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.
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:ldqnd2592cea5lmtd9gjl7d279fejnall1@.
4ax.com...
> 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"
> <Brainb@.Yahoo.com> wrote:
>
>|||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"
<Brainb@.Yahoo.com> wrote:

>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.
>
>
>"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:ldqnd2592cea5lmtd9gjl7d279fejnall1@.
4ax.com...
>|||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.
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:5ogpd2hc0bemanke6135ku3p4jij809139@.
4ax.com...
>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"
> <Brainb@.Yahoo.com> wrote:
>
>