If you haven’t read the previous parts of this series yet, here are the links: [ Part 1 | Part 2 ].

A Refresher

In the first part of this series I said that RAM access is the slow component of a modern in-memory database engine and for performance you’d want to reduce RAM access as much as possible. Reduced memory traffic thanks to the new columnar data formats is the most important enabler for the awesome In-Memory processing performance and SIMD is just icing on the cake.

If you haven’t read the previous parts of this series yet, here are the links: [ Part 1 | Part 2 ].

A Refresher

In the first part of this series I said that RAM access is the slow component of a modern in-memory database engine and for performance you’d want to reduce RAM access as much as possible. Reduced memory traffic thanks to the new columnar data formats is the most important enabler for the awesome In-Memory processing performance and SIMD is just icing on the cake.

This is the text of the “whitepaper” I submitted to DOAG for my presentation on “Core Strategies for Troubleshooting”.

Introduction

In an ideal world, everyone who had to handle performance problems would have access to ASH and the AWR through a graphic interface – but even with these tools you still have to pick the right approach, recognise the correct targets, and acquire information at the boundary that tells you why you have a performance problem and the ways in which you should be addressing it.

Squarespace is a drag-and-drop website-builder for small organizations and creative professionals wanting a polished and functional web presence. Squarespace sites are quick to create and then “just work” without any worries over ongoing maintenance or version updates.

The Use Case

The web is replete with stale websites that are all but abandoned after the initial build. The common scenario I see is of a site developed in a rush of enthusiasm by someone having just enough technical knowledge to stand up a web presence on a platform like WordPress or GetSimple. Perhaps a volunteer burns the midnight oil for a few weeks. Such effort cannot be sustained. Updates bottleneck on the one person who can make them. In short order, the site goes stale.