How can we help?
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.