| Category | CounterName | InstanceName | Value | CntrType | Interpretation |
|---|---|---|---|---|---|
| Access Methods | Full Scans/sec | 80181 | 272696576 | ||
| Access Methods | Index Searches/sec | 10175947 | 272696576 | ||
| Buffer Manager | Buffer cache hit ratio | 1865 | 537003264 | ||
| Buffer Manager | Checkpoint pages/sec | 1794 | 272696576 | ||
| Buffer Manager | Free list stalls/sec | 0 | 272696576 | ||
| Buffer Manager | Lazy writes/sec | 0 | 272696576 | ||
| Buffer Manager | Page life expectancy | 411205 | 65792 | ||
| General Statistics | Active Temp Tables | 29 | 65792 | ||
| General Statistics | Processes blocked | 0 | 65792 | ||
| General Statistics | Temp Tables Creation Rate | 3619 | 272696576 | ||
| General Statistics | User Connections | 7 | 65792 | ||
| Locks | Lock Waits/sec | _Total | 30 | 272696576 | |
| Locks | Number of Deadlocks/sec | _Total | 0 | 272696576 | |
| Memory Manager | Memory Grants Pending | 0 | 65792 | ||
| Memory Manager | Stolen Server Memory (KB) | 1498952 | 65792 | ||
| Memory Manager | Target Server Memory (KB) | 12317760 | 65792 | ||
| Memory Manager | Total Server Memory (KB) | 1692192 | 65792 | ||
| Plan Cache | Cache Hit Ratio | Temporary Tables & Table Variables | 261 | 537003264 | |
| Plan Cache | Cache Hit Ratio | Extended Stored Procedures | 613 | 537003264 | |
| Plan Cache | Cache Hit Ratio | Bound Trees | 473 | 537003264 | |
| Plan Cache | Cache Hit Ratio | SQL Plans | 433 | 537003264 | |
| Plan Cache | Cache Hit Ratio | Object Plans | 939 | 537003264 | |
| Plan Cache | Cache Hit Ratio | _Total | 2719 | 537003264 | |
| Plan Cache | Cache Hit Ratio Base | _Total | 3278 | 1073939712 | |
| Plan Cache | Cache Hit Ratio Base | Object Plans | 944 | 1073939712 | |
| Plan Cache | Cache Hit Ratio Base | SQL Plans | 888 | 1073939712 | |
| Plan Cache | Cache Hit Ratio Base | Bound Trees | 508 | 1073939712 | |
| Plan Cache | Cache Hit Ratio Base | Extended Stored Procedures | 613 | 1073939712 | |
| Plan Cache | Cache Hit Ratio Base | Temporary Tables & Table Variables | 325 | 1073939712 | |
| SQL Statistics | Batch Requests/sec | 38559 | 272696576 | ||
| SQL Statistics | SQL Compilations/sec | 27558 | 272696576 | ||
| SQL Statistics | SQL Re-Compilations/sec | 1134 | 272696576 | WARNING: High re-compilation rate - check SET options and schema changes |