I currently have a Smart Array E200 controller. Configured with 3 Hard drives Raid 5. If i wanted to add another Hard drive to this how would i go about doing this? The only reason i ask is because it seems to be bottle necking during certain hours during the day. I am running SQL 2005 on this machine. I have recently updated all of the drivers and firmware for the storage controller, array and bios on the server to see if it would resolve the issue but it did not. I have also ran an offline diagnostic on the hardware and all past with no errors.
The server is a HP Proliant DL 180 G5.
I read a couple of threads and they recommend that after monitoring the Avg. Disk Queue Length and the Current Disk Queue Length and both are maxing 100 from time to time could be that i may need either a faster disk, Moving some files to an additional disk or server or
Adding disks to a RAID array if one is being used.
Any other ideas would be very helpful.
Thank you in advance