| Processor | %Processor Time/_Total | All processors usage | <70% |
| System | Processor Queue Length | Threads ready to run | Near 0 but at most <10 per processor |
| Network Interface | Bytes Total/sec | Total network load | <60% bandwidth |
| Memory Manager | Total Server Memory | Current Memory consumption | OS memory = 2GB+ 2MB*(500 + 16 *(CPUs-4)) |
| | | Rest is max memory for instance |
| Memory Manager | Target Server Memory | Ideal Memory for optimal operation | “=Total Server Memory |
| Memory Manager | Free Memory | Not used memory | >0 but not too large |
| Memory Manager | Stolen Server Memory | Server Memory stolen for other purposes than DB pages | 0 |
| Memory Manager | Memory Grants Pending | Processes waiting for memory workspace | 0 or 1 |
| Buffer Manager | Free List stalls/ sec | Requests had to wait for free page | 0 |
| Buffer Manager | Buffer Cache hit Ratio | Pages in memory without reading from disk | >99% |
| Buffer Manager | Lazy Writes/sec | Indicate dirty pages from lazy writer (NOT CHECKPOINT) | 0 |
| Buffer Manager | Page Life Expectancy | Seconds that a page stays in Buffer Cache before flush | 300s * Total memory (GB)/4GB |
| Buffer Manager | Page reads/sec | Physical Reads | Not too high compared to Logical Reads |
| Buffer Manager | Page lookups /sec | Logical Reads | |
| Memory | Available Mbytes | Memory Available to OS. | >2-4GB |
| Memory | Pages / sec | Pages read from or written to disk to resolve hard page faults | 0 |
| Plan Cache | Cache Hit Ratio | Ratio between cache hits and lookups for plans | >95% |
| Paging File | %Usage | Page file in use | 0 |
| Process | Working Set | The working set in Bytes | If much smaller than assigned memory then it’s overallocated |
| Physical Disk | Avg. Disk Queue Length | Read Write requests queued for selected disk | Near 0 |
| Physical Disk | Avg. Disk Sec/Read | Average time for one read | <20ms |
| Physical Disk | Avg. Disk Sec/Write | Average time for one write | <20ms |
| Physical Disk | %Disk Time | Busy disk time | <50% |
| Physical Disk | Disk Reads/Sec | Rate of read operations on the disk. | <85% of disk capacity |
| Physical Disk | Disk Writes/Sec | Rate of write operations on the disk. | <85% of disk capacity |
| Access Methods | Full Scans/sec | Table or full Index Scans. Can indicate further need for optimization with new indexes. | |
| Access Methods | Index Searches/sec | Index Range scans, single index record fetch, reposition within index | |
| Access Methods | Range Scans/sec | Range scans through indexes | |
| Access Methods | Page Splits / Sec | Number of page splits as a result of overflowing index pages Indicate fragmentation | |
| Access Methods | Forwarded Records/sec | Records fetched through forwarded record pointers. Indicate fragmentation | |
| Access Methods | Table Lock Escalations/sec | Locks escalations to table lock | |
| SQL Statistics | Batch Requests/sec | Number of batch requests received by server. Indicates load | |
| SQL Statistics | SQL Compilations/sec | Compiles. Hard parses for first time | |
| SQL Statistics | SQL Re-Compilations/sec | Re-compiles. Hard parses for existing sql. High number might indicate not use of bind variables | |
| General Statistics | Processes blocked | Blocked processes | |
| General Statistics | User Connections | Used for calculating a baseline | |
| Databases | Transactions/sec | Used for calculating a baseline | |
| Databases | Log Growths | Number of log growths | |
| Databases | Percent Log Used | Log usage | |
| Locks | Average Wait Time (ms) | Lock average wait | |
| Locks | Number of Deadlocks/sec | Deadlocks per second | |
| Locks | Lock Requests/sec | New locks and lock conversions | |
| Wait Statistics | Lock Waits | Processes waiting on a lock. | |
| Wait Statistics | Log Buffer Waits | Processes waiting for log buffer to be available. | |
| Wait Statistics | Log Write Waits | Processes waiting for log buffer to be written. | |
| Wait Statistics | Memory grant queue waits | Processes waiting for memory grant to become available. | |
| Wait Statistics | Network IO waits | Processes waiting for Network IO. | |
| Wait Statistics | Non-Page latch waits | Processes waiting for Non-page latches. | |
| Wait Statistics | Page IO latch wait | Processes waiting for Page IO latches. | |
| Wait Statistics | Page Latch waits | Processes waiting for Page latches, not including IO latches | |
| Wait Statistics | Thread-safe memory objects waits | Processes waiting on thread-safe memory allocators. | |
| Wait Statistics | Transaction ownership waits | Processes synchronizing access to transaction. | |
| Wait Statistics | Wait for the worker | Processes waiting for worker to become available. | |
| Wait Statistics | Workspace synchronization waits | Processes synchronizing access to workspace. | |
