up vote 1 down vote favorite
share [g+] share [fb]

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?

link|improve this question
feedback

1 Answer

up vote 3 down vote accepted

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

link|improve this answer
1  
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
feedback

Your Answer

 
or
required, but never shown
discard