SAP MaxDB

How to know “all these things”

There is one predominant reason for why databases and database technology get a spot in the conversation of “the business”: performance.Understanding system performance and coming up with ideas for improving it typically requires a form of end-to-end understanding with different levels of detail insight on how a query from a client application is processed by How to know “all these things”

Small changes with big effects

For many BW performance relevant DB-features, it’s really all about the details of usage and implementation when it’s about the effect of those features. The following are two examples of rather small things that went wrong which had a big impact on the system performance. Two examples for BW on MaxDB The first two examples Small changes with big effects

MaxDB Event Dispatcher Intro

Infrastructure software like RDBMS often tends to become feature-rich in many directions. MaxDB is no exception to this, so by reading the documentation there’s a pretty good chance to dig out some features that are rarely seen or used. One example for this is the MaxDB database event dispatcher. It has been around for quite MaxDB Event Dispatcher Intro

MaxDB – On locking mechanisms and how we get to know our MaxDB a bit better each day… Part I

One of the most boring topics within the area of DBMS surely is locking. It’s also one of the topics that most DB users try to avoid as much as possible. Still, it’s utmost important to correctly understand how locking works in the database of choice to be able to work successfully with it and without bad MaxDB – On locking mechanisms and how we get to know our MaxDB a bit better each day… Part I

Questions to SAP-Support (MaxDB): “Data is gone after reboot – where the heck is it?”

From time to time I start to believe that there are certain problems that would not come up anymore, once the topic is documented well enough. My colleagues from the development know that too well as I’m asking for documentation and notes all the time for everything. However, the written documentation does help nothing if Questions to SAP-Support (MaxDB): “Data is gone after reboot – where the heck is it?”