Most significant perfmon counters for MS SQL server


Memory

Available MBytes

Memory

Free System Page Table Entries

Memory

Pages/Sec

Paging File

%Usage

Paging File

%Usage Peak

Processor

Processor Time

Process(sqlservr)

% Privileged Time

Process(sqlservr)

% Processor Time

PhysicalDisk

Avg. Disk sec/Read

PhysicalDisk

Avg. Disk sec/Write

SQLServer:Access Methods

Forwarded Records/sec

SQLServer:Access Methods

FreeSpace Scans/sec

SQLServer:Access Methods

Full Scans/sec

SQLServer:Access Methods

Index Searches/sec

SQLServer:Access Methods

Page Splits/sec

SQLServer:Access Methods

Scan Point Revalidations/sec

SQLServer:Access Methods

Workfiles Created/sec

SQLServer:Access Methods

Worktables Created/sec

SQLServer:Buffer Manager

Buffer cache hit ratio

SQLServer:Buffer Manager

Checkpoint pages/sec

 

SQLServer:Buffer Manager

Free pages

SQLServer:Buffer Manager

Lazy writes/sec

SQLServer:Buffer Manager

Page life expectancy

SQLServer:Buffer Manager

Page lookups/sec

SQLServer:Buffer Manager

Page reads/sec

SQLServer:Buffer Manager

Page writes/sec

SQLServer:Cursor Manager by Type

Cursor Requests/sec

SQLServer:General Statistics

Processes Blocked

SQLServer:Latches

Latch Waits/sec

SQLServer:Latches

Total Latch Wait Time (ms)

SQLServer:Locks

Lock Waits/sec

SQLServer:Locks

Lock Wait Time (ms)

SQLServer:Locks

Lock Timeouts (timeout > 0)/sec

SQLServer:Locks

Number of Deadlocks/sec

SQLServer:Memory Manager

Memory Grants Pending

SQLServer:Memory Manager

Target Server Memory (KB)

SQLServer:Memory Manager

Total Server Memory (KB)

SQLServer:SQL Statistics

Batch Requests/sec

SQLServer:SQL Statistics

SQL Compilations/sec

SQLServer:SQL Statistics

SQL Re-Compilations/sec

SQL Server:Wait Statistics

Lock waits

SQL Server:Wait Statistics

Log write waits

SQL Server:Wait Statistics

Network IO waits

SQL Server:Wait Statistics

Non-Page latch waits

SQL Server:Wait Statistics

Page IO latch waits

SQL Server:Wait Statistics

Page latch waits

SQL Server:Wait Statistics

Wait for the worker


Comments (0)

Skip to main content