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…
The Quick and Dirty Deduplication Analyzer
The best thing about being me… There are so many “me”s. — Agent Smith, The Matrix Reloaded One of our customers reported less than optimal space savings on XtremIO running Oracle. In order to test various scenarios with Oracle I…