5 Monitoring Queries for SQL Server


 * https://www.simple-talk.com/sql/database-administration/5-monitoring-queries-for-sql-server/


 * 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