I am new with Perfmon data collection and analysis.
I was trying to analyze the data in the sample csv uploaded. I have analyzed the data for PhysicalDisk(_Total)\Disk Reads/Sec and PhysicalDisk(Total)\Avg.Disk Queue Length , I getting very high peak values 2899.44 and 825.90. Am I analyzing data incorrectly ?
I have read in the white paper ,troubleshooting Performance Problems in SQL server 2008:-
If your disk queue length frequently exceeds a value of 2 during peak usage of SQL Server, you might have an I/O bottleneck.
Avg. Disk Sec/Read is the average time, in seconds, of a read of data from the disk. The following list shows ranges of possible values and what the ranges mean:Less than 10 ms - very good Between 10 - 20 ms - okay Between 20 - 50 ms - slow, needs attention ,Greater than 50 ms – Serious I/O bottleneck
Please correct my understanding ?
Your guidance will greatly be appreciated.
Can you please correct my understanding.