Post reply

Maintain Performance History

  • March 23, 2005 at 4:13 am

    #109454

    Hi

     Is there any way to store performance monitor output in a database table ?

     I want to store only hourly averages of defined counters?

     

    Thanks

    Khalid

  • March 23, 2005 at 6:09 am

    #548435

    SQL Counters are stored in the sysperfinfo table you can use this.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • March 24, 2005 at 2:20 am

    #548675

    Hi

       Thanks for very useful information. I also want to know how sysperfinfo table store counter values does it stores values automatically or do we have to run performance monitor to get the fresh values? If it stores values automatically then why we run performance monitor?

     

    Thanks

    Khalid

  • March 24, 2005 at 6:36 am

    #548718

    The counters are updated in real time in sysperfinfo. You do need to check out how to extract the information and the format/method in which it is stored.

    There were a couple of articles on the sqlmag.com web site and I suspect an article somewhere on here.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply