Tuesday, November 15, 2011

Essential Counters for Performance Monitoring

The goals of performance monitoring i always think about are:

- Health indicator: it will show you if the current status of your application farm is in good shape or not; or let you predict the trend;
- Find out the bottleneck of your system from a high level, it is really helpful for Engineers to get start to get issue fixed;
- Help to do trouble shooting: the counters will drive us to the right direction from different angles to find the root cause instead of "smart guess";
- Operation management: Capacity Planning and Risk management, try to resolve any performance or stability issues before it comes!





Counters For OSExplaination
Server Uptimeelapse time since server recent start up
Processor--Total CPU%the percentage of elapsed time that the processor spends to execute a non-Idle thread.
Processor--% User Timethe percentage of elapsed time the processor spends in the user mode.
System--Processor Queue Lengththe number of threads in the processor queue. There is a single queue for processor time even on computers with multiple processors. Therefore, if a computer has multiple processors, you need to divide this value by the number of processors servicing the workload. A sustained processor queue of less than 10 threads per processor is normally acceptable, dependent of the workload.
Memory--% MEM in usethe ratio of Memory\\Committed Bytes to the Memory\\Commit Limit.
Memory--pages/secthe rate at which pages are read from or written to disk to resolve hard page faults.
Disk Space--DISK C:the percentage of Used space on Disk C
Disk Space--DISK D:the percentage of Used space on Disk D
Disk Space--DISK E:the percentage of Used space on Disk E
DISK IO --Avg. Disk Queue Lengththe average number of both read and write requests that were queued for the selected disk during the sample interval.
DISK IO --% Disk Timethe percentage of elapsed time that the selected disk drive was busy servicing read or write requests.
DISK IO --Avg. Disk sec/Readthe average time, in seconds, of a read of data from the disk.
DISK IO --Avg. Disk sec/Writethe average time, in seconds, of a write of data to the disk.
DISK IO --Disk Reads/secthe rate of read operations on the disk.
DISK IO --Disk Writes/secthe rate of write operations on the disk.
NetWork IO--Packets Sent/secthe rate at which packets are sent on the network interface.
NetWork IO--Packets received/secthe rate at which packets are received on the network interface.
TCP--TCP Connections ESTthe number of TCP connections for which the current state is either ESTABLISHED or CLOSE-WAIT
Total Process cntTotal number of processes on the server


Counters For Specific Process instanceExplaination
Apache Http Server -- Apache Process
Process Uptimeelapse time since apache process recent start up
Process CPU%the percentage of elapsed time that the processor spends on Apache Process.
Process Memory in useMemory usage by apache process
Busy workers cntthe number of threads which are in use for requests
Idle workers cntthe number of threads which are not receiving any request
requests/secthroughput of apache Http server
KB/secthroughput of apache Http server
Application Server -- Java Process
Process Uptimeelapse time since java process recent start up
Process CPU%the percentage of elapsed time that the processor spends on java Process.
Private Bytesthe current size, in bytes, of memory that this process has allocated that cannot be shared with other processes.
Working SetWorking Set is the current size, in bytes, of the Working Set of this process. The Working Set is the set of memory pages touched recently by the threads in the process
Used Heap SizeJVM Heap size is in use currently
Live Threads cntThe number of threads currently active in this process
Accumulate GCTimethe total time taken by GC activities
Async Server--JMS MQ Process
Process Uptimeelapse time since JMS process recent start up
Process CPU%the percentage of elapsed time that the processor spends on JMS Process.
Private Bytesthe current size, in bytes, of memory that this process has allocated that cannot be shared with other processes.
Working SetWorking Set is the current size, in bytes, of the Working Set of this process. The Working Set is the set of memory pages touched recently by the threads in the process
Message Queue Depththe current number of messages that are waiting on the queue
DLQ cntthe current number of messages which in Dead Letter Queue
Live Threads cntThe number of threads currently active in this process
DB Connections cntthe current number of open database connections used by this process
DB Server -- SQL Server Process
Process Uptimeelapse time since SQL Server process recent start up
Process CPU%the percentage of elapsed time that the processor spends on SQL Server Process.
Process Memory in useMemory usage by SQL Server process
Free Space in Temp DBTracks free space in tempdb in kilobytes
User Connectionsthe current number of connections (and users) are using the server
Buffer Cache Hit Ratioindicates how often SQL Server goes to the buffer, not the hard disk, to get data. Had better larger than 90%
Full Scans/Secthe number of unrestricted full scans during unit time. These can either be base table or full index scans.
Transactions/SecThe number of transactions started for the database during unit time
Average Wait Timethe average amount of wait time (milliseconds) for each lock request that resulted in a wait

More counters you add and higher granularity you made will bring more overhead to your system, you should make trade offs on selecting counters and sample interval.There is no silver bullet after all...

No comments:

Post a Comment