Find the Most Used Stored Procedures in SQL Server

added by bunglebooz
1/7/2011 9:29:07 AM

2 Kicks, 85 Views

One of the suggested methods to get information of the most executed code is to create a trace or use a tool that does that, and then query the results. However since SQL Server caches information over time, you can extract such information using the sys.dm_exec_query_stats. Let us see how to use the sys.dm_exec_query_stats DMV to return the 3 most used stored procedures in your SQL Server database