Profiling SQL Server

time to read 1 min | 59 words

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?