Update on Rollout of SQL Server 2008 Row Level Compression in Microsoft’s SAP ERP system

Well meanwhile the Roll-Out is as good as finished. The only tables remaining are some tables with BLOB fields which can’t be done ’online’. Those tables will be done in our quarterly downtime where we need to apply a whole stack of new SAP Support Packages, exchange to more recent SAP executables, etc. But all… Read more

Analyzing a HANGMAN log file, part 1

The HANGMAN log file, created with the HANGMAN tool described in SAP note 948633 gives us a better understanding about the root cause of a system hang or hiccup of an SAP system. The log file consists of several sections: SAP process list per instance, Windows process list per server, SQL process list, database locks… Read more