Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
zoltan_ie
Starting Member
1 Post |
 Posted - 2006-08-30 : 20:00:15
|
| Has anyone used any profiler tools like….SQL diagnostic manager [url]http://www.idera.com/Products/SQLdm/?S=GW[/url]or Quest Central for SQL Server [url]http://www.quest.com/Quest_Central_for_SQL_Server/[/url]I’m curious to know if there is a tool out there that could profile performance of a Stored Procedure like Dev Partner does for C++ in respect to time each line/statement of the stored procedureTake a look as to what I mean….[url]http://www.compuware.com/images/screenshots/LG-Perf-Analysis.jpg[/url] Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-30 : 20:06:24
|
| Why not just use the free tool that comes with SQL Server called SQL Profiler? It can profile all transactions going through SQL Server. It can show you each line of code within the stored procedure and how long each took.I've seen both tools in action. We have not purchased either. Check if SQL Profiler can do what you want first before purchasing a third party tool.Tara Kizer |
 |
|
|
|
|
|
Stored Proc performance profiling tools4 SQLServer