sql-lover (1/2/2013)
Hi Perry,What am I going to accomplish with that? Given the current file size and settings, results are pretty much accurate, in my opinion.
The HBA queue depth (or outstanding I\Os) dictates how many I\O requests may be active for that bus adapter.
Higher queue depth = increased throughput.
Don't raise it to high though or you'll just saturate the storage sub system and that's often worse than setting too low.
sql-lover (1/2/2013)
What I do not get, is why increasing the allocation unit will improve the overall latency or disk performance. I do not see why or at least, would like to see the technical explanation for that.
The file allocation unit size alone will not have much effect, it's closely related to the stripe size and the partition starting offset. See this link for more info.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉