By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,575 Members | 1,948 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,575 IT Pros & Developers. It's quick & easy.

SQL Server 2005 Profiler etc.

P: n/a
DL
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.
Sep 19 '08 #1
Share this Question
Share on Google+
1 Reply


P: n/a
A good product I have seen deployed is the Veritas/Symantec i3. It does
a lot more than performance analysis and monitoring of SQL Server (for
example, it can do the same for the .NET application layers accessing
SQL Server).

http://www.dmreview.com/issues/20050701/1031235-1.html
http://www.symantec.com/about/news/r...id=20070807_01

--
Plamen Ratchev
http://www.SQLStudio.com
Sep 19 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.