Recently I’ve been heavily involved with Performance Testing and Tuning a new OBIA system for a client. I thought I’d share some of the interesting reading I’ve come across. I hope to write a more detailed post on the topic in the near future but in the meantime…
Lots of good material available from Jeff McQuigg here including recent posts on keeping things simple and time series tuning.
A good presentation by Robin Moffatt from a past Rittman Mead BI Forum.
More from Robin, this time on the myth surrounding query logging.
A useful presentation from Peak Indicators.
Some interesting reading on tuning your JVM garbage colletion. There really is a lot of bad advice on the web concerning this topic and it seems a few forum posters are keen to post their ‘must use’ JVM settings. I will try and find time to explore this topic in detail in a future posting.
Finally, a really useful Oracle White Paper “OBIEE 11g Infrastructure Performance Tuning Guide” is available on My Oracle Support – see document ID 1333049.1 once you’ve logged in.