If you need to generate lots of I/O on an Oracle database, the de-facto I/O generator tool is SLOB (Silly Little Oracle Benchmark). In the recent years however, PostgreSQL has gotten a lot of traction and many customers are starting…
Announcing qdda 2.0
It’s almost a year since I blogged about qdda (the Quick & Dirty Dedupe Analyzer). qdda is a tool that lets you scan any Linux disk or file (or multiple disks) and predicts potential thin, dedupe and compression savings if…
Baking a cake: trading CPU for IO?
Sometimes I hear people claim that by using faster storage, you can save on database licenses. True or false? The idea is that many database servers are suffering from IO wait – which actually means that the processors are waiting…
Oracle ASM vs ZFS on XtremIO
Background In my previous post on ZFS I showed how ZFS causes fragmentation for Oracle database files. At the end I promised (sort of) to also come back on topic around how this affects database performance. In the meantime I…
Getting the Best Oracle performance on XtremIO
(Blog repost from Virtual Storage Zone – Thanks to @cincystorage) UPDATE: I’ll say it again because there seems to be some confusion: THIS IS A REPOST! Original content is from the Virtual Storage Zone blog (not mine). Just reposted here…