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…
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…
What was the name of that SQL script again? SQLWrap to the rescue!
If you are a frequent user of Oracle SQL*Plus, you probably also know about a tool called rlwrap. Bare SQL*Plus does not offer command history, arrow-key editing or any type of word completion so it feels like you’re thrown back…
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 Dedupe Analyzer – Part 1 – Hands on
As announced in my last blogpost, qdda is a tool that analyzes potential storage savings by scanning data and giving a deduplication, compression and thin provisioning estimate. The results are an indication whether a modern All-Flash Array (AFA) like Dell…