In a previous post, I introduced CRIPS – a measurement of the processing power of a CPU (core) based on SPEC CPU Integer Rate. The higher the CRIPS rating, the better a processor is in terms of performance per physical…
PyPGIO – An I/O generator for PostgreSQL
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…
MEA: Defining Capacity and Performance Metrics
In the previous post, we discussed the current state of many existing Oracle environments. Now we need a method to accurately measure or define the workload characteristics of a given database platform. In our customer engagements we frequently ask details…
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…
Six alternatives to replace licensed Oracle database options
More and more I hear companies looking into replacing expensive licensed database options with more cost-effective alternatives, for various reasons: simple cost reduction, or avoiding lock-in, or because of other strategic considerations. In order to kickstart the creative thinking, here…