Skip to main content
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]'

Note, server name should not include port number or instance name, but should be the actual name of the server.

When comparing drive sizes, the capacity will be rounded to nearest GB before it is compared. This is due to some OS reporting a marginal size difference even for identical disks. Sizes for mount points are not compared, as mount points can have different size limits.

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