Configuring Server Tasking

If you plan on connecting to SQL Server from local clients, it's a good idea to set up the server so that foreground and background applications run with equal priority. This allows SQL Server¾which runs as a background application¾to run at equal priority with other applications (such as client applications) that might be running in the foreground.

When you run the setup program, server tasking is set appropriately for SQL Server. To change it back to the Windows NT default, use the following procedure.

    To change server tasking 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 System icon.

   The System dialog box appears.

3. Choose the Tasking button.

   The Tasking dialog box appears.

   

4. Select a Foreground/Background Responsiveness option.

   The Windows NT default is Best Foreground Application Response Time. SQL Server setup changes this to Foreground and Background Applications Equally Responsive.

5. Choose the OK button.

   The System dialog box returns.

6. Choose the OK button again.