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…
Maximum Efficiency Architecture: Current State
In the previous post, I announced Maximum Efficiency Architecture – a methodology for achieving optimal cost-efficiency for (Oracle) databases whilst also maintaining (or even improving) business service levels. In this post we will review the current state of typical database…
Reducing Oracle TCO: Maximum Efficiency Architecture
Last year, Dell EMC sponsored the 2020 IOUG Database Priorities Survey. One of the questions was, “What leading factors do you weigh when selecting infrastructure for your Oracle environment?” The number 1 factor respondents mentioned, was “Cost”. This confirms my…