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 jobs configurationAgent jobs configuration
Agent jobs performanceAgent jobs performance
Backup statusBackup
Blocks and deadlocksBlocks and deadlocks
CapacityDatabase size
Partitioned indexes
Table size
Cleanup data-
ConnectionsConnections
CPU utilizationCPU
Database IODatabase IO
Database stateAlways On configuration
Database 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 configuration
Index usage
Instance stateInstance configuration
Instance status
Resource Governor configuration
Log shippingLog shipping configuration
Log shipping status
Missing indexesMissing indexes
Performance statisticsAlways On performance
Performance statistics
Resource Governor
Plan cache usagePlan cache usage
Plan guidesPlan guides
Query statisticsQuery statistics
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