Tip: Know when not to Maximize Data Throughput for Network Applications

Follow Our Daily Tips

• facebook.com/TechNetTips
• twitter.com/TechNetTips
• blogs.technet.com/tnmag

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.

From the Microsoft Press book Microsoft SQL Server 2008 Administrator’s Pocket Consultant, Second Edition by William R. Stanek.

Looking for More Tips?

For more tips on Microsoft products and technologies, visit the TechNet Tips library.