'Priority boost' sp_configure option and SQL Server failover clustering

  • Article

Hello again !

This is yet another post on SQL Server failover clustering. Hope you don't mind :).

I was working the other day on the case and customer had a SQL Server 2005 cluster. As I was looking at output of sp_configure I noticed that it had 'priority boost' option set to 1 on a cluster. Microsoft discourages set 'priority boost' option on a cluster. This fact is documented in the following article. The reason for this is that

it may cause
failovers on a cluster system due to OS resource starvation since SQL Server
runs at a higher priority.

-Yuriy