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

About Index Tuning wizard Expand / Collapse
Author
Message
Posted Friday, December 28, 2007 4:36 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, June 18, 2013 7:41 AM
Points: 323, Visits: 464
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
Posted Friday, December 28, 2007 6:13 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 6:30 AM
Points: 40,184, Visits: 36,591
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
Posted Friday, December 28, 2007 6:31 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, August 1, 2014 5:51 AM
Points: 242, Visits: 940
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 »

Add to briefcase

Permissions Expand / Collapse