SQL Server Performance

execution monitoring

Discussion in 'T-SQL Performance Tuning for Developers' started by jacpicasso, Jan 15, 2007.

  1. jacpicasso New Member

    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
  2. Luis Martin Moderator

    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.



Share This Page