Implemented
over 1 year ago

Index Analysis (including Missing Indexes)

Since databasses report missing index data, it would be nice to see this in DPA so we can associate the largest wait time sql with missing index data.

Provide analysis about current indexes on a table

Show unused or underused indexes.

10/12/16 - changed header and description to reflect the feature better

This feature has been implemented in DPA 12.0 and is now available for download in the customer portal

See these posts for more information about DPA 12.0.

Parents
  • I voted this feature down as I find too many people just want to add indexes to fix any performance issue as a 1st step.  Indexes are not free and are very hard to get removed once they make their way onto production.  Obviously they are sometimes necessary, however, it isn't hard to figure out if an index would be helpful once you understand what the execution plan should be doing.  So it isn't that this wouldn't be a helpful feature, but I feel it will lead to too many indexes getting added to production systems without proper understanding if that is actually a good idea.

  • The page that displays these could have a statement to that effect. But the fact that the information can be misused is not a reason to hide it from those of us that know how to evaluate it and take only appropriate action. The ability to mark a specific missing index recommendation so it will be hidden from view once it has been evaluated and rejected would make this even more helpful. Maybe even to allow the user to enter a comment as to why it is being rejected, and offer a selection on the page to show all recommendations, hidden/rejected recommendations, or non-hidden (the default).

Comment
  • The page that displays these could have a statement to that effect. But the fact that the information can be misused is not a reason to hide it from those of us that know how to evaluate it and take only appropriate action. The ability to mark a specific missing index recommendation so it will be hidden from view once it has been evaluated and rejected would make this even more helpful. Maybe even to allow the user to enter a comment as to why it is being rejected, and offer a selection on the page to show all recommendations, hidden/rejected recommendations, or non-hidden (the default).

Children
No Data