This blog is part of the blog series named SQL Server Monitoring.
Purpose
To get a quick overview of the instance status.
Sources
This output here is based on the DMV sys.dm_server_memory_dumps which returns information about the dump files existing on the SQL Server, and the DMV msdb.suspect_pages which returns information about suspect pages on databases reporting the file and page id that is suspect.
Report
The report shows 2 tables where the upper one shows the dump files reported on the instance, and the lower one reports about detected suspect pages on the instance.
Model
The model for the report uses the facts [Agent alerts], [Agent jobs], [Instance configuration], [Instance configuration history], [Instance dump files], [Instance hardware], [Instance hardware history], [Instance services], [Instance suspect pages], [Resource governor configuration], [Resource governor external resource pool affinity], [Resource governor external resource pools], [Resource governor resource pool affinity], [Resource governor resource pools], [Resource governor workload groups], [Trace flags] and [Trace flags history].
It is the same model that are used by the Instance configuration and Resource Governor configuration reports.
Configuration
There is no configuration for this feature.
Scheduling
The default schedule for the feature is once every hour.
Retention
The default retention for the table dbo.fhsmInstanceState is 1.825 days (5 years).
