September 19, 2002 at 8:58 am
I have a trace that I ran through Index Tuning Wizard provided recommendations. I would like to implement the recommendations on a backup server first. Then replay the trace against the backup server to compare the duration between the 2 servers (one with recommended indexes and one without). The problem is I cannot get the replay to show duration. Does anybody have any ideas how to do this or a better/different way of comparing?
September 19, 2002 at 6:01 pm
I would say that you make the comparision in the backup server only. You first should start some tools to compare. Execute :
Set ShowPlan_All On or use query analizer Graphical Tools to check.
Maybe: Set statistics io on, Set statistics time ON,
and execute the transaction to prove the decision that optimizer takes. Write down all the info that it shows. Then execute the recomendation from profiler to create the indexes and re run the transaction. Write down again all the info and compare.
Then you can add more indexes, or add a different index. The important is that you try and compare. So i recommend you only use the backup server.
Then once you are sure you have the best indexes on your server, create it in production.
Tunning Wizard provides a recommendation, could be right or wrong. Maybe you should try by your own.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply