1.3 Why Index Read & Write Numbers Are Wrong

We all have “that index script” – a DMV script we cobbled together from stuff all over. Problem is, there are huge issues with the index usage DMVs and missing index DMVs, and they don’t tell you quite what you’re expecting. Let’s do a series of demos showing the gotchas with sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats and…

To access this incredible, amazing content, you gotta get Mastering Index Tuning or Recorded Class Season Pass, or log in if you already shelled out the cash.

We all have “that index script” – a DMV script we cobbled together from stuff all over. Problem is, there are huge issues with the index usage DMVs and missing index DMVs, and they don’t tell you quite what you’re expecting. Let’s do a series of demos showing the gotchas with sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats and...
To access this incredible, amazing content, you gotta get Mastering Index Tuning or Recorded Class Season Pass, or log in if you already shelled out the cash.
Menu