Is there a way to find the highest disk queue length and time within the past four hours in SAN HQ? I think the report only shows for a particular point in time...
I ran another test and the highest Average Queue Depth was 23-25. I have opened a support case, but the support tech hasn't gotten back to me after I sent the SAN diagnostics.
Yes, the NTFS sector size is set to 64kb. I was talking about the volume sector size. The choices are between 4k and the default 512b. Originally, I was testing on a 4k volume sector size and recently I am testing with the default 512b volume sector size.
In this test I am currently running, I have changed the sector size from 4k to 512b and using two volumes. The highest Average Queue Depth is 25 and 26 with Average Latency at 30.64ms and 31.29ms and Average IOPS at 1,115.64 and 1,115.36. Average I/O Rate is 69.71 MB/sec and 69.69 MB/sec. Are these values really bad?
I used the highest value in NTFS which is 64k. Is that the block size? If not, where can I find that information? The percentages for read/writes are 86.2% reads and 13.8% writes. However, on the SQL Server I/O DMV, Average Read Stalls are 38.7ms, Average Write Stalls are 1,965.7, and Average I/O Stalls are 1,001.8ms for the TempDB data files (there are 12 data files and all of them are the same size).
If you select a Volume the upper graph shows you the Avg. I/O size.
But for this kind of troubleshooing the "Live Session" feature is more usefull because you recorded the given Timeframe and Perfdata will be collected every few seconds which gives you a more granular result.
dajonx
2 Intern
•
294 Posts
0
July 29th, 2014 10:00
PerfMon
dajonx
2 Intern
•
294 Posts
0
July 29th, 2014 10:00
Is there a way to find the highest disk queue length and time within the past four hours in SAN HQ? I think the report only shows for a particular point in time...
Origin3k
4 Operator
•
2.4K Posts
0
July 29th, 2014 10:00
You can move and 'resize' the grey slider in the upper right to adjust the view.
Regards,
Joerg
dajonx
2 Intern
•
294 Posts
0
July 29th, 2014 10:00
I think the highest Average Queue Depth I saw on SAN HQ was 20 for both volumes (G:\ and G:\Mount).
dajonx
2 Intern
•
294 Posts
0
July 31st, 2014 08:00
I ran another test and the highest Average Queue Depth was 23-25. I have opened a support case, but the support tech hasn't gotten back to me after I sent the SAN diagnostics.
dajonx
2 Intern
•
294 Posts
0
July 31st, 2014 09:00
Yes, the NTFS sector size is set to 64kb. I was talking about the volume sector size. The choices are between 4k and the default 512b. Originally, I was testing on a 4k volume sector size and recently I am testing with the default 512b volume sector size.
dajonx
2 Intern
•
294 Posts
0
July 31st, 2014 09:00
In this test I am currently running, I have changed the sector size from 4k to 512b and using two volumes. The highest Average Queue Depth is 25 and 26 with Average Latency at 30.64ms and 31.29ms and Average IOPS at 1,115.64 and 1,115.36. Average I/O Rate is 69.71 MB/sec and 69.69 MB/sec. Are these values really bad?
dajonx
2 Intern
•
294 Posts
0
July 31st, 2014 10:00
I used the highest value in NTFS which is 64k. Is that the block size? If not, where can I find that information? The percentages for read/writes are 86.2% reads and 13.8% writes. However, on the SQL Server I/O DMV, Average Read Stalls are 38.7ms, Average Write Stalls are 1,965.7, and Average I/O Stalls are 1,001.8ms for the TempDB data files (there are 12 data files and all of them are the same size).
dajonx
2 Intern
•
294 Posts
0
July 31st, 2014 10:00
I am executing update statistics on a large table in SQL.
Can you please tell me where in SAN HQ I can find that information?
Origin3k
4 Operator
•
2.4K Posts
0
July 31st, 2014 10:00
If you select a Volume the upper graph shows you the Avg. I/O size.
But for this kind of troubleshooing the "Live Session" feature is more usefull because you recorded the given Timeframe and Perfdata will be collected every few seconds which gives you a more granular result.
Regards,
Joerg
dajonx
2 Intern
•
294 Posts
0
July 31st, 2014 10:00
Ah, thank you.
The Average I/O Size is 64kb (constant) for Write I/O and the Read I/O ranges from 0 to 64kb.