How often a Stored procedure is run

• iajm

  SSC Journeyman

  Points: 85

  More actions

  February 23, 2004 at 10:04 am

  #65792

  I need to find out how often a set of Stored procedures are kicked off and ran.  I have "aquired" a database with a ton of stored procedures some are not even kicked off.  I need to know which ones are kicked off the most.

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  February 23, 2004 at 11:51 am

  #495196

  Try SQL Server Profiler.