I currently have an application server and a database server both running on Windows Server 2008 R2. I have been tasked with generating a weekly report on the utilization of CPU, Memory and Disk. I am planning on using the default Performance Monitoring Data Collection Set Template in Windows Performance Monitor and was wondering what are the best practices for scheduling the job to run? My preference would be for the data collection set to start at the beginning of each week and stop at the end. Would this be overkill? Also, would performance monitoring drag down system performance?
The use of our application will most likely be very irregular. A number of batch jobs run at night and users are likely to access the system when they arrive at work in the morning, so I am worried that a smaller sampling window would miss the true system utilization.
Also, I found some basic tutorials for setting up data collection, but had trouble finding more general info on best practices for weekly performance management using Windows Performance Monitoring. If anyone has a good source please share.