Storage for DBAs: Do you want to sell your house? Or your car? Let's go with the car - just indulge me on this one. You have a car, which you weren't especially planning on selling, but I'm making you an offer you can't refuse. I'm offering you one million dollars so how can you … Continue reading Playing The Data Reduction Lottery
Tag: Storage Myths
Storage Myths: Storage Compression Has No Downside
Storage for DBAs: My last post in this blog series was aimed at dispelling the myth that dedupe is a suitable storage technology for databases. To my surprise it became the most popular article I've ever published (based on reads per day). Less surprisingly though, it lead to quite a backlash from some of the … Continue reading Storage Myths: Storage Compression Has No Downside
Storage Myths: Dedupe for Databases
Storage for DBAs: Data deduplication - or "dedupe" - is a technology which falls under the umbrella of data reduction, i.e. reducing the amount of capacity required to store data. In very simple terms it involves looking for repeating patterns and replacing them with a marker: as long as the marker requires less space than … Continue reading Storage Myths: Dedupe for Databases
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