February 17, 2004 at 5:35 am
Recently we upgraded the RAM and OS to WIN 2003 , on our SQL Server Active/Active cluster and after that we have been experiencing problems of High Disk Queue Length. On investigation it was found that it is read disk queue length which is high.
No Changes has been made to teh SQL Server in the upgrade process except for RAM , we have enabled awe memory and have specified the MAX size of memory.
Is this a known issue/bug? Any ideas?
February 17, 2004 at 2:19 pm
I can't help with your question. But I can tell you that you posted in the wrong forum. This is specifically for the Question Of The Day. And that's not just ANY QOD. The QOD is like a contest, you find it via the Resources link.
Please post your question in an appropriate forum.
-SQLBill
February 19, 2004 at 2:37 pm
hardwarewise, memory,cpu and IO limits sql server performance.
since you upgraded your host, it might push more IO request to your storage, which means now you need to upgrade your storage too.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply