SQL Server Index Tuning : Experimental Black Art

The SQL Server Index Tuning Wizard is an incredibly powerful tool that can find amazing performance increases. There are some times when it can be a pain to get to work.

It is great when you want to use it on a given query. It makes great suggestions very quikly.

It is slightly painful when you want to tune a stored procedure as a whole. Especially when it is large and can take several hours to run. I am trying to find what you actually need to put into a trace so that the index tuning wizard will accept it as a workfile. The documentation is useful as ever – it will only tell you what you need to know if you ask exactly the right question. Anything else will drown you in useless details of other features.

One thought on “SQL Server Index Tuning : Experimental Black Art

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s