December 28, 2007 at 4:36 am
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
December 28, 2007 at 6:13 am
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, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 28, 2007 at 6:31 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply