I am looking to simplify and increase the uptime of my data center. I have a small (100G) but active transactional database which is currently using eight internal SCSI disks. I want to move to an active/passive database situation -- I have SQL server 2000. I also want to minimize the downtime of the storage hardware. The database is "somewhat" mission critical as it can be taken down on weekends for brief periods of time but it must deliver during the week.
Would you suggest external RAID storage or a SAN? I want to spend less than 20k on the storage portion of the solution to start with the ability to add more drives as our needs grow. Any product recommendations would be well received!
Yes, I would suggest a SAN which gives you external storage that can be shared between servers which in turn allows you to add storage resources non-disruptively. External
storage will also enable you to use a clustering solution such as MSCS which will make your
server resource more highly available and allow you to perform normal server maintenance on your
nodes by moving the application between the nodes in the cluster.
I do not normally do product recommendations since my answers need to be vendor neutral. That being said, there are a number of storage vendors out there that can offer you very inexpensive SAN storage solutions.
Since you only have a couple of servers to connect, you can bypass SAN switch
for the time being by direct connecting the servers to the shared storage array using FC-AL( Fibre Channel Arbitrated Loop) hardware. As your server farm and storage needs grow, just add switches and storage.
I would first check with your server vendor for cheap SAN products. Dell, Gateway, HP, IBM, Sun, etc. all have low cost SAN products that you should be able to use.
Editor's note: Do you agree with this expert's response? If you have more to share, post it in one of our
Dig Deeper on Database storage
SAN expert Chris Poelker compares connecting a SAN with wavelength cabling and dark fiber and discusses the pros and cons of each.
SAN expert Chris Poelker discusses how to change the size of a LUN in a Microsoft cluster server environment.
Storage expert Chris Poelker outlines WWN basics in order to answer the question: "Why do HBAs in a SAN have same base?"