Home > Archive > MS SQL Server > October 2006 > Question: Re: 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 Question: Re: Profiler - details of SP
Thomas.LeBlanc@NoSpam.Com

2006-10-24, 6:38 pm

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"
> < ThomasLeBlancNoSpamC
om@discussions.microsoft.com> wrote in message
> news:560746F5-F88B-49A5-9A13- EF873EBDD161@microso
ft.com...
>
>
>

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com