What is faster SAN or DAS (local disk), and most importantly why?
So here’s an answer to the great myth of SAN, it isn’t always going to be faster than local disk (or DAS, JBOD, etc.). The reason for this is actually pretty straight forward. Local disk is cheap. That’s the reason in a nut shell. Let me see if I can’t explain in a little more […]
DAS, NAS and SAN oh my.
In the server world we have three different kinds of storage available. Today, only two of these can be used with your SQL Server (as long as you want to keep the SQL Server in a supportable configuration). Your three options are Direct Attached Storage (DAS), Network Attached Storage (NAS) and Storage Area Network (SAN). […]
Why can’t I just use RAID 10 for everything?
In a perfect work, you would use RAID 10 for everything. However we don’t work in the perfect world, we have budgets to deal with. And these budgets mean that we have to make sacrifices at times so we don’t get what we want. RAID 10 is very expensive to implement, much more so per […]
Expanding local storage with minimal downtime
Welcome to the first day of storage week of SQL University. Over the next week, we’ll be covering some different topics, at different levels, but hopefully the information is useful to everyone. One of the big reasons that companies pay for storage arrays is that when it comes to expanding storage (LUNs) you can do […]