Maximizing Throughput

When you run the SQL Server setup program, your Windows NT system is automatically configured to maximize throughput for network applications. This enables the server to accommodate more connections. Although this configuration is recommended for SQL Server, you can change the setting back to the Windows NT default by using the following procedure.

    To change throughput back to the default

1. Open the Main program group, and double-click the Control Panel icon.

   The Control Panel window appears.

2. Double-click the Network icon.

   The Network Settings dialog box appears.

   

3. From the list in the Installed Network Software box, select Server.
4. Choose the Configure button.

   The Server dialog box appears.

   

5. Select Maximize Throughput for File Sharing.
6. Choose the OK button.

   The Network Settings dialog box returns.

7. Choose the OK button again.

Throughput can be set for computers running the Windows NT Server operating system. This configuration setting does not apply to computers running the Windows NT Workstation operating system. For additional information about maximizing throughput, see your documentation for Windows NT.