Mohan avatar image
Mohan 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....
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

TimothyAWiseman avatar image TimothyAWiseman commented ·
I am not entirely sure what you are asking here. Could you perhaps clarify?
0 Likes 0 ·

1 Answer

Grant Fritchey avatar image
Grant Fritchey answered
The best place to go for complete documentation of the information gathered by these counters is the Microsoft Developer's Network site: 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: 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:
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

DirkHondong avatar image DirkHondong commented ·
I can recommend Grant's book too. I only own the 2008 version, but I think it just got better.
2 Likes 2 ·
Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
Assuming you didn't get messed up on-demand version. That's supposedly been fixed now though. Thanks!
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.