Storage for DBAs: Take a look in your data centre at all those humming boxes and flashing lights. Ignore the storage and networking gear for now and just concentrate on the servers. You probably have many different models, with different types and numbers of CPUs and DRAM inside. My question is, which CPUs are the most … Continue reading The Most Expensive CPUs You Own
Category: Storage for DBAs
The Real Cost of Oracle RAC
Storage for DBAs: In my previous article (in this mini-series on database economics) I explained how to calculate the cost of a mid-range Oracle database system. My motive was a concern that many people working either directly or indirectly with database software are uninformed about just how expensive it is - particularly in comparison to … Continue reading The Real Cost of Oracle RAC
The Real Cost of Enterprise Database Software
Storage for DBAs: The strange thing about enterprise databases is that the people who design, manage and support them are often disassociated from the people who pay the bills. In fact, that's not unusual in enterprise IT, particularly in larger organisations where purchasing departments are often at opposite ends of the org chart to operations … Continue reading The Real Cost of Enterprise Database Software
Storage Myths: Put Oracle Redo on SSD
Storage for DBAs: "My database is slow"... "Well then why not put your redo logs on SSDs?" Gaaaah. I still hear people having this discussion and it drives me mad. "Nobody got fired for putting Oracle redo on ...<flash vendor>". Yeah right, but does that mean it was worth the investment? I'm bored of this … Continue reading Storage Myths: Put Oracle Redo on SSD
Storage Myths: IOPS Matter
Storage for DBAs: Having now spent over a year in the storage industry, I've decided it's time to call out an industry-wide obsession that I previously wasn't aware of: everyone in storage is obsessed with IOPS (the performance metric I/O Operations Per Second). Take a minute to perform a web search for "flash iops" and … Continue reading Storage Myths: IOPS Matter
The Most Important Thing You Need To Know About Flash
NAND flash development is driven by the consumer market – not the enterprise. The question to ask any flash vendor isn't "how fast?" but "where's your innovation?"
Does My Database Need Flash?
Not every database benefits from flash storage – knowing when it matters requires understanding how much I/O your workload generates, how random it is and how much latency is already costing you.
Understanding I/O: Random vs Sequential
Disk I/O forces a choice between random and sequential access – and that choice defines whether latency compounds or disappears. Flash makes the distinction irrelevant.
The Fundamental Characteristics of Storage
Latency, IOPS and bandwidth are the three properties that define any storage system – understanding how they relate to each other is the first step to knowing what your database actually needs.
Performance: It’s All About Balance…
Database performance problems are rarely solved by faster CPUs alone – the real issue is imbalance between resources, and disk latency is the silent bottleneck that flash storage changes.
flashdba 