December 16, 2008 at 8:33 am
I am somewhat new to SQL 2005. I am attempting to find the Index tuning wizard like in SQL 2000 Query Analyzer. All I want to do is take a SQL statement and see the query access and see if it recommends any tuning indexes. I do not want to start a trace or anything fancy like that.
December 16, 2008 at 8:40 am
In 2005 it's called Data engine tuning advisor and you can fingd it in SSMS under Tools.
[font="Verdana"]Markus Bohse[/font]
December 16, 2008 at 9:49 am
Thanks. I found that. I guess in 2005 they removed the simple I have a SQL statement staring me in the face in Query Analyzer and want to analyze it for tuning indexes. In 2005 you must cut/paste that query into a .sql file and then pull that into the new tool. I really liked the simplistic approach to the old way. I used that constantly. I would run profiler interactively, see a statement, cut paste into query analyzer and fire up index tuning wizard....
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply