When tempdb write latency points below SQL Server
During a recent performance review on a SQL Server 2019 instance (AlwaysOn Failover Cluster Instance, bare-metal), one number stood out. This post follows the investigation: from a latency figure in a DMV, down the I/O path to a RAID controller setting nobody had ever chosen. The starting point: one number from a health check The I/O statistics of the instance…



