Submit a ticketCall us

ebook60.pngHow to be a Cisco® ASA ace

Our eBook, Thou Shalt Not Pass…I Think?! can help you overcome the challenges of monitoring and managing Cisco ASA firewalls. This eBook is a great read if you’ve been frustrated with monitoring firewalls, managing ACL configs, and troubleshooting VPN connections.

Get your free eBook.

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_ret on Sep 01, 2016

Views: 906 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

Tags

Classifications

Public