Common performance counters for SQL Server servers

A common performance counter for SQL Server servers, in this flag.

Performance object	Counter	Description
Processor	%processor time %privileged time	Recommended value: lasts less than 80 Recommended value: lasts less than 10
System	Processor Queue Length	Thread Queue Length waiting for processor Recommended value: This value/cpu number < 2
Memory	Available Mbytes	Reserve 20% of physical memory for the operating system
	Pages/sec Page faults/sec	Recommended value: Below (hard fault) Page access error, including hard, Soft
Page File	%usage %peak Usage	Recommended value: Less than 70% Peak usage of virtual memory files
PhysicalDisk (LogicalDisk)	%disk time %Idle time	Disk read and write time percentage, inaccurate, mainly look at the trend; Percentage of disk idle time, accurate
	Avg. Disk Queue Length	Disk queues, Should theoretically not be longer than 2
	Disk bytes/sec AVG. Disk Sec/transfer AVG. Disk Sec/read AVG. Disk Write/sec	The sum of the number of disk reads and writes per second, the very conservative value should be greater than 20MB; Three other parameters, reference value: < 10ms
Network Interface	Bytes total/sec	Gigabit NIC, reference value: < 7mb/sec Gigabit NIC, reference value: < 70mb/sec
	Output Queue Length	Reference value: < 2
SQL server:memory Manager	Total Server Memory (KB) Target Server Memory (KB)	Total indicates the size of the cache currently in use Target indicates the total amount of memory that SQL Server can use; If total is less than the target value, it means that SQL Server is not fully using the OS allocated memory, and it constantly caches new data and execution plans
SQL Server:buffermanager	Buffer Cach hit Ratio	Reference value: > 97%
SQL server:general Statistics	User Connections	Number of user connections
SQL Server:sql Statistics	Batch requests/sec	Number of SQL requests per second
SQL server:databases	Transaction/sec	Number of transactions per second
	Data File (s) Size (KB) Log File (s) Size (KB) Log growths	Data File Size Log file size Total number of log file expansion

Common performance counters for SQL Server servers