Drive differences

Comments are closed
How can we help?
< All Topics
Print

Drive differences

An alert will be thrown, if two SQL Servers are a failover pair, and there are differences in the disk drives between the two servers. E.g. one server is using 4 KB NTFS cluster size and the other server is using 64 KB NTFS cluster size, then there will be a performance difference in case of a failover.

To query the Performance Store database for disk drive differences, use:

exec dbo.s_drive_diff '[server 1]', '[server 2]'

It is also possible to use the Database Finder to quickly identify disk drive differences, or to verify the integrity between two failover nodes. For more information see: Integrity between failover nodes.

The alert will be visible on the Latest stats dashboard.

To exclude specific servers from this alert, see how to use the dbo.team_alert_exclude table in Alerting.

Table of Contents