Best tool for Performance Tuning

Which is the best third party tool for SQL Server 2005 Performance Tuning/Optimization.

We purchased the Toad for SQL Server from Quest sofwater but it works only with dbo schemas....So if ur users were in schema xyz then it would not recognize it because they develop the tool for 2005 based on SQL Server 2000 where the schema ownesrhip is tied to the users.

Have you tried the Database Engine Tuning Advisor in Management Studio? I've not used it a great deal but what I have done seemed quite good. It also doesn't require an extra purchase.

sql

Best 3rd party Charting Control for RS2005

Hi Experts!
I have tried out Dundas Charting (v2) Evaluation for RS2005 and it turned
out quite nice. At least I know it allowed me do combination charts (e.g.
points, line, coumn, etc) which the default RS cannot do.
Based on your experience and opinions from others that you heard, which is
the best 3rd party Charting control out there for RS2005?
Any info would be greatly appreciated.On Mar 8, 3:19 pm, Thanh Nguyen
<ThanhNgu...@.discussions.microsoft.com> wrote:
> Hi Experts!
> I have tried out Dundas Charting (v2) Evaluation for RS2005 and it turned
> out quite nice. At least I know it allowed me do combination charts (e.g.
> points, line, coumn, etc) which the default RS cannot do.
> Based on your experience and opinions from others that you heard, which is
> the best 3rd party Charting control out there for RS2005?
> Any info would be greatly appreciated.
I am using Dundas for some of my clients. I felt its the best.|||We use ChartFX. As for whether it is the "best" - don't know. I haven't
used Dundas. We use ChartFX to render charts (on reports and web forms)
from data from SQL Analysis Services.
"Thanh Nguyen" <ThanhNguyen@.discussions.microsoft.com> wrote in message
news:C953A74F-CDC9-4ACF-89CC-272E80E0F4E8@.microsoft.com...
> Hi Experts!
> I have tried out Dundas Charting (v2) Evaluation for RS2005 and it turned
> out quite nice. At least I know it allowed me do combination charts (e.g.
> points, line, coumn, etc) which the default RS cannot do.
> Based on your experience and opinions from others that you heard, which is
> the best 3rd party Charting control out there for RS2005?
> Any info would be greatly appreciated.