Return of Index Analysis Part 4

We’ve got through the first three parts of this continued series on the Index Analysis query last week.  The previous posts in this complete series are: Analyze Your Indexes Part 1 – Combine existing index statistics and missing indexes into a single output Analyze Your Indexes Part 2 – Find existing duplicate and overlapping indexes … Continue reading Return of Index Analysis Part 4

Return of Index Analysis Part 3

Time for part three of my continued Index Analysis query.  The previous posts in this series are: Analyze Your Indexes Part 1 – Combine existing index statistics and missing indexes into a single output Analyze Your Indexes Part 2 – Find existing duplicate and overlapping indexes Analyze Your Indexes Part 3 – Find the relationship … Continue reading Return of Index Analysis Part 3

Return of Index Analysis Part 2

Time for part two of my continued Index Analysis query.  The previous posts in this series are: Analyze Your Indexes Part 1 – Combine existing index statistics and missing indexes into a single output Analyze Your Indexes Part 2 – Find existing duplicate and overlapping indexes Analyze Your Indexes Part 3 – Find the relationship … Continue reading Return of Index Analysis Part 2

Return of Index Analysis Part 1

Time for part two of my continued Index Analysis query.  The previous posts in this series are: Analyze Your Indexes Part 1 – Combine existing index statistics and missing indexes into a single output Analyze Your Indexes Part 2 – Find existing duplicate and overlapping indexes Analyze Your Indexes Part 3 – Find the relationship … Continue reading Return of Index Analysis Part 1

Return of Index Analysis

Now that I've finished going through some of the details for sys.dm_db_index_operational_stats, it’s time to take that information and incorporate it into a query that I wrote about a while back. This query is an index analysis query that I often use when I go out to clients.  The query provides a information about the … Continue reading Return of Index Analysis

Analyzing Your Indexes with a Custom Report

A while back I put together a number of posts around an index analysis query that I had put together to assist when I go out to clients.  If you are interested, the background for the query can be found in the following posts: Analyze Your Indexes Part 1 Analyze Your Indexes Part 2 Analyze … Continue reading Analyzing Your Indexes with a Custom Report

Analyze This – Analyze Your Indexes – Part 6

This is the sixth and last for now post in which I’m going through a query that can be used to analyze indexes.  Thus far the following has been added to the query: Combine existing index statistics and missing indexes into a single output Find existing duplicate and overlapping indexes Find the relationship between indexes … Continue reading Analyze This – Analyze Your Indexes – Part 6