The Disk Queue Length for the volume where the SQL DB resides was extremely high at a value of 40.
The performance monitor on the SQL server clearly showed this. If the average disk queue length of 2 is exceeded for continuous period of time, then this is pointing towards an I/O bottleneck on the HDD volume
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Términos de uso Privacidad Cookie Preference Center