From The Server To The SAN

Enter SANdman When people buy SANs, it’s often quite a large investment. Whether it’s all SSD, all flash, or there are tiers of storage that different types of data live on, those disks aren’t cheap. When people visualize their SAN, it’s usually just the server and the pool of drives. But there’s some important stuff…
Read More

Monitoring SSD Performance

Everyone wants to make sure they’re getting the best performance out of their solid state storage. If you’re like a lot of people, you want to make sure you’re getting what you paid for, but how do you know for sure that the drive is performing well? Watch that Average The first way to monitor…
Read More

How to Interview Storage Vendors

Buying SAN gear is hard work.  You have to compare vendors based on performance, capacity, reliability, ease of implementation, quality of support, and of course, price.  When I’m working with a client buying new storage, here’s the questions I have them ask each prospective storage vendor. Q: If we buy SSD, SAS, and SATA drives,…
Read More

How Fast Does Your SAN Need to Be for SQL Server?

Let’s oversimplify the bejeezus out of this complex problem.  Suspend your disbelief for a second and work with me: We have a database server hosting just one 100GB table.  Sure, in reality, we’ve got lots of databases and lots of tables, but we’re going to keep this simple.  We’ve got a simple sales table that…
Read More
All the better to store you with

Automated Tiered Storage for Databases

Database administrators want just one kind of storage: fast. Companies want just one kind of storage: cheap. Since fast storage isn’t cheap, and we can’t put everything on slow storage either, we end up buying different tiers of storage. Let’s start by pretending that we’re buying a new HP DL370 G6 to act as a…
Read More
Iomega StorCenter PX4-300d NAS

Iomega StorCenter PX4-300d NAS Review: iSCSI Monster

I wanted to love this monster from the moment I read the spec sheets: Iomega StorCenter PX4-300d NAS Network attached storage device with 4 or 6 hot-swappable drive bays Available empty (so you can bring your own drives, including SSDs) iSCSI server with 2 network ports, jumbo frame support, VLANs Official VMware ESX/ESXi, Hyper-V, Windows…
Read More

SAN Snapshot Smackdown

On Twitter, several SAN pros were saying their snapshots can pull off some nifty stuff.  Well, it’s time to find out just how true that is. Let’s say we have a data warehouse with: One 2TB database, using SQL Server partitioning – needs 8 data files and 1 log file One 200GB database for reporting…
Read More
Fusion-IO ioDrive

Fusion-IO ioDrive Review

Solid state drives (SSDs) have gotten a lot of press because they can be dramatically faster than magnetic hard drives.  They use flash memory instead of spinning magnetic platters.  Since any bit of memory can be accessed at any time without moving a hard drive’s head around, SSD random access is insanely fast. Fusion-IO ioDrive…
Read More