Wednesday, August 5, 2009

Performance tuning SQL 2000/2005 on Windows 2003


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. Use "Minimize memory used".

Reference: http://technet.microsoft.com/en-us/library/ms178067(SQL.90).aspx

No comments:

Post a Comment