execution monitoring | SQL Server Performance Forums

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
SQL-Server-Performance.com All in Love is Fair
Stevie Wonder
All postings are provided “AS IS” with no warranties for accuracy.