Database Server Counters

Category	Counter Name	Counter description
System	Total Processor Time	The CPU time that the database process consumes. Represented in different databases in different names. For example, in Oracle, the counter is called the CPU used by this session
	User Connection	The current number of user connections. The database server generally has the limit of the number of user connections, when the application is unreasonable, it is possible that the number of connections exceeded the limit, resulting in some abnormal occurrence
Memory	Cache hit Ratio	Cache hit ratio. When the value is small and the database is busy, you may need to resize the cache
	Total Server Memory (SQL Server only)	The amount of memory currently used by the SQL Server database process. Combined with some other counters, such as Connectionmemory, SQL Cache memory, Lock memory, etc., it is clear to know the use of Memory
	PGA Memory/uga Memory (Oracle only)	Memory usage for Oracle database processes
Lock	Average Wait Time	Lock average Wait time
	Lock request/sec	Number of lock requests per second
	Number of Deadlocks/sec	The number of deadlocks produced per second. When the counter value is large, you need to find out why the deadlock occurred
/ o	Outstanding Reads (writes)	The physical read and write that is suspended. May be CPU, disk I/O bottlenecks, and can be understood by the CPU and I/O analysis of the server for further reasons
	Page reads/sec	Number of pages read/write per second
	Transactions/sec	Number of things produced per second

Database Server Counters