In the final part of my SQL University serries, I talk about the nightmares of storage: why things change when we’re not looking and why virtualization makes it harder to keep an eye on things.
In part 2 of this series, I cover magnetic hard drives, solid state drives, and RAID arrays. I explain the pros and cons of each, and I discuss their relative speeds.
In part 1 of a multi-part series, I talk about what SQL Server stores, why your data and transaction files are usually best kept on separate drive arrays, and why cache doesn’t always help.
Storage Area Networks (SANs) can do multipathing, but what does that really mean? I explain the differences between failover and performance load balancing, and talk about why active/active multipathing isn’t what it seems.
In the beginning, God made drives directly attached to our computers. Over time, man decided to get jiggy with it and use Storage Area Networks. Learn why pathing is so important to these two systems.
