This blog is part of the blog series named SQL Server Monitoring.
Purpose
To get a baseline of the index locking that takes place.
Report
The report has 2 line charts in the upper half showing the number of locks and the time of lock wait in Ms over time, where the table in the lower half shows the lock data per database and with the possibility to drill down to schema, object and index level.
Sources
This feature queries the DMV sys.dm_db_index_operational_stats which returns information about locking and latching for each partition of a table or index.
Model
The model for the reports uses the fact [Index operational] and the dimensions [Date], [Time] and [Index].
It is the same model that are used by the Index leaf statistics report.
Configuration
The report uses the same data as used by the Index leaf statistics report.
