Help finding index tuning wizard

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Performance Tuning » Help finding index tuning wizard

Help finding index tuning wizard

Rate Topic

Display Mode

Topic Options

Author

Message

Markus

Posted Tuesday, December 16, 2008 8:33 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 2:16 PM
Points: 1,048, Visits: 2,215

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

MarkusB

Posted Tuesday, December 16, 2008 8:40 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 3:22 AM
Points: 4,218, Visits: 3,875

In 2005 it's called Data engine tuning advisor and you can fingd it in SSMS under Tools.

Markus Bohse

Post #620484

Markus

Posted Tuesday, December 16, 2008 9:49 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 2:16 PM
Points: 1,048, Visits: 2,215

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 »

Permissions