SP Last Execution Time

• jfordyce

  SSC Journeyman

  Points: 94

  More actions

  February 9, 2009 at 7:54 am

  #127940

  Hello,

  I was trying to find a way in either/both SQL 2000/2008 to identify Stored Proc's last actual execution time or something that would tell me that the stored procedure is no longer in use by our system so that I can clean out the garbage before we rearchitect our entire core.

  Thanks.

• GSquared

  SSC Guru

  Points: 260824

  More actions

  February 9, 2009 at 7:58 am

  #940494

  Run a server trace for a reasonable amount of time. That'll tell you exactly what's being run and how often.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon