January 7, 2008 at 8:40 am
It seems that in SQL 64B by default Server optimization points to Maximize data throughput for file sharing. Is it a new MS recommendation or just another bad default value. I assume that it should be changed to Maximize data throughput for network applications for dedicated SQL Server.
Any thoughts?
MCP ID# 1115468 Ceritified Since 1998
MCP, MCSE, MCP+I, MCSE+I, MCSA,
MCDBA SQL7.0 SQL 2000, MCTS SQL 2005
January 7, 2008 at 8:58 am
That is just the default Windows Server setting.
You should change it for any SQL Server installation.
January 7, 2008 at 9:10 am
In SQL 2k it is automatically set up to correct one. On SQL 2k5 32 Bit as far as I remember as well.
MCP ID# 1115468 Ceritified Since 1998
MCP, MCSE, MCP+I, MCSE+I, MCSA,
MCDBA SQL7.0 SQL 2000, MCTS SQL 2005
January 7, 2008 at 9:29 am
berto (1/7/2008)
In SQL 2k it is automatically set up to correct one. On SQL 2k5 32 Bit as far as I remember as well.
It has nothing to do with installing SQL 2K; it is a Windows setting.
January 7, 2008 at 1:48 pm
I think you'll find sql server and exchange make changes to this setting when they are installed. I've been looking into server config, especially x64 and this is something I've seen mention of - some o/s settings are reconfigured so to speak - I've not blogged this yet but if you want to follow the links from my blog you should find it http://sqlblogcasts.com/blogs/grumpyolddba/
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
January 8, 2008 at 2:02 am
Michael Valentine Jones (1/7/2008)
berto (1/7/2008)
In SQL 2k it is automatically set up to correct one. On SQL 2k5 32 Bit as far as I remember as well.It has nothing to do with installing SQL 2K; it is a Windows setting.
I know but SQL Setup program at least for SQL 2000 changed this setting after installation.
MCP ID# 1115468 Ceritified Since 1998
MCP, MCSE, MCP+I, MCSE+I, MCSA,
MCDBA SQL7.0 SQL 2000, MCTS SQL 2005
January 8, 2008 at 12:15 pm
you can check the registry seting for this if you're not sure.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
January 9, 2008 at 12:42 am
To be honest it doesn't matter what was default for which system. The question is in 64 bit is there still recommended for MS to go with optimization for net app or they changed their mind and now it should be file sharing.
MCP ID# 1115468 Ceritified Since 1998
MCP, MCSE, MCP+I, MCSE+I, MCSA,
MCDBA SQL7.0 SQL 2000, MCTS SQL 2005
June 15, 2009 at 9:13 am
According to SQL Server 2005 BOL (in regards to memory management) you should choose any setting other than "Maximize data throughput for network applications".
Quote from BOL:
"Maximize Data Throughput for Network Applications
If the Maximize data throughput for network applications network connection option is selected, the operating system gives priority to applications that perform buffered 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.
To check the current setting on your operating system
Click Start, then click Control Panel, double-click Network Connections, and then double-click Local Area Connection.
On the General tab, click Properties, select File and Printer Sharing Microsoft Networks, and then click Properties.
If Maximize data throughput for network applications is selected, choose any other option, click OK, and then close the rest of the dialog boxes."
http://msdn.microsoft.com/en-us/library/ms178067(SQL.90).aspx
June 15, 2009 at 9:20 am
Actually it looks like the previously mentioned BOL article is WRONG.
Here is an update from MS that says that the "Maximize data throughput for network applications" setting SHOULD be used and that the BOL article is wrong.
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=366978
From the mentioned article:
Actual Results (current BOL article): the SQL Server 2005 Books Online (September 2007) article "Server Memory Options" recommends using any File and Printer Sharing option OTHER than "Maximize data throughput for network applications"
Expected Results (correction of current BOL article): the SQL Server 2005 Books Online (September 2007) article "Server Memory Options" should recommend using the File and Printer Sharing option "Maximize data throughput for network applications"
April 15, 2010 at 12:26 pm
THANK YOU for a clear and concise explanation of this issue.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply