{"id":1233,"date":"2024-05-17T18:20:32","date_gmt":"2024-05-17T15:20:32","guid":{"rendered":"https:\/\/techltx.com\/de\/?page_id=1233"},"modified":"2024-06-10T20:03:55","modified_gmt":"2024-06-10T17:03:55","slug":"hana-upkeep-and-maintenance","status":"publish","type":"page","link":"https:\/\/techltx.com\/en\/sap\/sap-hana\/hana-upkeep-and-maintenance\/","title":{"rendered":"HANA Upkeep and Maintenance"},"content":{"rendered":"\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-28f84493 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:66.66%\">\n<p>SAP HANA is a powerful in-memory database that requires continuous care and maintenance to ensure optimal performance and stability. In this article, SAP HANA specialists will learn how to effectively use HANA management tools to monitor and administer their databases. The SAP HANA maintenance strategy is based on incremental, non-disruptive innovation updates. New features are introduced once a year, each time a new SAP HANA SPS is released. This usually happens at the beginning of April.<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\" style=\"flex-basis:33.33%\">\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/techltx.com\/wp-content\/uploads\/2024\/05\/SAP-HANA-Certified-Consultant.png\"><img loading=\"lazy\" decoding=\"async\" width=\"323\" height=\"322\" src=\"https:\/\/techltx.com\/wp-content\/uploads\/2024\/05\/SAP-HANA-Certified-Consultant.png\" alt=\"SAP-HANA-Certified-Technology-Consultant SAP HANA 2.0 SPS03\" class=\"wp-image-1116\" style=\"width:200px\" srcset=\"https:\/\/techltx.com\/wp-content\/uploads\/2024\/05\/SAP-HANA-Certified-Consultant.png 323w, https:\/\/techltx.com\/wp-content\/uploads\/2024\/05\/SAP-HANA-Certified-Consultant-300x300.png 300w, https:\/\/techltx.com\/wp-content\/uploads\/2024\/05\/SAP-HANA-Certified-Consultant-150x150.png 150w\" sizes=\"auto, (max-width: 323px) 100vw, 323px\" \/><\/a><\/figure>\n<\/div>\n<\/div>\n\n\n\n<p class=\"has-text-align-center\"><strong>We are happy to support you in the following areas:<\/strong><\/p>\n\n\n\n<p><strong>Hardware Checks<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><tbody><tr><td><strong>SAP-certified hardware for SAP HANA<\/strong><\/td><td>The certification confirms that a product has successfully passed the SAP certification procedures. However, it is the responsibility of the vendor to ensure that the product functions correctly. At the time of purchase, the hardware must have a valid SAP HANA hardware certification. This certification ensures that the hardware fulfills the required performance characteristics for the operation of SAP HANA.<\/td><\/tr><tr><td><strong>Hardware Configuration Check Tool (HWCCT)<\/strong><\/td><td>The HWCCT provides a variety of tests and reports to ensure that the hardware meets the minimum performance requirements for SAP HANA operation. SAP strongly recommends using HWCCT as part of a HANA go-live check. The tool checks, among other things:<br>Hardware configuration validation: checks memory and processor configurations.<br>Operating system settings: Validates Linux kernel settings and supported Linux distributions.<br>Data throughput and latency times: Measures data transfer rates and latency between the SAP HANA nodes and external storage systems.<br>Network bandwidth: Checks the available bandwidth between the nodes of a multi-node system.<br>LPAR settings on IBM Power servers: Checks the settings for logical partitions.<br>Important resources:<br>SAP HANA Hardware Directory: <a href=\"https:\/\/www.sap.com\/dmc\/exp\/2014-09-02-hana-hardware\/enEN\/index.html\">SAP HANA Hardware Directory<\/a><br>HWCCT Patch Note: <a href=\"http:\/\/service.sap.com\/sap\/support\/notes\/2161344\">SAP Note 2161344<\/a><br>HANA Hardware and Cloud Measurement Tools: <a href=\"https:\/\/launchpad.support.sap.com\/#\/notes\/2493172\">SAP Note 2493172<\/a><\/td><\/tr><tr><td><strong>HANA Sizing Report<\/strong><\/td><td>Accurate sizing is crucial to ensure that the SAP HANA database has sufficient memory and resources to process the workloads efficiently. Sizing is done either via the SAP HANA Quick Sizer or through specific sizing reports during migrations of SAP NetWeaver systems.<br>CPU and memory sizing<br>The sizing of large or complex systems should be carried out by an SAP sizing expert. Various tools are available for this purpose, which provide separate results for CPU and RAM. Customers share these results with their hardware partner to determine the optimal hardware components.<\/td><\/tr><tr><td><strong>Virtualization<\/strong><\/td><td>SSAP HANA supports operation in virtualized environments, including VMware and other hypervisor technologies. With Multi-Tenant Database Containers (MDC), multiple workloads can be run separately within a single HANA installation. MCOS and MCOD deployment options are also available to realize similar multi-tenant environments.<br>Multi-Tenant Database Containers: <a href=\"https:\/\/launchpad.support.sap.com\/#\/notes\/2096000\">SAP Note 2096000<\/a><br>MCOS und MCOD: <a href=\"https:\/\/launchpad.support.sap.com\/#\/notes\/1681092\">SAP Note 1681092<\/a><\/td><\/tr><tr><td><strong>Network<\/strong><\/td><td>In SAP HANA scale-out environments, the individual nodes and services must communicate with each other for different purposes, which is also necessary for single-node systems. The default configurations of Linux and HANA may not be optimal for internal HANA communication, so customization of the relevant parameters is recommended to ensure smooth and error-free communication. Especially for large scale-out systems or multi-database container installations with many client databases, the network settings of Linux and SAP HANA should be optimized to achieve better performance and stability.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>Operation Software Checks<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><tbody><tr><td><h4 style=\"border: 0px solid rgb(227, 227, 227); box-sizing: border-box; --tw-border-spacing-x: 0; --tw-border-spacing-y: 0; --tw-translate-x: 0; --tw-translate-y: 0; --tw-rotate: 0; --tw-skew-x: 0; --tw-skew-y: 0; --tw-scale-x: 1; --tw-scale-y: 1; --tw-pan-x: ; --tw-pan-y: ; --tw-pinch-zoom: ; --tw-scroll-snap-strictness: proximity; --tw-gradient-from-position: ; --tw-gradient-via-position: ; --tw-gradient-to-position: ; --tw-ordinal: ; --tw-slashed-zero: ; --tw-numeric-figure: ; --tw-numeric-spacing: ; --tw-numeric-fraction: ; --tw-ring-inset: ; --tw-ring-offset-width: 0px; --tw-ring-offset-color: #fff; --tw-ring-color: rgba(69,89,164,.5); --tw-ring-offset-shadow: 0 0 transparent; --tw-ring-shadow: 0 0 transparent; --tw-shadow: 0 0 transparent; --tw-shadow-colored: 0 0 transparent; --tw-blur: ; --tw-brightness: ; --tw-contrast: ; --tw-grayscale: ; --tw-hue-rotate: ; --tw-invert: ; --tw-saturate: ; --tw-sepia: ; --tw-drop-shadow: ; --tw-backdrop-blur: ; --tw-backdrop-brightness: ; --tw-backdrop-contrast: ; --tw-backdrop-grayscale: ; --tw-backdrop-hue-rotate: ; --tw-backdrop-invert: ; --tw-backdrop-opacity: ; --tw-backdrop-saturate: ; --tw-backdrop-sepia: ; --tw-contain-size: ; --tw-contain-layout: ; --tw-contain-paint: ; --tw-contain-style: ; font-size: 16px; margin: 1rem 0px 0.5rem; color: rgb(13, 13, 13); line-height: 1.5; font-family: S\u00f6hne, ui-sans-serif, system-ui, -apple-system, \" segoe=\"\" ui\",=\"\" roboto,=\"\" ubuntu,=\"\" cantarell,=\"\" \"noto=\"\" sans\",=\"\" sans-serif,=\"\" \"helvetica=\"\" neue\",=\"\" arial,=\"\" \"apple=\"\" color=\"\" emoji\",=\"\" \"segoe=\"\" ui=\"\" symbol\",=\"\" emoji\";\"=\"\">SLES <\/h4><\/td><td>Wenn Sie SAP HANA auf SLES 15 oder SLES f\u00fcr SAP Applications 15 betreiben, m\u00f6chten Sie optimale Linux-Einstellungen konfigurieren. SAP HANA umfasst sowohl die Versionen 1.0 als auch 2.0 und muss gem\u00e4\u00df SAP Note 1944799 installiert und konfiguriert werden. Die in dieser SAP Note aufgef\u00fchrten Empfehlungen gelten f\u00fcr alle von SAP HANA unterst\u00fctzten Service Packs von SLES 15, und es wird empfohlen, stets die neuesten Kernel-Updates und Patches von SUSE zu verwenden, sofern keine spezifischen Gr\u00fcnde dagegen sprechen.<\/td><\/tr><tr><td><strong>RHEL<\/strong><\/td><td>&#8220;RHEL&#8221; als Synonym f\u00fcr &#8220;Red Hat Enterprise Linux for SAP HANA&#8221; und &#8220;Red Hat Enterprise Linux for SAP Solutions&#8221; verwendet, w\u00e4hrend &#8220;SLES&#8221; f\u00fcr &#8220;SUSE Linux Enterprise Server&#8221; und &#8220;SUSE Linux Enterprise Server for SAP Applications&#8221; steht. Die angeh\u00e4ngte PDF-Datei listet die unterst\u00fctzten Kombinationen von RHEL-Minor-Releases und SLES-Support-Paketen mit den verschiedenen SAP HANA-Versionen auf, wobei nicht aufgef\u00fchrte Kombinationen als nicht unterst\u00fctzt gelten. Es wird empfohlen, die SAP Product Availability Matrix zu konsultieren, da andere SAP-Softwarel\u00f6sungen m\u00f6glicherweise strengere Anforderungen an die Betriebssystemversionen haben und zus\u00e4tzliche Einschr\u00e4nkungen definieren k\u00f6nnen.<\/td><\/tr><tr><td><strong>OS Lifecycle<\/strong><\/td><td>SUSE Linux Enterprise Server: <a href=\"https:\/\/www.suse.com\/lifecycle\">SUSE Lifecycle<\/a><br>Red Hat Enterprise Linux: <a href=\"https:\/\/access.redhat.com\/support\/policy\/updates\/errata\">Red Hat Lifecycle<\/a><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>HANA Checks<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table is-style-stripes\"><table><tbody><tr><td><strong>Early Watch Alert<\/strong><\/td><td>The Early Watch Alert offers comprehensive monitoring of the HANA database and provides early indications of potential problems and optimization potential.<\/td><\/tr><tr><td><strong>Update Path<\/strong><\/td><td>SAP HANA release strategy. When updating SAP HANA, the compatibility and known problems of the target revision must be checked. Specific SAP Notes are available for this purpose, which show the supported update paths and possible incompatibilities. <br>SAP HANA HotNews: <a href=\"https:\/\/launchpad.support.sap.com\/#\/notes\/2688515\">SAP Note 2688515<\/a><\/td><\/tr><tr><td><strong>Consistency check<\/strong><\/td><td>A consistency check should be carried out before and after an upgrade to ensure that all data and configurations are correct and complete.<\/td><\/tr><tr><td><strong>Backup and defragmentation<\/strong><\/td><td>Regular backups and defragmentation are necessary to ensure data integrity and optimal memory utilization. It is recommended to back up both the database and the configurations before an upgrade.<\/td><\/tr><tr><td><strong>Host Agent<\/strong><\/td><td>The SAP host agent is an agent that can perform multiple life cycle management tasks such as operating system monitoring, database monitoring and system instance control and provisioning.<\/td><\/tr><tr><td><strong>SAP KERNEL<\/strong><\/td><td>SAPEXE, which is independent of the database (disp+work, R3trans, tp, etc.)<br>SAPEXEDB, which is dependent on the database (libdbsl, R3load, R3ta, etc.)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><a href=\"https:\/\/calendly.com\/baltx\/scheduleanexpert\"><img loading=\"lazy\" decoding=\"async\" width=\"355\" height=\"433\" src=\"https:\/\/techltx.com\/wp-content\/uploads\/2024\/04\/schedule-an-expert.png\" alt=\"\" class=\"wp-image-1092\" srcset=\"https:\/\/techltx.com\/wp-content\/uploads\/2024\/04\/schedule-an-expert.png 355w, https:\/\/techltx.com\/wp-content\/uploads\/2024\/04\/schedule-an-expert-246x300.png 246w\" sizes=\"auto, (max-width: 355px) 100vw, 355px\" \/><\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>SAP HANA is a powerful in-memory database that requires continuous care and maintenance to ensure optimal performance and stability. In this article, SAP HANA specialists will learn how to effectively use HANA management tools to monitor and administer their databases. The SAP HANA maintenance strategy is based on incremental, non-disruptive innovation updates. New features are [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"parent":43,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"content-type":"","_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"class_list":["post-1233","page","type-page","status-publish","hentry"],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"BALTX","author_link":"https:\/\/techltx.com\/en\/author\/baltx-com\/"},"uagb_comment_info":0,"uagb_excerpt":"SAP HANA is a powerful in-memory database that requires continuous care and maintenance to ensure optimal performance and stability. In this article, SAP HANA specialists will learn how to effectively use HANA management tools to monitor and administer their databases. The SAP HANA maintenance strategy is based on incremental, non-disruptive innovation updates. New features are&hellip;","_links":{"self":[{"href":"https:\/\/techltx.com\/en\/wp-json\/wp\/v2\/pages\/1233","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/techltx.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/techltx.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/techltx.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/techltx.com\/en\/wp-json\/wp\/v2\/comments?post=1233"}],"version-history":[{"count":13,"href":"https:\/\/techltx.com\/en\/wp-json\/wp\/v2\/pages\/1233\/revisions"}],"predecessor-version":[{"id":1631,"href":"https:\/\/techltx.com\/en\/wp-json\/wp\/v2\/pages\/1233\/revisions\/1631"}],"up":[{"embeddable":true,"href":"https:\/\/techltx.com\/en\/wp-json\/wp\/v2\/pages\/43"}],"wp:attachment":[{"href":"https:\/\/techltx.com\/en\/wp-json\/wp\/v2\/media?parent=1233"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}