.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

sys.dm_exec_procedure_stats - execution_count

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :Sql Server
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

More Related Resource Links

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend