5 Monitoring Queries for SQL Server

From SQL Server Wiki
Jump to navigation Jump to search
  1. Missing index
  2. Auto-growth
  3. Index Fragmentation
  4. Job Status
  5. 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