Use of Priority Boost in Cluster

Hi,

I am running SQL Server 2000 (SP3A) Enterprise on Windows 2000 Cluster, and am currently experiencing performance slowness. Among the many things to be looked at, I want to know particularly whether I can sp_configure the SQL Server priority boost to 1 I read an article from Microsof (http://support.microsoft.com/kb/319942/) that this is not to be done in clusters. I also have read discussions from other DBAs that it may be OK.

The cluster is a 2-node cluster, each owns one named instance of SQL Server. And the cluster is dedicated to running SQL Server.

Any help will be greatly appreciated.

Answer this question

Use of Priority Boost in Cluster

Marauderz
Under clustering, when the node fails over, the cluster service must do an unmount on the failed node, reserve and mount the shared disk on the backup node (search for 'scsi reservation' if you want more info). So, setting 'priority boost' for sqlserver can put the system into a race condition where sqlserver tries to startup before the disk/resource has been reserved/mounted.
Predator14567
I have personally went "round and round" regarding the priority boost setting and I also lucky enough to have Roger Wolter as a good friend who I ask occasional SQL Questions. In Roger's opinion and from my own experience with the setting...DONT USE IT! In general the setting CAN cause more bad then good. I would suggest you look at memory first and then drive/CPU if you want to scale up hardware.

D
DarkPressure
oj has a much better reply to this thread, he deserves the answer.
Use of Priority Boost in Cluster

Answer this question