How to find the most frequently executed procs

• rocky

  SSCrazy

  Points: 2120

  More actions

  October 18, 2004 at 2:38 pm

  #59537

  I want to know how many times each stored procedure gets executed for a given hour. I ran a trace using profiler template sqlprofilerSP_Counts and saved the trace results to a table, SP_COUNTS. I did a 'select distinct objectid from SP_COUNTS' to find the procs that were executed during the trace. How can I find out the number of times each was executed and store the sp_name and count in a table?

  thanks

• chrismj

  SSChasing Mays

  Points: 618

  More actions

  October 19, 2004 at 1:48 am

  #527126

  This should do the trick

  insert Results

  select name, Count(ObjectID) as Cnt from SP_COUNTS

  inner join sysobjects on ObjectID = ID

  group by ObjectID, name

  The Results table has two columns Name and Cnt

   

   

   

• Len-26184

  SSC Enthusiast

  Points: 162

  More actions

  October 19, 2004 at 5:23 pm

  #527258

  check out http://www.hybridx.com

  SPUD