Mapping out Server usage 1

[Will192]

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.

 

[ptheriault]

SQLSentry will do everything you just described.

- Paul
- Database performance looks fine, it must be the Network!

 

[ptheriault]

Here is info from their site.

http://www.sqlsentry.net/

Scheduling: Intelligent Outlook-style calendar view of a server's job schedule.

Alerting: Choose from up to 9 different response actions for 77 different events!

Monitoring: Track schedule contention with Windows performance counters.

Chaining: Prevent schedule conflicts via advanced chaining and queuing.

Reporting: Comprehensive charts and graphs for job performance.


- Paul
- Database performance looks fine, it must be the Network!