'Priority boost' sp_configure option and SQL Server failover clustering

'Priority boost' sp_configure option and SQL Server failover clustering

  • Comments 1

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

Comments
Leave a Comment
  • Please add 4 and 3 and type the answer here:
  • Post