http://www.sqlservercentral.com/blogs/stratesql/2011/03/26/index-black-ops-series/

Printed 2014/12/20 08:55AM

Index Black Ops Series

By StrateSQL, 2011/03/26

Previously, in a TSQL2sDay index summary post, I started a series on the DMV sys.dm_db_index_operational_stats.  The series investigates how the columns in the DMV are populated and demonstrates how to aggregate values in the DMV.

The posts in this series are:

Download

Scripts from the series – Index Black Ops.

PDF with all posts – Index Black Ops Whitepaper.

Wrap-Up

If you have any questions on the materials or think clarity is needed, please leave a comment. I plan to update this document from time to time as I learn more on how to this DMV operates.

Related posts:

  1. Index Black Ops Part 4 – Index Overhead and Maintenance
  2. Index Black Ops Part 6 – Fill Factor vs. Page Splits
  3. Index Black Ops Part 5 – Page Splits

 


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.