Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SP_WHO2 active

Author  Topic 

Aged Yak Warrior

529 Posts

Posted - 2009-09-03 : 06:52:18
Once running this and monitoring the CPU Time on a job, is it possible to keep history of the CPU Time used on a job once it's complete, or amount used per second, so I can tell the scope of how much I tax the processors?

I'm running all sorts of jobs on SSME as well as different types of apps as well, mostly Crystal Reports, and I need to know the scope of these, and how to manage them simultaneously...

Most Valuable Yak

15732 Posts

Posted - 2009-09-03 : 09:20:58
You can create a log table with the same structure as the sp_who2 output, then add a job step at the end with the following:

INSERT LogTable EXEC sp_who2 @@spid

If you log each step you can compare CPUTime and determine how much each step used.
Go to Top of Page

Aged Yak Warrior

529 Posts

Posted - 2009-09-03 : 10:54:36

Nice idea. Done. Of some use
Go to Top of Page

- Advertisement -