SQL Server Performance Forum – Threads Archive

execution monitoring

I#%92ve hundreds of stored procedures which are executed every day to make certain tasks. It wanted to know if somebody knows some method to determine the sp#%92s execution time. As developer I do not have access to SQL Server administrative thanx
——————–
Jose Angel Contreras

You can run Profiler to find duration, cpu time, read, etc. But if you don’t have access then ask for that to DBA administrator. Saludos, hermano.
Luis Martin
Moderator
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided â€œAS ISâ€ with no warranties for accuracy.

]]>