February 22, 2007 at 9:59 am
Do you have any good references?
Many thanks in advance.
February 23, 2007 at 12:55 am
yeah, don't use it, use the tuning advisor in 2005. If you don't have a 2005, download an eval.
I've looked at the tuning adisor a few times and had a series of arguments with a MCDBA over it - basicially it's rubbish and not worth the effort. The 2005 version having the much easier ability to analyse a query at least makes some sensible suggestions. If you have, say, a 12 table join it can be quicker to make some basic suggestions then you can work with 2000 or yourself.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
February 23, 2007 at 10:34 am
sql2000 -
The tuning wizard needs to compile a large enough amount of data to be worth while. Start the wizard and have it save all information to a temp table. While it's capturing info be sure to run several processes and load the server up with tasks that relate to what you want to tune. When several users have used related sql processes that need tuning it's time to have sql server analyze the temp table and recommend if it should make changes or not. Hopefully sql server will say your tables can be tuned with a high probability of speed increase.
February 28, 2007 at 4:00 am
and that's the point in difference, it's collecting all that data to get meaningful results ( maybe ). I have to admit that I have other tools to show me poorly performing queries/batches but I do sometimes profile 24 hour periods into a table so I can analyse query usage. Generally I work to eliminate high io ( and/or duration ) queries first, this gives quick wins initially, although you need to be aware of frequent smaller queries that can be optimised.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
February 28, 2007 at 8:19 am
Personally, I agree with colin. Index Tuning Wizard gives us redicular recommendations. My original question is how to read its reports, not if it is reliable to use the tool.
Many thanks for inputs from all of you.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply