Chinaunix

标题: IOPS监控 [打印本页]

作者: sss0213 时间: 2011-12-21 08:42
标题: 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

转自：http://social.technet.microsoft.com/Forums/en-US/operationsmanagergeneral/thread/92ad3a22-49fb-4e60-9573-8b6f629cbbe9/

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)