Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Prioritize Missing Index Recommendations 2 (2005) Expand / Collapse
Author
Message
Posted Sunday, September 23, 2007 2:08 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 3, 2011 1:01 PM
Points: 6, Visits: 38
Comments posted to this topic are about the item Prioritize Missing Index Recommendations 2 (2005)
Post #401711
Posted Friday, April 18, 2008 1:15 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 12:07 PM
Points: 301, Visits: 792
Thanks for posting this! Good work.

I just ran across it today. Results correlate very well with results from some other "worst performing procs" queries I run, and sure enough the recommendations are spot on. I know, I shouldn't be surprised.

I'm still inspecting the top recommendations pretty closely before deciding what to do, if anything. Not sure what I'll do once I begin to fully trust this stuff.... Do you still inspect the related procs/queries and craft the each index creation script carefully?




Post #487455
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse