Monitoring the performance of Server

  • Hi,

    I have enabled the Microsoft Perfmon Tool to monitor the performance of Application and Database Server. I've enabled more than 60 counters and logging the monitored data. I want to know, if I enabled more than 60, what would be the server performance. Is Perfmon tool affects any performance. Is tool consumes CPU,Memory etc.

  • Yes, it will have an effect. How much of one depends not only on the counters but on the frequency that you are logging the events.

    I would suggest you try such a trace on one of your testing/development servers to see how much of an impact it has before you set it up on your production server.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Hi,

    Thanks for your reply. Actually, i enabled 59 counters to monitor cpu,disk,memory,network,asp.net applications etc. And I cant enabled in testing/development server. The load for these servers are very low. So, I enabled in production. And the frequency for logging is every 1 hour.

    And, I cleared the log once a week. I really want to know that perfmon tool use memory/cpu for monitoring the server.

    If server hangs or server load is high, how perfmon tool log the values.

  • I am running 41 measures at a rate of every 5 minutes with no noticeable slowdown.

    In addition, I have a Performance Monitor set up remotely at 1 minute with no effect on performance.

    If you set it up remotely, it has less of an impact.

    ---------------------------------------------------
    No matter where you go, there you are.

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

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