Home Forums Article Discussions Article Discussions by Author Discuss content posted by Erin Stellato Back to Basics: Capturing Baselines on Production SQL Servers RE: Back to Basics: Capturing Baselines on Production SQL Servers

  • November 28, 2012 at 7:50 am

    #1563163

    Bennett Scharf (11/27/2012)

    Hey Erin,

    This is great - especially the idea of baselining your configuration data!

    On a related note, I log and analyze my performance counters through Performance Monitor, mainly because it's quick and easy to use it's built-in graphical tool. I'd be interested to know how you and others *quickly* graph stuff like performance counters when the data is stored in a SQL table.

    Thanks again,

    Bennett

    Bennett-

    First, thanks for reading! Second, that's a great question. I don't usually (ever?) graph those counters by pulling the data from the database. I like having the data in the database so I can quickly do averages and comparisons across multiple time frames. If I want to graph the data, I would run it through PAL (Performance Analysis of Logs) which is a free tool available on CodePlex: http://pal.codeplex.com/

    Now, I would guess (completely a guess) that you could graph that data via Report Services. But I have never tried...would love to hear if anyone else has done that.

    Erin