SAP HANA Dynamic Tiering is a tool used to move data between in-memory (“hot”) and disk storage (“warm”) in a HANA landscape. Information that needs to be queried frequently is kept as hot data, while information that is rarely accessed is stored in extended tables as warm data. This decreases the cost and memory footprint of the SAP HANA cloud without sacrificing performance.
Expert Insight: Matt Lonstine, Technical Relationship Manager
What is HANA Dynamic Tiering used for?
SAP HANA Dynamic Tiering is mainly used in reporting applications to maximize the costs benefits of SAP HANA by moving older data out of memory. For example, a company with 15 years of sales data will usually only need to report on the last 6 months or so on a daily basis, so keeping any more in memory is wasteful. HANA Dynamic Tiering allows the sales team to retain real-time access to recent data, and move the older data to a separate instance of HANA on disk, where it is still can be accessed fairly quickly when they need it.
How does HANA Dynamic Tiering manage data?
A script is used to automatically migrate hot data to warm data when it exceeds the timeframe, and is run daily in the job scheduler. Typical timeframes are 6 months to a year. For certain use cases, such as data warehousing, the Data Lifecycle Manager is used.
Should I store all old data in HANA Dynamic Tiering?
Not necessarily. HANA Dynamic Tiering keeps data in SAP HANA, where it is can be created, read, updated or deleted just like in-memory data (albeit not quite as quickly). If you have a lot of old data that doesn’t need to be modified, cold data — called “near-line storage” in SAP — may be a better option.
Near-line storage data is kept in a separate server outside of HANA. It is encoded in a read-only, compressed form and optimized for long-term storage. This allows it to be stored inexpensively with low SLAs, and backed up infrequently. In addition to archiving old data, this tool is useful for HANA big data. Data sets can be archived for future projects, then moved into HANA standard or extended tables when you’re ready to use them. It’s also useful for data mart scenarios where information is being pulled from multiple sources and queried in HANA.
How can a managed services provider support HANA Dynamic Tiering?
Managing system resources in SAP is a balancing act. The key is to maximize productivity and performance while containing complexity and cost. To get the balance right, you need to understand the way your system is structured, the demands placed on its hardware and software and the way it supports your business processes.
Symmetry has the cloud and IT infrastructure experience to optimize your landscape. Whether you’re looking for someone to design, migrate and configure your SAP system or just need occasional support to backup onsite IT, we’re here to help.
Contact us to learn what Symmetry can do for your HANA landscape.