Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

Home > Success Center > Network Performance Monitor (NPM) > 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 on Sep 01, 2016

Views: 8 Votes: 0 Revisions: 3

Overview

Steps to get the Execution Count of a Stored Procedure.

Environment

All Orion Core products

Steps

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),

            OBJECT_SCHEMA_NAME(objectid,st.dbid),

   OBJECT_NAME(objectid,st.dbid)

 order by max(cp.usecounts)

 

 

 

 

Last modified
21:03, 31 Aug 2016

Tags

Classifications

Public