5 Monitoring Queries for SQL Server
Jump to navigation Jump to search
- Missing index
- Index Fragmentation
- Job Status
- Memory Use
- Page Life Expectancy: It’s Lifetime of the pages in the cache. The recommended value is over 300 sec.
- Free List Stalls/sec: The number of requests that have to wait for a free page. If this value is high, your server is under memory pressure.
- Page Reads/sec: If this counter has a high value this will confirm the memory pressure already highlighted by two counters