SQL 2005 重要效能計數物件(Performance Counter)及建議值

列舉部份供參考：

Object	Counter	Preferred Value
Memory	Available Mbytes	> 100MB
Paging File	%Usage	< 70%
Process (sqlservr)	%Privileged Time	< 30% of %Processor Time (sqlservr)
Processor	%Privileged Time	< 30% of Total %Processor Time
PhysicalDisk	Avg. Disk Sec/Read	< 8ms
PhysicalDisk	Avg. Disk sec/Write	< 8ms (non cached) < 1ms (cached)
SQLServer:Access Methods	Forwarded Records/sec	< 10 per 100 Batch Requests/Sec
SQLServer:Access Methods	FreeSpace Scans/sec	<10 per 100 Batch Requests/Sec
SQLServer:Access Methods	Full Scans / sec	(Index Searches/sec)/(Full Scans/sec) > 1000
SQLServer:Access Methods	Workfiles Created/Sec	< 20 per 100 Batch Requests/Sec
SQLServer:Access Methods	Worktables Created/Sec	< 20 per 100 Batch Requests/Sec
SQL Server:Buffer Manager	Buffer Cache hit ratio	> 90%
SQL Server:Buffer Manager	Free list stalls/sec	< 2
SQL Server:Buffer Manager	Lazy Writes/Sec	< 20
SQL Server:Buffer Manager	Page Life Expectancy	> 300
SQLServer:Buffer Manager	Page lookups/sec	(Page lookups/sec) / (Batch Requests/sec) < 100
SQL Server:Locks	Lock Requests/sec	(Lock Request/sec)/(Batch Requests/sec) < 500
SQLServer:SQL Statistics	SQL Compilations/sec	< 10% of the number of Batch Requests/Sec
SQLServer:SQL Statistics	SQL Re-Compilations/sec	< 10% of the number of SQL Compilations

詳細資訊：

TechNet Webcast: SQL Server Performance Counter Guidance (Level 300)

http://www.microsoft.com/events/EventDetails.aspx?CMTYSvcSource=MSCOMMedia&Params=%7eCMTYDataSvcParams%5e%7earg+Name%3d%22ID%22+Value%3d%221032357640%22%2f%5e%7earg+Name%3d%22ProviderID%22+Value%3d%22A6B43178-497C-4225-BA42-DF595171F04C%22%2f%5e%7earg+Name%3d%22lang%22+Value%3d%22en%22%2f%5e%7earg+Name%3d%22cr%22+Value%3d%22US%22%2f%5e%7esParams%5e%7e%2fsParams%5e%7e%2fCMTYDataSvcParams%5e