'Priority boost' sp_configure option and SQL Server failover clustering
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
- Anonymous
January 08, 2009
PingBack from http://www.codedstyle.com/priority-boost-sp_configure-option-and-sql-server-failover-clustering/