Posts Tagged ‘Cached Plans’

T-SQL How To Get the Execution Count Of a Stored Procedure

How to Get the Execution Count of a Stored Procedure ? This Query will get the top 100 stored procedure by max execution time. This is good indicator for developer to determine heavily used procedure. This can help developer to know if his code needs to replaced or Maintained, and for SQL admin to but […]

More »