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
No comments:
Post a Comment