Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Help finding index tuning wizard Expand / Collapse
Author
Message
Posted Tuesday, December 16, 2008 8:33 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 10:38 AM
Points: 1,202, Visits: 2,663
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.


Post #620467
Posted Tuesday, December 16, 2008 8:40 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 6:12 AM
Points: 4,432, Visits: 4,156
In 2005 it's called Data engine tuning advisor and you can fingd it in SSMS under Tools.

Markus Bohse
Post #620484
Posted Tuesday, December 16, 2008 9:49 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 10:38 AM
Points: 1,202, Visits: 2,663
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....


Post #620552
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse