Archive for January 10th, 2008

SQL Counter: Part 8 (Disk Read/sec) January 10th, 2008

Vinod Kumar

PhysicalDisk Object -> Avg. Disk Sec/Read
This counter measures the average time, in seconds, of a read of data from disk. If the average value increases over time, then it points to a potential read performance problem. Possible reasons can be that the load has increased over time, the ratio of read/write has changed, the access pattern has changed, or the device is fragmented.

Continue reading...


 

Performance tuning and capacity planning for PPS monitoring January 10th, 2008

Vinod Kumar

Download the whitepaper here.

Continue reading...