Configuring Server Tasking
If you plan to connect to Microsoft® SQL Server™ 2000 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, which runs as a background application, then runs at equal priority to other applications running in the foreground. For more information, see the Windows NT® or Windows 2000 documentation.
Note When you run SQL Server Setup, server tasking is set to none in Microsoft Windows NT 4.0 and background services in Microsoft Windows 2000 (the SQL Server default), which gives foreground and background programs equal processor time. You can set the server tasking setting to maximum (the Microsoft Windows NT default) or applications (the Microsoft Windows 2000 default), which gives foreground applications the most processor time.