I am having an issue with performance monitoring that I'd like some tips on.
I am trying to use Performance monitor to monitor my sql server. However, I have been told that running the logs on the server that I am monitoring will place a burden on the server and skew the results. So, I am trying to use another server.
The server that is doing the monitoring is windows server standard 2008 R2 64-bit. The server being monitored is Windows server enterprise edition 2003 32-bit.
the issue that I am getting...
I try to view the log files by openeing performance monitor on the 2008 server. However, when I choose the log files as the source, iit says:
Data source C:\PerfLogs\Admin\Sqlserver performance\monitorserver_20100921-000002\DataCollector01.blg is either invalid or cannot be found. System message: Unable to read counter information and data from input binary log files.
At any rate, can anyone confirm or refute the idea that running the logs on the same server places an undue burden on the server? Performance on this server is sensitive to our business, so I can't be doing anything to it that I don't have to.
Can anyone make heads or tails of this error message? maybe I set up the counter wrong?