Performance Monitoring - Analyzing Results

[TechieTony]

Morning All,

I am having trouble with a windows server of mine that I cant pin down. About 2 weeks this server started to slow down exponentially which went hand and hand with my backups getting longer. I was told to check the "Disk Activity" on the server so I started to up my performance monitor skills.

I used this guide :

http://blogs.technet.com/vipulshah/...leshooting-sql-server-performance-issues.aspx

... Well I set my counters and everything seemed to be working ok. Then I created a job with the same counters and ran it overnight to collect the data i needed thinking I could review the results in the morning. Well my hopes were dashed! Only 4 of the counters actually recorded data

Pages/sec, % Disk Time , Avg Disk Queue Length , % Processor

while the rest simply return "-------" as the values.

ex: Pages/sec, % Usage , Avg Disk sec/Read

But the curveball is that if I take my .tsv and save the file I can see all of the values actually recorded the data... I just cant see it.

Am I analyzing these incorrectly or is their another way of monitoring my disk activity and I/O. May my perfmon mmc is corrupt?

Any thoughts on this.. Thanks

Noncentz