2008年9月10日 星期三

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

沒有留言: