| SQL Server 2005 Database Engine Performance Counters | |||
| SQLServer:Access Methods | SQLServer:Buffer Manager | SQLServer:Buffer Node | SQLServer:Buffer Partition |
| AU cleanup batches/sec | AWE lookup maps/sec | Database pages | Free list empty/sec |
| AU cleanups/sec | AWE stolen maps/sec | Foreign pages | Free list requests/sec |
| By-reference Lob Create Count | AWE unmap calls/sec | Free pages | Free pages |
| By-reference Lob Use Count | AWE unmap pages/sec | Page life expectancy | |
| Count Lob Readahead | AWE write maps/sec | Stolen pages | SQLServer:Databases |
| Count Pull In Row | Buffer cache hit ratio | Target pages | Active Transactions |
| Count Push Off Row | Buffer cache hit ratio base | Total pages | Backup/Restore Throughput/sec |
| Deferred dropped AUs | Checkpoint pages/sec | Bulk Copy Rows/sec | |
| Deferred Dropped rowsets | Database pages | SQLServer:Cursor Manager by Type | Bulk Copy Throughput/sec |
| Dropped rowset cleanups/sec | Free list stalls/sec | Active cursors | Data File(s) Size (KB) |
| Dropped rowsets skipped/sec | Free pages | Cache Hit Ratio | DBCC Logical Scan Bytes/sec |
| Extent Deallocations/sec | Lazy writes/sec | Cache Hit Ratio Base | Log Bytes Flushed/sec |
| Extents Allocated/sec | Page life expectancy | Cached Cursor Counts | Log Cache Hit Ratio |
| Failed AU cleanup batches/sec | Page lookups/sec | Cursor Cache Use Counts/sec | Log Cache Hit Ratio Base |
| Failed leaf page cookie | Page reads/sec | Cursor memory usage | Log Cache Reads/sec |
| Failed tree page cookie | Page writes/sec | Cursor Requests/sec | Log File(s) Size (KB) |
| Forwarded Records/sec | Readahead pages/sec | Cursor worktable usage | Log File(s) Used Size (KB) |
| FreeSpace Page Fetches/sec | Reserved pages | Number of active cursor plans | Log Flush Wait Time |
| FreeSpace Scans/sec | Stolen pages | Log Flush Waits/sec | |
| Full Scans/sec | Target pages | SQLServer:Cursor Manager Total | Log Flushes/sec |
| Index Searches/sec | Total pages | Async population count | Log Growths |
| LobHandle Create Count | Cursor conversion rate | Log Shrinks | |
| LobHandle Destroy Count | SQLServer:Catalog Metadata | Cursor flushes | Log Truncations |
| LobSS Provider Create Count | Cache Entries Count | Percent Log Used | |
| LobSS Provider Destroy Count | Cache Entries Pinned Count | SQLServer:Exec Statistics | Repl. Pending Xacts |
| LobSS Provider Truncation Count | Cache Hit Ratio | Distributed Query | Repl. Trans. Rate |
| Mixed page allocations/sec | Cache Hit Ratio Base | DTC calls | Shrink Data Movement Bytes/sec |
| Page Deallocations/sec | Extended Procedures | Transactions/sec | |
| Page Splits/sec | SQLServer:CLR | OLEDB calls | |
| Pages Allocated/sec | CLR Execution | SQLServer:Plan Cache | |
| Probe Scans/sec | SQLServer:Locks | Cache Hit Ratio | |
| Range Scans/sec | SQLServer:General Statistics | Average Wait Time (ms) | Cache Hit Ratio Base |
| Scan Point Revalidations/sec | Active Temp Tables | Average Wait Time Base | Cache Object Counts |
| Skipped Ghosted Records/sec | Event Notifications Delayed Drop | Lock Requests/sec | Cache Objects in use |
| Table Lock Escalations/sec | HTTP Authenticated Requests | Lock Timeouts (timeout > 0)/sec | Cache Pages |
| Used leaf page cookie | Logical Connections | Lock Timeouts/sec | |
| Used tree page cookie | Logins/sec | Lock Wait Time (ms) | SQLServer:SQL Statistics |
| Workfiles Created/sec | Logouts/sec | Lock Waits/sec | Auto-Param Attempts/sec |
| Worktables Created/sec | Mars Deadlocks | Number of Deadlocks/sec | Batch Requests/sec |
| Worktables From Cache Base | Non-atomic yield rate | Failed Auto-Params/sec | |
| Worktables From Cache Ratio | Processes blocked | SQLServer:Memory Manager | Forced Parameterizations/sec |
| SOAP Empty Requests | Connection Memory (KB) | Safe Auto-Params/sec | |
| SQLServer:Latches | SOAP Method Invocations | Granted Workspace Memory (KB) | SQL Attention rate |
| Average Latch Wait Time (ms) | SOAP Session Initiate Requests | Lock Blocks | SQL Compilations/sec |
| Average Latch Wait Time Base | SOAP Session Terminate Requests | Lock Blocks Allocated | SQL Re-Compilations/sec |
| Latch Waits/sec & | |||