Using the Missing Index DMV

I ran across an older post from the Microsoft SQL Server Query Optimization Team.  It is a script that creates a database and some supporting tables and a job that uses a couple of stored procs in the new database to periodically check the Missing Index Dynamic Management View and pulls the index suggestion down into a log.  Every time that an index is suggested by the DMV, it is logged.  If the suggestion is already there, it increments a counter and logs when exactly it noticed the suggestion.

Click here for the blog post.

Sometimes it suggests some slightly crazy indexes, but any help with index optimization is helpful.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: