SQL Server Monitoring – Services and reports

This blog is part of the blog series named SQL Server Monitoring and gives a brief overview of the services and reports included in the tool.

ServicesReports
Age of statisticsStatistics
Agent jobsAgent jobs configuration
Backup statusBackup
Cleanup data-
ConnectionsConnections
CPU utilizationCPU
Database IODatabase IO
Database sizeDatabase size
Database stateDatabase configuration
Index operationalIndex leaf statistics
Lock statistics
Index physicalIndex physical
Index rebuild - Index optimizeIndex optimize
Ola Hallengren errors
Index reorganize - Index optimizeIndex optimize
Ola Hallengren errors
Index usageIndex usage
Instance stateInstance configuration
Instance status
Resource Governor configuration
Missing indexesMissing indexes
Partitioned indexesPartitioned indexes
Performance statisticsAlways On traffic
Performance statistics
Resource Governor
Plan cache usagePlan cache usage
Plan guidesPlan guides
Query statisticsQuery statistics
Table sizeTable size
TriggersTriggers
Update all statistics - Index optimizeIndex optimize
Ola Hallengren errors
Update modified statistics - Index optimizeIndex optimize
Ola Hallengren errors
Wait statisticsWait statistics
Who is activeWho is active
The FHSSQLMonitor tool itselfData load
Monitor configuration
Monitor status