I have a stored proc that I was trying to find out how much it's being called for performance reasons.ÃÂ I looked in sys.dm_exec_procedure_stats, at the execution_count column, but this number seems extremely high for what I expected.ÃÂ So, I opened up Profiler and did a trace on the same proc, but the count was significantly less than the DMV.ÃÂ I see the execution_count increment without an event in Profiler.
Does anyone know why this is?ÃÂ In Books Online, the description for the the execution_count column is: "Number of times that the stored procedure has been executed since it was last compiled.
"ÃÂ Why am I not seeing the count grow at the same rate as the events being captured by Profiler?
Thanks in advance.
View Complete Post