Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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.

share|improve this answer
2  
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

 
discard

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