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