Duplicate Indexes

The Report

Click image to enlarge.

To use the report, download the Database Health Reports, and run the Duplicate Indexes report.

What does this mean to my SQL Server

Each duplicate index is just wasteful in a number of ways.

  • More memory taken up on your SQL Server.  Other more useful items may be pushed out of memory.
  • Larger database files.
  • Larger backup files, and longer backup times.
  • Larger transaction logs and log backups.
  • More structures to change on insert, update, or delete, causing slower response.
  • Query engine needs to assess more options when queries are run.
  • If you are using database mirroring, then there are more pages to be mirrored.

How Do I Fix It

Remove the duplicate indexes.

One Response to Duplicate Indexes

  1. Pingback: » SQL Server Health Reports — Working on Version 2 Steve Stedman

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Powered by sweet Captcha