Updated August 29, 2021. Purpose To get a baseline of the index operations that takes place. Sources This feature queries the DMV sys.dm_db_index_operational_stats which returns lower-level I/O, locking, latching, and…
Flemming Haurum Posts
Updated August 29, 2021. Purpose To provide a wrapper around the SQL Server Index and Statistics Management solution made by Ola Hallengren and deliver reports showing the result of index…
Updated August 29, 2021. Purpose To show the latest result captured regarding index defragmentation. Sources This feature queries the DMV dm_db_index_physical_stats which returns size and fragmentation information for the data…
Updated August 29, 2021. Purpose To get a baseline of the index usage and to see how the usage changes when indexes are added or modified. Sources This feature queries…
Updated May 1, 2022. Purpose To get a quick overview of the instance and it’s configuration and if there are settings that should be changed. Sources This feature queries a…
Updated August 29, 2021. Purpose To see the missing indexes information that the SQL server reports. Sources This feature queries the 3 DMV’s sys.dm_db_missing_index_group_stats, sys.dm_db_missing_index_groups and sys.dm_db_missing_index_details which together returns…