Performance counters

Performance Object	Counter	Instance	Remarks
Memory	Pages/Sec		Rate of hard page faults; Average value <>
Physical Disk	Average Disk Queue Length		Average number of queued disk requests; Average value <>
Processor	% Processor Time	_Total	Average value <>
SQL Server: Access Methods	Freespace scans/sec		The areas where the count increases need to be monitored and proper indexes introduced to avoid such scans.
SQL Server: Access Methods	Full scans/sec		The areas where the count increases need to be monitored and indexes revisited.
SQL Server: Buffer Manager	Buffer Cache Hit Ratio		% of requests served out of the buffer cache; Average value >= 90%
SQL Server: Locks	Lock timeouts/sec	_Total	Should be 0
SQL Server: Locks	Lock wait time (ms)	_Total	Should be low
SQL Server: Memory Manager	Memory Grants Pending		Number of processes waiting for workspace memory grant; Average value = 0
SQL Server: SQL Statistics	SQL Re-compilations/sec		Should be 0 or near it
System	Processor Queue Length		Number of requests outstanding on the processor: Average value <>
System	Context Switches/sec		Rate of switching processors from one thread to another: Average value <>