Hi,
The goal is to systematically analyse the performance of indexes,
stored procedures, UDFs, views, triggers etc. in the current database
(which is quite complex, for instance, it has 200+ user tables, 150+
procedures) to see what could be improved.
Here's my understanding. Profile is passive, that is, it monitors
database activities/events, yes, one can see what's going on. Then,
probably using Database Engine Turing Advisor to make improvements
etc....
Also, I should add, for someone for instance, a consultant to a new
environment, he/she would have very limited time to understand the
business driver etc. for core entities/tables etc. hence, picking some
heavy duty stored procedures to analyze won't seem to be an option...
I'm sure there's are third party tools out there that would analyse a
large relational database and offer areas of improvement...
So, what tool are you using to achieve the above goal?
Thanks.
| 
