IOPS监控

Create Performance Collection rules targeted to a SQL Server computer group for the following performance counters:

·         LogicalDisk(*)\Avg Disk sec/Read

o   Should be under 20ms.  Beyond 50ms is very bad

·         LogicalDisk(*)\Avg Disk sec/Write

o   Should be under 20ms.  Beyond 50ms is very bad

·         LogicalDisk(*)\Disk Read Bytes/sec

·         LogicalDisk(*)\Disk Reads/sec

o   The Reads and Read Bytes/sec counters can be used on conjunction with the Writes and Write Bytes/sec counters to see the ratio of Reads/Writes your database is doing.  This will help determine the optimal RAID configuration to optimize for reads, writes, or a balance of both.

·         LogicalDisk(*)\Disk Write Bytes/sec

·         LogicalDisk(*)\Disk Writes/sec

·         MSSQL:Buffer Manger\Buffer cache hit ratio

o   This should be as close to 100% as possible.  Below 97-98% indicates SQL server needs more physical memory.  If you are much below that, the SQL Server needs more memory.

·         MSSQL:Buffer Manger\Page Lookups/sec

·         MSSQL:Buffer Manger\Page reads/sec

·         MSSQL:Buffer Manger\Page writes/sec

转自：