Share via


Maximizing Data Throughput

To optimize system memory use for SQL Server, you should limit the amount of memory that is used by the system for file caching. To limit the file system cache, make sure that Maximize data throughput for file sharing is not selected. You can specify the smallest file system cache by selecting Minimize memory used or Balance.

To change the server optimization settings in Windows Server 2003

  1. In Control Panel, choose Network Connections, and then click Local Area Connection.

  2. On the General tab of the Local Area Connection Status dialog box, click Properties.

  3. On the General tab of the Local Area Connection Properties dialog box, select File and Printer Sharing for Microsoft Networks, and click Properties.

  4. In the File and Printer Sharing for Microsoft Networks dialog box, choose one of the following options:

    • Maximize data throughput for file sharing

    • Maximize data throughput for network applications (the option that SQL Server automatically sets)

  5. Click OK to save your settings.

For more information, see the Windows Server 2003 operating system documentation.