Thursday, March 22, 2012

atabase Tuning ADvisor and index recommendations

Hi there. I love this tool from what I've read, will it also tell me what indexes I DON'T need (I think that would be helpful - especially when I'm not the one creating indexes all the time). Thanks!Moving to tools forum.|||

More or less it does as per my experience, but in this case you might need to run thru full analysis using the profiler trace.

Refer to http://blogs.msdn.com/sqlcat/archive/2006/02/13/531339.aspx for more information.

No comments:

Post a Comment