Prioritize Missing Index Recommendations 2 (2005)

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Michael Smith » Prioritize Missing Index Recommendations 2...

Prioritize Missing Index Recommendations 2 (2005)

Rate Topic

Display Mode

Topic Options

Author

Message

Michael L. Smith

Posted Sunday, September 23, 2007 2:08 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, March 03, 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

Mike Good

Posted Friday, April 18, 2008 1:15 PM

SSC Veteran

Group: General Forum Members
Last Login: Today @ 11:57 AM
Points: 267, Visits: 658

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 »

Permissions