Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

monitor a specific job/stored proc with profiler

Status
Not open for further replies.
Jun 27, 2001
837
US
I have a sql job(that runs several stored procs) that is run to fix a problem, it is set to run every few minutes (no, this is not my idea). What would be the best way to identify how much this specific job/and it's sp's are using in resources, such as cpu and memory?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top