SQL Server 2005 optimize table with indexes

Is there a tool that will suggest whether or not a set of tables need indexes created to optimize speed?
Who is Participating?
Steve WalesConnect With a Mentor Senior Database AdministratorCommented:
There are some DMV's that keep track of that for you.

Check out:


Also Brent Ozar Unlimited has a script that helps assess your index health:
Scott PletcherConnect With a Mentor Senior DBACommented:
You have to very carefully review the "missing index" info from the MS system views.  Yes, it's nice to have this info, but do not rely on it without a thorough review from a knowledgeable person first.  That applies to DTA recommendations as well.
Steve WalesSenior Database AdministratorCommented:
Should have mentioned that - the DMV's etc aren't flawless - they are recommendations that should be carefully assessed and tested before implementing anything in production environments.

Any sort of change to indexing strategy should be carefully analyzed before being implemented.
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

lrbristerAuthor Commented:
Thanks guys.
I'm the SR Developer (.Net) onsite

I'm just making what I THINK may be recommendations for review by the customer DBA.

Their responsibility...ut mine is to at least point them at what I believe may be a bottleneck.

I am certainly no DBA.
Scott PletcherSenior DBACommented:
Most important for performance is the proper clustered index, and the missing index views won't help with that at all.

But, if they've got a (true) DBA, he'll know to look at the index usage stats and the other index-related views as well.
lrbristerAuthor Commented:

Thanks.  yes, he's a tru DBA.  Not a wannabe like me. :)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.