• Hello again, I am happy of Your advises if any

    I found a situation, that confused me

    Once I've got a snapshot of sys.dm_exec_procedure_stats into temp table

    after ~20 minutes I've got the another snapshot from the same DMV

    comparing the results I've found one SP that was run 2431 times (during that 20 minutes)

    but the trace, that was running at the same time period cought only ONE execution of the SP

    In addition I was inspecting sys.[dm_exec_cached_plans] ... but there were unusual values to the plan of the SP... refcount=3, usecounts=1

    Q: Where should I look in addition to find all the executions of the SPs like I've mentioned