Post reply

query to return all proc calls in order for timerange

  • June 25, 2014 at 8:16 am

    #309475

    I have a query using the sys.dm_exec_query_stats that returns the last exec of all proc calss for the last day and execution times.

    Is there a way to get all the executions and not just the last w/o using a db trace?

  • June 25, 2014 at 8:53 am

    #1724670

    Extended events or profiler is only way I know. You cannot use queries into the DMVs because I think they can have data removed due to memory management needs at whatever needs the engine has.

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply