In a prior blog we provided some tips on Managing HANA memory. In this article we will further explore the improvement with ESS (Embedded Statistics Service) available on HANA from SPS 7 revision 74 or higher. As a quick recap, memory consumption by the hdbstatisticsserver can be heavily impacted by the volume and frequency of various statistics collected by the HANA statistics engine, mainly the columnar tables in _SYS_STATISTICS schema. These tables provide stats for monitoring by tools such as the HANA Studio, SAP DBA Cockpit and Solution Manager, as well as external SAP management tools like IT-Conductor and HANA Management Pack for SCOM.
HanaHaus for Startups and Innovation
When you're working in an early-stage tech startup, it can feel like you're stuck inside a box trying to get a million things done on a tiny or non-existing budget, that typically translates to endless hours of work which sometimes can turn your passion into a grind. Well, every now and then one needs to step out for a different kind of grind, the coffee variety. What better way to do it than to mix the café society with the startup and innovation, and that's what SAP opened this week at HanaHaus in Palo Alto , California, the epicenter of innovative minds and startup culture in Silicon Valley.
We've had the opportunity to work with HANA both as a Startup porting our application to HANA as well as with our SAP customers running HANA in production scale BW or ECC environments. In the R&D environment we have limited hardware capacity and thus resources, especially memory is always a constraint, so we learnt ways to monitor, and automate to optimize our performance and use of the system. In the customers' production environment, we have seen original architecture plans double in nodes and/or memory before they even got to performance testing phase.
SAP has a pretty catchy new spin since 2014 with the slogan “Run Simple”, well maybe for the business and end-users, but as far as the Basis team is concerned, managing the sprawling SAP landscapes and lifecycle is anything but simple. In my experience, the move to newer SAP technologies (such as HANA, Sybase, BOBJ, virtualization, cloud, etc.) has proliferated more requirements and demands on the Basis, Infrastructure and IT Operations teams. One example of this includes new deployments of SAP HANA which may scale out a Production environment up to 16 nodes. That is anything but simple. But I’ll play along that if you consolidated all your SAP environments into this huge HANA cluster, then it may look simple like in the old days when there was only R/3 and everything ran on it. However, if you’re going to put all your eggs into one basket, then you’ll need to protect it with a Business Continuity strategy for HA and DR which would no doubt be very complex.