Home > Articles > Data > SQL Server

  • Print
  • + Share This
From the author of

Windows NT and SQL Server

When you install SQL Server, it modifies a couple of Windows NT settings. As long as the machine is dedicated to SQL Server, you should leave these settings alone. If the machine will run other applications, however, you may find it useful to change them.

SQL Server modifies the following Windows NT settings:

  • Application Performance. SQL Server sets this so that foreground and background tasks are equally responsive. (The NT default gives priority to foreground tasks.)

  • Maximize Throughput. SQL Server sets this to maximize throughput for network operations. (The NT default maximizes throughput for file-sharing operations.)

To change the setting for Application Performance, right-click My Computer and choose Properties. The System Properties dialog box shown in Figure 3.7 displays. The Application Performance option is on the Performance tab.

Figure 3.7 NT's Application Performance setting.

If you want to give more priority to foreground applications, move the slider to the right.

To modify the Maximize Throughput option, open the Network applet in Control Panel. On the Services tab, highlight Server and choose Properties. The screen shown in Figure 3.8 displays.

Figure 3.8 Server Properties dialog box in NT.

You can change the settings as necessary to benefit other applications on the machine. It's also a good idea to uncheck Make Browser Broadcasts to LAN Manager 2.x Clients if you don't have any of those (and you probably don't!). This broadcast could announce the name of your server to hackers.

  • + Share This
  • 🔖 Save To Your Account