By wendress-Oracle on Jun 19, 2015
In my previous post, Star Schema Performance Challenge – Part 1, I outlined a challenge to support 100 concurrent users querying a 9 dimensional, 500 million row star schema using a Sun X4-4 (with 60 cores, 1 TB DRAM and commodity storage). The users, of course, expect great query performance. The challenging part of this is 100 active users on a 60 core machine. With far fewer or less active users this might not be so challenging, but 100 users on this size machine is a different story.
In this post I’ll talk more about the workload and share some baseline results.[Read More]