Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mikebird
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... |
|
|
robvolk
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 @@spidIf you log each step you can compare CPUTime and determine how much each step used. |
 |
|
|
mikebird
Aged Yak Warrior
529 Posts |
Posted - 2009-09-03 : 10:54:36
|
| Nice idea. Done. Of some use |
|
|
|
|
|
|
SP_WHO2 active