June 14, 2004 at 8:24 am
In SQL Server 2000 Properties/Processor
there is an option
"Boost SQl Server priority on Windows"
Shall I turn this feature on?
June 14, 2004 at 8:51 am
Yes.
June 14, 2004 at 8:53 am
But what exactly this thing does?
Details please.
June 14, 2004 at 10:57 am
It makes the SQL Server process run with a higher priority than other processes on the computer. This will make the OS to prioretize (give more time) to SQL Server when several processes compete for the resources.
See "priority boost option" in BOL.
/rockmoose
You must unlearn what You have learnt
June 15, 2004 at 3:18 am
Boost priority should only be used when the server is being used for multiple purposes (such as a web server and SQL server)
The boost priority will only affect the SQL server when CPU usage is high, so should only be used if the server is running low on processing power.
Chosing this option whe CPU usage is low or when there are no other services may cause SQL server to consume resources required by the operating system resulting in poor network performance, poor disk performance and difficulty shutting down applications and services.
MVDBA
June 15, 2004 at 3:51 am
It is recommended that you run your SQL Server on a dedicated server. If so there is no reason for boosting the SQL Server processes..
June 19, 2004 at 12:48 pm
I used both options .I couldn't find great differences between checking the options or not.So I think it's safe to experiment with the option and decide what is best for you .
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply