About Index Tuning wizard

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » About Index Tuning wizard

About Index Tuning wizard

Rate Topic

Display Mode

Topic Options

Author

Message

Paresh Prajapati

Posted Friday, December 28, 2007 4:36 AM

Old Hand

Group: General Forum Members
Last Login: Friday, August 31, 2012 6:08 AM
Points: 322, Visits: 459

I have try to find out performanance of indexex on table through index tuning wizard, but i m not able to understand index tuning wizard.

So any one pls give me brief idea about it...with example...how to use it....
u can mail me at pprajapati@asite.com

_____________________________________________________________________________________________________________
Paresh Prajapati

+919924626601
http://paresh-sqldba.blogspot.com/
LinkedIn | Tweet Me | FaceBook | Brijj

Post #436986

GilaMonster

Posted Friday, December 28, 2007 6:13 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 2:33 PM
Points: 37,741, Visits: 30,019

Rather don't use the index tuning wizard. It's prone to giving rather sub-optimal suggestions. Learning to tune indexes yourself will get you much better results most of the time.

If you're not sure where to start, post the schema or one or two of your tables here, along with the more common queries and someone wll likly help you.

If you can, I would suggest getting a consultant in for a couple of days. Someone who specialises in performance tuning. They could then sho you how to go about things.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #437014

toniupstny

Posted Friday, December 28, 2007 6:31 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, February 22, 2013 9:04 AM
Points: 241, Visits: 928

To use the Index Tuning Wizard you can capture a workload via Profiler or use one from the Query Analyzer Query window. You specify the database, level of analysis to be done, whether you want to keep all indexes and if you want to use indexed views. Next you specify where to find the query to be analyzed (profiler trace, workload file or QA Query window). Tell it what tables to use and then let it run.

It will provide recommendations on what index to add (or remove) and can generate the code to do so. You can either run the code right away or save it to run later.

Check these links

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/tunesql.mspx

http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1166357,00.html

Toni

Post #437022

« Prev Topic | Next Topic »

Permissions