This blog is part of the blog series named SQL Server Monitoring.
Purpose
To get a baseline of the server wait statistics.
Sources
This feature queries the 2 DMV’s sys.dm_os_waiting_tasks and sys.dm_os_wait_stats which returns information about the wait queue of tasks that are waiting on some resource as well as information about all the waits encountered by threads that executed, and where the wait type is enabled in the master data table dbo.fhsmWaitCategories.
Report
The report has in the upper part 2 line charts, the left showing the signal wait time and wait time in mS, and the right showing the number of waiting tasks, where the table in the lower part shows the wait data per wait type.
Model
The model for the report uses the fact [Wait statistics] and the dimensions [Date], [Time] and [Wait type].
Configuration
There is no configuration for this feature.
Scheduling
The default schedule for the feature is once every hour throughout the day.
Retention
The default retention for the table dbo.fhsmWaitStatistics is 30 days.
