CODEWITHSUNDEEP
sqlsql-serversql-server-2008t-sql
Alex Gordon
Alex Gordon

Reputation: 60841

database engine tuning wizard "apply recommendations" is disabled

I just forced the database engine tuning wizard in ssms 2008 to analyze a 5mb trace.

I got a list of recommendations returned to me, in terms of indexes to implement; however, I am unable to apply the recommendations because it is greyed out:

enter image description here

Does anyone know whether this is a bug? How would I manually implement the changes?

Thank you so much for your guidance.

Upvotes: 0

Views: 478

Answers (1)

avakharia
avakharia

Reputation: 206

You can simply click the right most column that looks like hyperlink and it will open a popup window which will have the recommended index or statistic in query form. You can click Copy to Clipboard from the popup window. Now paste it in to your SSMS New Query window and execute it.

The only reason I think 'Apply Recommendations' menu item is disabled is either you don't have enough permissions to make those changes or the session has timed out.

Hope this helps!

Upvotes: 1

Related Questions