SQL Server Performance

Mapping out Server usage

Discussion in 'Performance Tuning for DBAs' started by Will192, Oct 30, 2006.

  1. Will192 New Member

    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
  2. Luis Martin Moderator

    Try SQLDiagnostics rom Idera.
    This tool give you all information about CPU, Disks, etc. Also you can find jobs duration.
    About the 1rs point, I think you have to graph manually.

    Luis Martin

    All in Love is Fair
    Stevie Wonder

    All postings are provided “AS IS” with no warranties for accuracy.

Share This Page