SQL Server Performance Forum – Threads Archive
Best Practices with IBM DS400 SAN?
I’m curious if anyone has experience with the IBM DS400. We have one of these as well as a single EXP400. This SAN support two SQL server applications and is comprised of 4 arrays. Enclosure 1 (2 arrays, (1) Raid 5 and (1) Raid 1)
Enclosure 2 (identical to above) All traffic is routed through one of the two controllers available. For starters, does it make sense to move the arrays on enclosure 2 to the second enclosure. Thanks, Scott Caldwell
Can take help of thishttp://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1104027,00.html link. HTH Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
Why are you only using one of the two controllers? MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
Mr. Leggett,<br /><br />Uhh, that’s a good question. This hardware was installed and setup by our network engineer. How dare I question his reasoning for doing anything <img src=’/community/emoticons/emotion-5.gif’ alt=’‘ />. It’s my bag now and I’m just trying to get a handle on the whole thing.<br /><br />Thanks for any input you might have.<br /><br />Scott
i will flat say: many network/SAN engineers appear to have zero knowledge of distributing load.
Most server systems today have 2 network ports, yet most network engineers seem to have no idea on the concept of distributing network load across both available network ports.
same applies to the SAN controller ports in any case, you should have a load test done on the SAN, so that you can question whether it is delivering the right performance per disk and configuration