Data drive with incorrect cluster size

It is best practise to format the data drive with 64 KB NTFS cluster size.

To query the Performance Store database for data drives with incorrect cluster sizes, use:

select c.*
from dbo.v_capacity c
where c.sample_id in
(
 select top 1 xs.sample_id
 from dbo.execution_info xs
 order by xs.sample_time desc
)
and c.default_drive_type in ('data', 'data and log')
and c.block_size_bytes != 65536

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.