|
Home > Archive > MS SQL Server > October 2006 > Profiler - details of SP
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Profiler - details of SP
|
|
| Thomas.LeBlanc@NoSpam.Com 2006-10-24, 6:38 pm |
| How can I setup Profiler to track/watch the execution of the lines in a
stored procedure?
It looks like I just see exec sp_DoWork, as TextData.
I want to see the sql statements in the SP and how long they each take.
--
Thanks,
ThomasLL
| |
|
| Hi,
I am not sure whether this is possible....
But as soon as you have identified the SP thats taking time, why dont
you check the execution plan of that SP instead?
Thomas.LeBlanc@NoSpam.Com wrote:
> How can I setup Profiler to track/watch the execution of the lines in a
> stored procedure?
>
> It looks like I just see exec sp_DoWork, as TextData.
>
> I want to see the sql statements in the SP and how long they each take.
> --
> Thanks,
> ThomasLL
| |
| Kalen Delaney 2006-10-24, 6:38 pm |
| Hi Thomas
You can trace SP:StmtStarting and SP:StmtCompleted
--
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Thomas.LeBlanc@NoSpam.Com"
< ThomasLeBlancNoSpamC
om@discussions.microsoft.com> wrote in message
news:560746F5-F88B-49A5-9A13- EF873EBDD161@microso
ft.com...
> How can I setup Profiler to track/watch the execution of the lines in a
> stored procedure?
>
> It looks like I just see exec sp_DoWork, as TextData.
>
> I want to see the sql statements in the SP and how long they each take.
> --
> Thanks,
> ThomasLL
|
|
|
|
|