Post reply

Daily Perfmon counters

  • October 7, 2009 at 8:26 am

    #216136

    Hello

    We're considering having daily Perfmon counters running all day monitoring our SQL Servers. Having read a lot of articles there doesn't seem to be anything concerning running Perfmon counters throughout the day to capture running performance details.

    What is your opinion on this and how often should they be run, every minute?

  • October 7, 2009 at 8:32 am

    #1062813

    run it about every 5 min,,,that should be plenty.I run mine often send it to csv file. then export to excel

    Just make sure you run it from a non sql server so you dont take up any SQL resources

  • October 7, 2009 at 8:34 am

    #1062814

    Thanks. Does yours run all day?

  • October 7, 2009 at 9:00 am

    #1062847

    I don't run perfmon all day, but I do run Microsoft Operations Manager 24/7 and it's consuming performance monitor counters. As long as you're not collecting too much data or refreshing that data too frequently, this is a fine way to operate.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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