Profiling SQL Server
I know about SQL Profiler and Execution plans. What I need is a way to measure how much a stored procedure cost in time.
What I mean is that I've this:
- Start
 - Step 1
 - Step 2
 - Step 3
 - Step 3.1
 - Step 3.1
 
I want to know how much time each procedure takes, preferably in real time "The current running procedure is X, started fifteen minutes ago".
Any ideas?

Comments
Comment preview