Skip to Content
Technical Articles
Author's profile photo Feng Liu

Series Data in SAP HANA

This blog is under construction

Assigned Tags

      5 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Michael Schliebner
      Michael Schliebner

      Good One!

      Be sure to not only watch

      temperature

      but also partition sizes

       

      When you try this at home

      Author's profile photo Feng Liu
      Feng Liu
      Blog Post Author

      Hi Michael,

      Thank you for your advice and usually time series are VLTB and partitioning can improve the performance and data management. SAP HANA has table size limitation (2 billion) as well. Do you have any resource to share regarding to this topic?

      Thanks,

      Daniel

      Author's profile photo Michael Schliebner
      Michael Schliebner

      Dear Daniel,

       

      Operating DBs you might find, that space is not unlimited and/or that somehow performance is getting funny.

      Its time for housekeeping aka reorganize, scavenging, cleanup ...

       

      Good news: Its OpenSource

      Better news: It runs on python

      https://github.com/chriselswede/hanacleaner

       

      The deep dive from dear Denys van Kempen

      https://blogs.sap.com/2018/03/15/c_hanatec_13-topics-database-administration-tools-and-tasks-by-the-sap-hana-academy/

      HANAcleaner by Dennis Padia

      https://blogs.sap.com/2018/10/29/hana-housekeeping-using-hanacleaner/

      Als BW needs some houskeeping by prabhith prabhakaran

      https://blogs.sap.com/2013/09/20/house-keeping-performance-tuning-activities-in-sap-bw-systems-part-1/

       

      Cheers mitch

      Author's profile photo Feng Liu
      Feng Liu
      Blog Post Author

      Thanks

      Author's profile photo Venkat BW
      Venkat BW

      Very knowledgeable  concept and i would like to adaptive more thing like this from you....