Larry Brister
asked on
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.
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.
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.
ASKER
ScottPletcher
Thanks. yes, he's a tru DBA. Not a wannabe like me. :)
Thanks. yes, he's a tru DBA. Not a wannabe like me. :)
Any sort of change to indexing strategy should be carefully analyzed before being implemented.