Configuring Server Tasking

If you plan to connect to Microsoft SQL Server from a local client (a client running on the same computer as the server), you can improve processing time by setting up the server to run foreground and background applications with equal priority. SQL Server then runs as a background application at equal priority to other applications running in the foreground. For more information, see the Windows Server 2003 documentation.


When you run SQL Server Setup, server tasking is set to none in Windows Server 2003 (the SQL Server default), which gives foreground and background programs equal processor time. You can set the server tasking setting to maximum or applications (the Windows Server 2003 default), which gives foreground applications the most processor time.

For more information about configuring server tasking, see the Windows Server 2003 operating system documentation.

Community Additions