Re: SQL Tuning -- Tools

From: "John Kanagaraj" <john.kanagaraj@xxxxxxxxx>
To: mssql_2002@xxxxxxxxx
Date: Mon, 4 Dec 2006 15:54:06 -0800

Bob,

I am looking for SQL tuning tools. Four years back, I used to use LECCO SQL

Expert Tuning which was very good. LECCO is brought by Quest Software, Inc.



All these "tuning" tools did was to check the object stats, provide options
to change the hints and allow you to compare the estimated costs. If you are
on 10g, the SQL Tuning Advisor does perform some sampling to determine
alternate paths and provide at least some sensible advice. Needs the Tuning
pack though... (i.e. not free)

--
John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)

There is only ONE reason for the SEASON, and it certainly ain't " Happy
Holidays" :)

** The opinions and facts contained in this message are entirely mine and do
not reflect those of my employer or customers **

References:

SQL Tuning -- Tools
From: Bob Robert

Re: SQL Tuning -- Tools

Other related posts: