Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > Get execution count of a Stored Procedure

Get execution count of a Stored Procedure

Table of contents
Created by Wendell Bazile, last modified by Aileen de Lara_ret on Sep 01, 2016

Views: 1,014 Votes: 0 Revisions: 3


Steps to get the Execution Count of a Stored Procedure.


All Orion Core products


Attach to the database via database manager or sql management studio and run the following query:

SELECT DB_NAME(st.dbid) DBName

      ,OBJECT_SCHEMA_NAME(st.objectid,dbid) SchemaName

      ,OBJECT_NAME(st.objectid,dbid) StoredProcedure

      ,max(cp.usecounts) Execution_count

 FROM sys.dm_exec_cached_plans cp

         CROSS APPLY sys.dm_exec_sql_text(cp.plan_handle) st

 where DB_NAME(st.dbid) is not null and cp.objtype = 'proc'

   group by cp.plan_handle, DB_NAME(st.dbid),



 order by max(cp.usecounts)





Last modified