SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Mapping out Server usage
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

ws5926
Yak Posting Veteran

USA
88 Posts

Posted - 10/30/2006 :  08:36:43  Show Profile
Before I start poking around in the system tables, I figured that I would ask around on some forums first.

What I want to do it two things:

1. Show on a graph how long each one of my nightly jobs runs, scheduled through SQL Agent. Also I want to show on this graph where my jobs overlap and fight for resources.

2. Show on a graph cpu and disk usage for the time period when my nightly jobs run. I know that this info can be captured through the task manager and exported to SQL Server Reporting Services, but I haven't had time to set it up yet.

I want to compare the two graphs and see if I have any time 'hotspots' of the night and then I can move stuff around to get things done faster.

Does anyone know of any products out there that would help me out? I figured that I would ask around before I started developing my own process, hoping that someone else has already done this before.

Thanks in advance for any responses to this post.

Live to Throw
Throw to Live

mr_mist
Grunnio

United Kingdom
1870 Posts

Posted - 10/30/2006 :  08:41:28  Show Profile  Visit mr_mist's Homepage
Should be able to get job info (duration etc) from sysjobhistory table.

Can get cpu and disk info through perfmon in control panel - admin tools, save it as a csv and then put the results into Excel to get a graph.

-------
Moo. :)
Go to Top of Page

ws5926
Yak Posting Veteran

USA
88 Posts

Posted - 10/30/2006 :  09:08:18  Show Profile
That's what I had planned on doing. I was just wondering if anyone had some freeware or some scripts to convert the syshistory or something like that.

I have started to setup a query to convert the info in syshistory.

Live to Throw
Throw to Live
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000