Why should one use SAN instead of local hard disk?
I am really a novice in hardware configuration.
asked Jun 10, 2010 at 03:44 PM in Default
Just to spell out my 2 cents in a separate answer:
Hope that helps.
If you have money to burn, you might want to check out RamSAN systems. They're pretty awesome. Actually, I had one in to test once, and it was pretty good on the whole IO front both in terms of rate and IOPS, but it didn't make our application much faster in practice because it was pretty well optimised, and most of the time taken was network latency anyway.
answered Jun 10, 2010 at 06:38 PM
Matt Whitfield ♦♦
It depends what connects you to the SAN and how the local disks are configured. If you have the time then benchmark both and pick the one that will best suit your needs. There are so many different factors that impact on your situation it will be impossible to answer it here, based on the information you have provided. I would recommend reading up on your options in Books Online and some blogs of SQL Server performance tuning gurus like Brent Ozar
answered Jun 10, 2010 at 04:04 PM
The reasons to use a SAN are not, strictly speaking, technical. We use a SAN because it provides a mechanism for rock solid high availability. In terms of shear performance, there are faster methods to store data. But few are as reliable. We use the SAN because it gives the business the warm & fuzzies it needs to know that it's data will always be available. Funny thing is, the vast majority of data on the SAN is unstructured data, not relational data.
answered Jun 10, 2010 at 04:33 PM
Grant Fritchey ♦♦
It really isn't black & white.
SANs have tools for cloning, data backups etc.
Local drives are easier to configure.
Basically it comes down to choosing what you need. As Fatherjack said benchmark the differences if you can and then weigh the differences.
answered Jun 10, 2010 at 05:00 PM
As many others have mentioned, there are a lot of variables floating around in your choice of storage. I am not going to rehash all the good points made by Matt and Grant and others, but I think two are worth reemphasizing/rephrasing.
You may notice that I and many of the other posters are using a lot of caveats like generally and often. That of course is because a lot depends on the specific configurations and pieces of hardware that you are looking at and your use case. Fatherjack expressed this very well.
One of the big points Grant correctly made was that Sans are generally more reliable. Of course he is right, but remember that you can install a well configured RAID setup with automatic backup to another media all into one (large) computer box without problems and have enormous reliability on the storage side of things, and on the flip side, a poorly configured San with no redundancy could be unreliable.
If you really want to boil it down to a rule of thumb, if you have a very small number of servers (say 3 or fewer) then you are probably better using local drives. They will generally be faster and cheaper and if configured properly can be quite reliable. If you have numerous servers and do not have a need for physical separation of data (this is often required with some types of sensitive data), then you are better off with a San. The maintence tends to be easier and benefits such as greater flexibility and ability to set up failover clustering can be valuable.
answered Jun 10, 2010 at 07:03 PM