Maximizing Data Throughput

SQL Server Setup automatically sets Microsoft Windows Server 2003 optimization settings in the File and Printer Sharing for Microsoft Networks properties to Maximize data throughput for network applications, enabling the server to accommodate more connections. Although maximizing throughput for network applications is recommended, you can change this setting.

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.

See Also

Concepts

Optimizing Server Performance Using Windows Options

Help and Information

Getting SQL Server 2005 Assistance