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/
|