IOPS metrics available in the SQL Server agent (4295925)

Where can we find the IOPS metrics for a SQL Server host?

IOPS (Input/Output Operations Per Second, pronounced eye-ops) is a common performance measurement used to benchmark computer storage devices like hard disk drives (HDD), solid state drives (SSD), and storage area networks (SAN).

Two IOPS metrics are available on the SQL Server agent Real-Time Home Page and can also be drilled from the Activity menu | SQL I/O Activity page.

The Real-Time Home Page contains up to the past one hour of metrics. The SQL I/O Activity has a zonar and has extended historical metrics available for view.

Metric name: Physical Page Reads Rate
Collection name: Buffer Manager
Description: The rate per second at which pages are read to disk through a physical page read.
Topology location: Dashboards > Configuration > Data > Management Server > All Data > DBSS Data Model > SQL Server Data Model > Clusters > Agent Name > Instances > Buffer Manager> Phys Page Reads Rate

Metric name: Physical Page Writes Rate
Collection name: Buffer Manager
Description: The rate per second at which pages are written to disk through a physical page write.
Topology location: Dashboards > Configuration > Data > Management Server > All Data > DBSS Data Model > SQL Server Data Model > Clusters > Agent Name > Instances > Buffer Manager> Phys Page Writes Rate