• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 463
  • Last Modified:

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?
0
Larry Brister
Asked:
Larry Brister
  • 2
  • 2
  • 2
2 Solutions
 
Steve WalesSenior Database AdministratorCommented:
There are some DMV's that keep track of that for you.

Check out:

http://sqlserverpedia.com/wiki/Find_Missing_Indexes
http://weblogs.sqlteam.com/mladenp/archive/2009/04/08/SQL-Server---Find-missing-and-unused-indexes.aspx

Also Brent Ozar Unlimited has a script that helps assess your index health:
http://www.brentozar.com/blitzindex/
0
 
Scott PletcherSenior 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.
0
 
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.
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
Larry Bristersr. DeveloperAuthor 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.
0
 
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.
0
 
Larry Bristersr. DeveloperAuthor Commented:
ScottPletcher

Thanks.  yes, he's a tru DBA.  Not a wannabe like me. :)
0
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.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now