Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm trying to optimize my SQL Server 2008 instances on Windows cluster (on Windows Server 2008). I'm having several SQL Server instances on two cluster nodes. I was thinking that should I enable the "priority boost option" on every instance? What are the pros and cons of using this option in my situation?

share|improve this question
up vote 4 down vote accepted

That can let the core processes of the OS to starve for resources. It is suggested not to enable that option.

share|improve this answer
Agreed. I've also seen cases where SQL Server's priority has exceeded the hardware manufacturer's driver priority, and the drivers haven't been able to get the CPU time they need to keep up with SQL Server. Caused a bluescreen at StackOverflow, believe it or not. – Brent Ozar Oct 18 '10 at 1:23

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.