Blitz Result: Cluster Node

Clustering helps you achieve higher availability by wiring up more than one server to the same set of shared drives.  If one server has a catastrophic problem like failures in Windows, the motherboard, the memory, the network cards, etc, then SQL Server will automatically restart on another server connected to the same storage.

Clustering is a wonderful thing, but it changes the way you tweak certain settings in SQL Server like min memory.  We have to make sure that when instances fail over, we can still run all of them on the same node.

This part of our SQL Server sp_Blitz script checks sys.dm_os_cluster_nodes looking for entries.  We don’t do anything fancy like checking the health of the cluster or which nodes are involved – we just want you to know you’re working on one.

You can learn more about SQL Server clustering in the excellent book, Pro SQL Server 2008 Failover Clustering by Allan Hirt.

To Fix the Problem

Nothin’ to fix here – just something to be aware of.

Return to sp_Blitz or Ask Us Questions