If you are running SQL Server 2008 on Windows Server 2003, do not use the Maximize Data Throughput For Network Applications setting. This setting gives priority to applications that perform buffered I/O by caching their I/O pages in file system cache. Using this option might limit the amount of memory available to SQL Server 2008.
To view and change this setting, complete the following steps: 1.
Access the Network Connections in Control Panel. 2.
Right-click Local Area Connection and then select Properties. 3.
Select File And Printer Sharing For Microsoft Networks and choose Properties. 4.
On the Server Optimization tab, choose an appropriate setting other than Maximize Data Throughput For Network Applications. 5.
Restart the server to apply the setting change.