asked
Performance Counters
1)Memory related counters: \SQLServer:Memory Manager\SQL Cache Memory (KB) \SQLServer:Memory Manager\Target Server Memory (KB) \SQLServer:Memory Manager\Total Server Memory (KB) \Memory\Available Bytes \Memory\Pages/sec 2)Net Work related counters \MSOLAP$SQLSERVER_NAMED:Storage Engine Query\Avg time/query \MSOLAP$SQLSERVER_NAMED:Storage Engine Query\Network round trips/sec \Network Interface(*)\Bytes Total/sec \Network Interface(*)\Packets/sec \Network Interface(*)\Packets Received/sec \Network Interface(*)\Packets Sent/sec \Network Interface(*)\Current Bandwidth \Network Interface(*)\Bytes Received/sec \Network Interface(*)\Packets Received Unicast/sec \Network Interface(*)\Packets Received Non-Unicast/sec \Network Interface(*)\Packets Received Discarded \Network Interface(*)\Packets Received Errors \Network Interface(*)\Packets Received Unknown \Network Interface(*)\Bytes Sent/sec \Network Interface(*)\Packets Sent Unicast/sec \Network Interface(*)\Packets Sent Non-Unicast/sec \Network Interface(*)\Packets Outbound Discarded \Network Interface(*)\Packets Outbound Errors \Network Interface(*)\Output Queue Length \Network Interface(*)\Offloaded Connections 3)Physical disk related counters. \PhysicalDisk(*)\Current Disk Queue Length \PhysicalDisk(*)\% Disk Time \PhysicalDisk(*)\Avg. Disk Queue Length \PhysicalDisk(*)\% Disk Read Time \PhysicalDisk(*)\Avg. Disk Read Queue Length \PhysicalDisk(*)\% Disk Write Time \PhysicalDisk(*)\Avg. Disk Write Queue Length \PhysicalDisk(*)\Avg. Disk sec/Transfer \PhysicalDisk(*)\Avg. Disk sec/Read \PhysicalDisk(*)\Avg. Disk sec/Write \PhysicalDisk(*)\Disk Transfers/sec \PhysicalDisk(*)\Disk Reads/sec \PhysicalDisk(*)\Disk Writes/sec \PhysicalDisk(*)\Disk Bytes/sec \PhysicalDisk(*)\Disk Read Bytes/sec \PhysicalDisk(*)\Disk Write Bytes/sec \PhysicalDisk(*)\Avg. Disk Bytes/Transfer \PhysicalDisk(*)\Avg. Disk Bytes/Read \PhysicalDisk(*)\Avg. Disk Bytes/Write \PhysicalDisk(*)\% Idle Time \PhysicalDisk(*)\Split IO/Sec Need more information on the performance counters with good examples....
I am not entirely sure what you are asking here. Could you perhaps clarify?
The best place to go for complete documentation of the information gathered by these counters is the Microsoft Developer's Network site:
http://www.msdn.com They list all that stuff out. But if you want to know which of these is actually important and what meaningful numbers might look like, I'd like to suggest starting with my book, SQL Server 2012 Query Performance Tuning:
http://www.amazon.com/Server-2012-Query-Performance-Tuning/dp/1430242035/ref=sr_1_1?ie=UTF8&qid=1340298160&sr=8-1&keywords=fritchey Chapter 2 covers the better metrics to collect in order to understand what's happening on your server. Another good resource is the Troubleshooting for the Accidental DBA. You can get that book for free in electronic format, or pay for it in print:
http://www.amazon.com/Troubleshooting-SQL-Server-Guide-Accidental/dp/1906434786/ref=sr_1_1?ie=UTF8&qid=1340298201&sr=8-1&keywords=accidental+dba
I can recommend Grant's book too. I only own the 2008 version, but I think it just got better.
Assuming you didn't get messed up on-demand version. That's supposedly been fixed now though. Thanks!
11 People are following this question.
