Look at SQL Profiler. It allows you to capture execution times and the
query text being run.

Brian Freeman
Carnegie Technologies/Bluewave Computing
(770) 916-0595 ext. 415
www.carnegie.com/www.bluewave-computing.com



-----Original Message-----
From: Devin Wong [mailto:devin.[Email Address Removed]
Sent: Wednesday, December 17, 2003 11:40 PM
To: LazyDBA.com Discussion
Subject: template for collecting the run time for several procedure
calls


Dear all,

I am a novice in SQL server. However, I was asked to collect the
performance of running several stored procedures in a row for many
times. I would like to collect the response time of each procedure call,
but I could not figure it out. I am hitting the deadline now. Would you
please kindly give me some scripts template to perform the task? Thank
you very much.

Cheers,
Devin

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Get
today's cartoon: http://www.LazyDBA.com To unsubscribe, e-mail:
mssqldba-[Email Address Removed] For additional commands, e-mail:
mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page