January 29, 2007 at 2:51 am
Dear all,
I tried to use Index Tuning Wizard for SQL 2000 DB to tune stored procedure but it does not capture any query inside stored procedure.
I captured workload using built-in SQLProfilerTSQL_SPs.tdf which includes RPC:Starting, SP:Completed, SP:Starting, SP:StmtStarting and SQL:BatchStarting Events. Is it a correct option for SQL Profiler ? Do I miss some options in index tuning wizard ? How can I do it ?
Best regards,
Chaivat
January 29, 2007 at 5:38 am
There's been a number of posts about the somewhat dubious value of the tuning wiz in sql 2000. I'd suggest you don't use it and if you must use such a tool get the 2005 version.
I've never used the wizard in xxx years ( other than to realise it was rubbish ) use the graphic query plan and start there.
SQL 2000 performance tuning reference manual will give you a heads up. There is a technet/msdn article I think which describes the output.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply