Introduction to the Index Operational Statistics Dynamic Management Function

Geschrieben von Database Magician am Montag, 2. Mai 2016

'Index usage information is valuable when it comes to analyzing fill factor settings, page splits, compression, locking promotion and in performance tuning when locking and latching are your larger pain points. See how common operations in graphical execution plans translate to stored metadata about index usage inside two Dynamic Management Objects: dm_db_index_operational_stats and dm_db_index_usage_stats as we start a new series on using the Dynamic Management Objects to both proactively and reactively tune your SQL instances using dm_db_index_operational_stats.'...

http://sqlmag.com/database-performance-tuning/introduction-index-operational-statistics-dynamic-management-function