Number and duration of execution for stored procedures

15 Mar 2007 9:13 AM

CM

Hello,

Will be very usefull for me if I know what are the stored procedures more
often use in a database and how long is the execution time.Can someone help
me in putting a trigger, or getting this values from tempdb maybe ? I know
profiler (RPC completed I guess) , but I can't understand duration -
sometimes, if that are ms, I think it's not best values. A trigger well put i
think will help me better, cause I can make after that an alaysis for a week
time and take propper decision for code optimization. I put in some
procedures a code with getdate at start, enddate at the end, procedure id,
etc, but there are a lot of procedures.
Thank you

15 Mar 2007 12:24 PM

Uri Dimant

CM

I'd run SQL Server Profiler to group by Duration event to see how long it
is running

Show quoteHide quote

"CM" <C*@discussions.microsoft.com> wrote in message
news:9C916A15-895F-4F0C-B1DD-D44F41B29BAC@microsoft.com...
> Hello,
>
> Will be very usefull for me if I know what are the stored procedures more
> often use in a database and how long is the execution time.Can someone
> help
> me in putting a trigger, or getting this values from tempdb maybe ? I know
> profiler (RPC completed I guess) , but I can't understand duration -
> sometimes, if that are ms, I think it's not best values. A trigger well
> put i
> think will help me better, cause I can make after that an alaysis for a
> week
> time and take propper decision for code optimization. I put in some
> procedures a code with getdate at start, enddate at the end, procedure id,
> etc, but there are a lot of procedures.
> Thank you