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, which runs as a background application, then runs at equal priority to other applications running in the foreground.
Note When you run SQL Server Setup, server tasking is set to none (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), which gives foreground applications the most processor time.
To configure server tasking