The blog is part of the blog series named SQL Server Monitoring and gives a brief overview of the features included in the tool FHSQLMonitor.
The detailed description of the individual features is described in sub-blogs, one for each feature.
| Feature | Purpose |
|---|---|
| Agent jobs | List all agent jobs and their schedules |
| Backup status | Reports backup status for the databases |
| Connection statistics | Reports information about connections |
| CPU statistics | Reports information about CPU utilization |
| Database IO | Reports physical IO activity for the databases |
| Database size | Reports physical size of the data and log files |
| Database state | Reports information about the databases on the instance |
| Index operational | Reports operational activity on leaf pages, non-leaf pages as well as information about row and page locks |
| Index optimize | Reports statistics for index maintenance operations |
| Index physical | Reports physical index information like fragmentation and page count |
| Index usage | Reports index information like lookups, scans, seeks and updates |
| Instance state | Reports information about the instance |
| Missing indexes | Reports missing index information |
| Performance statistics | Reports performance counter information like page life expectancy, batch request/sec and Always On traffic |
| Plan cache usage | Reports information about plan cache usage |
| Plan guides | Reports information about plan guides |
| Query statistics | Reports query statements and their cost in terms of logical reads, CPU time, elapsed time, ... |
| Statistics age | Reports age of the index statistics |
| Table size | Reports table size in terms of number of rows, space reserved, data size, index size and unused space |
| Triggers | Reports information about triggers |
| Wait statistics | Reports the detected wait types |
| Who is active | Reports who is or was active on the server |
