July 16, 2008 at 9:40 am
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.
July 16, 2008 at 10:39 am
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
July 17, 2008 at 1:12 am
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.
July 18, 2008 at 5:31 am
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