|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Profiler - details of SPHow 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: Show quoteHide quote > 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 Thomas
You can trace SP:StmtStarting and SP:StmtCompleted -- Show quoteHide quoteHTH Kalen Delaney, SQL Server MVP http://sqlblog.com "Thomas.LeBlanc@NoSpam.Com" <ThomasLeBlancNoSpamCom@discussions.microsoft.com> wrote in message news:560746F5-F88B-49A5-9A13-EF873EBDD161@microsoft.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 That gives me the duration of each Insert, Updaet and Select in the SP?
Thanks Karen, you are a blessing to the SQL Server community -- Show quoteHide quoteThanks, Thomas "Kalen Delaney" wrote: > Hi Thomas > You can trace SP:StmtStarting and SP:StmtCompleted > > -- > HTH > Kalen Delaney, SQL Server MVP > http://sqlblog.com > > > "Thomas.LeBlanc@NoSpam.Com" > <ThomasLeBlancNoSpamCom@discussions.microsoft.com> wrote in message > news:560746F5-F88B-49A5-9A13-EF873EBDD161@microsoft.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 > > > SP:StmtCompleted can give you the duration of each statement in the SP.
Thanks for your kind words. Karen thanks you too. ;-) -- Show quoteHide quoteHTH Kalen Delaney, SQL Server MVP http://sqlblog.com "Thomas.LeBlanc@NoSpam.Com" <ThomasLeBlancNoSpamCom@discussions.microsoft.com> wrote in message news:CC7D6F54-4DE7-4DE8-B7CC-7904572FDF90@microsoft.com... > That gives me the duration of each Insert, Updaet and Select in the SP? > > > Thanks Karen, you are a blessing to the SQL Server community > > -- > Thanks, > Thomas > > > "Kalen Delaney" wrote: > >> Hi Thomas >> You can trace SP:StmtStarting and SP:StmtCompleted >> >> -- >> HTH >> Kalen Delaney, SQL Server MVP >> http://sqlblog.com >> >> >> "Thomas.LeBlanc@NoSpam.Com" >> <ThomasLeBlancNoSpamCom@discussions.microsoft.com> wrote in message >> news:560746F5-F88B-49A5-9A13-EF873EBDD161@microsoft.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 >> >> >>  
Thread options
|
|||||||||||||||||||||||
