Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
imarchenko@hotmail.com
Starting Member
6 Posts |
 Posted - 2009-05-14 : 20:08:33
|
| Hello!I have stumbled across following information:http://statisticsio.com/Home/tabid/36/articleType/ArticleView/articleId/357/An-Often-Overlooked-Windows-Setting-for-the-DBA.aspxhttp://msdn.microsoft.com/en-us/library/ms191471(sql.90).aspxIt sounds like by default Microsoft Server installation should set'Maximize data throughput for network applications'. This is not the case forour production SQL Server 2005 64-bit cluster. Our current setting is'maximize data throuhgput for file sharing'.I was wondering if this indeed a recommended setting for SQL Serverenvironment. Does this require a service restart? Our server has plenty ofspace (26GB of RAM) and is not under any pressure (memory, IO,CPU). Will Isee performance improvements if I change this setting?Thanks,Igor |
|
|
|
|
|
Maximize data throughput setting for SQL Server