SAP HANA Sizing and TDI Overview

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

In a virtualized environment, which SAP Note addresses workload-based sizing specifically for virtualized environments?

SAP Note 2652670

SAP Note 2779240 (correct)

SAP Note 2408419

SAP Note 1788665

What is the primary purpose of the Quick Sizer tool in SAP HANA memory sizing?

Calculate the ideal RAM allocation for dynamic memory objects.

Estimate the required SAP HANA memory size based on a set of parameters. (correct)

Determine the exact amount of memory required for static data.

Analyze the compression factor applied to the data to determine memory size.

Which of the following SAP Notes specifically deals with SAP HANA memory sizing for SAP BW/4HANA?

SAP Note 2610534

SAP Note 2296290

SAP Note 2363248

All of the above (correct)

What is the recommended practice when initially sizing SAP HANA memory?

Utilize both the Quick Sizer and SAP Notes for validation. (D) Signup and view all the answers

Which SAP Note provides insights into how to configure /etc/hosts files for HANA Scale-out configurations?

SAP Note 1886462 (B) Signup and view all the answers

Why is it recommended to test the ZNEWHDB_SIZE report in a consolidation system before loading?

To minimize the risk of performance issues during the sizing process. (D) Signup and view all the answers

When sizing the persistent storage for SAP HANA, what is the key difference between the data volume and the log volume?

The data volume stores changed data, while the log volume stores transaction logs. (D) Signup and view all the answers

Which SAP Note provides recommendations and guidelines for sizing SAP HANA storage requirements?

SAP Note 1900823 (C) Signup and view all the answers

The sizing report `/SDF/HDB_SIZING` is a crucial tool for which SAP HANA scenario?

Suite on SAP HANA (A) Signup and view all the answers

What is the primary purpose of the `ZNEWHDB_SIZE` report?

Provide a detailed assessment of SAP HANA memory needs, including static, dynamic, and storage sizing. (A) Signup and view all the answers

In SAP HANA memory sizing, what does the term 'dynamic memory requirements' specifically refer to?

The additional memory needed for objects created dynamically during data loading or query execution. (B) Signup and view all the answers

What is the rationale behind recommending to reserve as much memory for dynamic objects as for static objects?

To avoid potential memory shortages during peak workload or data loading. (C) Signup and view all the answers

Which of these SAP Notes specifically addresses the topic of configuring SAP HANA in multi-node environments?

All of the above (D) Signup and view all the answers

Why is it essential to perform an SAP HANA Go-Live Check before going productive?

To confirm that the performance of the system meets the expected requirements. (A) Signup and view all the answers

How does SAP Active Global Support contribute to the preparation for an SAP HANA Go-Live?

They conduct a pre-production assessment to identify potential issues and ensure a smooth Go-Live. (D) Signup and view all the answers

What is the primary purpose of SAP HANA's persistent storage?

To ensure the long-term availability of data in case of memory failures. (A) Signup and view all the answers

What is the primary factor that determines the required memory for SAP HANA sizing?

The size of the source database (B) Signup and view all the answers

Which approach is recommended for customers migrating existing SAP NetWeaver based systems to SAP HANA?

Execute a sizing report specifically designed for SAP HANA (C) Signup and view all the answers

In which scenario is SAP expert sizing most likely needed?

When integrating a single ERP system from multiple sources (C) Signup and view all the answers

Which method can be used for customers who are new to SAP applications and want to size their SAP HANA systems?

Quick Sizer for SAP HANA (C) Signup and view all the answers

Which aspect does SAP HANA compression primarily depend on?

The used scenario for data (B) Signup and view all the answers

What should be done if a system is large or complex regarding SAP HANA sizing?

Consult with an SAP sizing expert (D) Signup and view all the answers

Which deployment option allows for a flexible choice of certified hardware for SAP HANA?

Both options align with certified hardware (B) Signup and view all the answers

When should customers consider sizing methods outlined in SAP Note 1514966?

For non-SAP NetWeaver based systems (D) Signup and view all the answers

What is the recommended additional free space percentage when calculating the data volume size for a SAP HANA system?

20% (D) Signup and view all the answers

What is the effect of not allowing the redo log to be overwritten before a savepoint is created?

Potential inability to restart the database (C) Signup and view all the answers

For a SAP HANA system with a total memory requirement (RAM) of 256 GB, what is the minimum recommended log volume size?

128 GB (C) Signup and view all the answers

During which operation is data written from memory to the data volume?

Savepoint creation (C) Signup and view all the answers

For a single-node SAP HANA system with 2 TB of database size, what is the minimum recommended installation size?

1 TB (D) Signup and view all the answers

What primarily influences the amount of space needed in the log volume?

The number of data changes between savepoints (A) Signup and view all the answers

What is the standard default frequency for creating savepoints in a SAP HANA system?

Every 5 minutes (D) Signup and view all the answers

When migrating a non-SAP HANA database to SAP HANA, what might temporarily increase disk space requirements?

Interim data storage needs (B) Signup and view all the answers

What is the effect of experiencing delays in writing a savepoint during high workloads?

Increased number of redo log segments (B) Signup and view all the answers

What is the main advantage of configuring /hana/shared/ as a shared file system?

Easier conversion from single-host to multi-host systems (D) Signup and view all the answers

What should be considered when determining the size of the log volume for a SAP HANA system with an RAM requirement of more than 512 GB?

Workload processing variability (A) Signup and view all the answers

What is the primary reason for needing extra space in the log volume during a backup?

To prevent overwriting existing redo logs (C) Signup and view all the answers

For scale-out SAP HANA systems, how is the recommended disk space for /hana/shared/ determined?

In relation to the number of worker nodes and their RAM (A) Signup and view all the answers

What is the total size of the installation for a 5 system, 512 GB per node SAP HANA configuration?

1 TB (D) Signup and view all the answers

How many TB of backup storage is required if the backup policy requires complete data backups daily for one week and the size of the data area is 2 TB?

7 TB (A) Signup and view all the answers

What factor can most significantly affect the overall data throughput of backup storage during recovery processes?

Number of parallel backup processes (A) Signup and view all the answers

In the SAP HANA CPU sizing model, what is used to calculate the required CPU resources?

300 SAPS per active user (B) Signup and view all the answers

When using the Quick Sizer for SAP HANA, which factor is NOT one of the categories calculated?

User Satisfaction (B) Signup and view all the answers

What is the main purpose of having backup storage for log backups?

To enable point-in-time recovery (A) Signup and view all the answers

For a configuration with 9 systems, 1 TB per node, what is the calculated size installation?

3 TB (D) Signup and view all the answers

Which backup strategy involves performing full backups only during weekends?

Weekend Full Backups, Workdays Incremental Backups (C) Signup and view all the answers

What should the minimum network connectivity be for internal and storage zones when deploying SAP HANA?

10 Gbit/s (D) Signup and view all the answers

What is the size reserved for binary exports intended for root cause analysis typically based on?

Two times the largest database table size (A) Signup and view all the answers

How does an active user affect CPU utilization estimates in SAP HANA sizing?

They are the basis for overestimation of resource needs (D) Signup and view all the answers

What should be considered in conjunction with the initial sizing recommendation made by the Quick Sizer?

Data compression rates (B) Signup and view all the answers

What does a node in the standby role contribute to the overall system installation size?

No additional disk space required (C) Signup and view all the answers

What is the cumulative backup size calculated if 28 backups of 0.25 TB each and 4 backups of 2.5 TB are kept?

77 TB (D) Signup and view all the answers

What is mandatory for SAP HANA 2.0 computing nodes regarding the CPU?

It must have at least an Intel Haswell CPU or later. (B) Signup and view all the answers

Which SAP Note would you consult for sizing SAP HANA in non-NetWeaver scenarios?

SAP Note 1514966 (B) Signup and view all the answers

For an SAP HANA appliance, which of the following must NOT be installed on the database server?

Any application not certified by the SAP HANA Hardware Directory. (D) Signup and view all the answers

What does the SAP HANA native storage extension allow you to do?

Manage less frequently accessed data without fully loading it into memory. (A) Signup and view all the answers

Which method would be inappropriate for sizing SAP BW/4HANA?

Following the sizing rules from SAP Note 1514966. (D) Signup and view all the answers

Which capability does SAP HANA Smart Data Access provide?

It enables accessing remote data as if it were local tables. (A) Signup and view all the answers

What is a key feature of the Data Aging functionality in SAP HANA?

It ensures that data aging tables remain under control of SAP S/4HANA. (D) Signup and view all the answers

Which sizing recommendation is crucial for certified hardware configurations?

Constantly checking the latest SAP development documentation. (A) Signup and view all the answers

What is the main purpose of SAP HANA dynamic tiering?

To manage historical data through a disk-centric store. (A) Signup and view all the answers

Which SAP Note is associated with sizing for SAP Suite on SAP HANA?

SAP Note 1793345 (A) Signup and view all the answers

In which scenario might applications other than the SAP HANA database software be installed on the database server?

When explicitly supported by SAP. (A) Signup and view all the answers

What advantage does nearline storage offer for SAP HANA systems?

It helps to reduce the main memory amount needed. (B) Signup and view all the answers

What is the requirement when calculating memory for an SAP HANA appliance?

Consulting multiple recommended SAP Notes for thoroughness. (C) Signup and view all the answers

What happens when changes are made to SAP S/4HANA data aging tables outside of SAP S/4HANA?

It can lead to SAP S/4HANA failure. (A) Signup and view all the answers

Which of the following is NOT a benefit of using SAP HANA Tailored Data Center Integration (TDI)?

Simplified hardware management and reduced IT complexity. (A) Signup and view all the answers

What is the minimum bandwidth requirement for the Internal and Storage zones when using Ethernet?

10 GbE (B) Signup and view all the answers

What is the specific certification required for individuals installing SAP HANA in a TDI environment?

SAP Certified Associate - Database Administrator - SAP HANA (C_DBADM_2404) or newer (A) Signup and view all the answers

What is the purpose of vendor-specific configuration guides for storage in a TDI setup?

Provide information on how to configure the storage for optimal performance with SAP HANA. (C) Signup and view all the answers

Which of the following is a true statement about SAP HANA hardware partners and TDI deployments?

Sub-contractors of hardware partners are required to be certified to install SAP HANA. (C) Signup and view all the answers

What tool is recommended for checking the storage KPIs in a SAP HANA tailored data center integration environment?

SAP HANA Hardware and Cloud Measurement Tool for Tailored Data Center Integration (A) Signup and view all the answers

Which of the following is NOT a requirement for a certified storage system in a TDI environment?

It must be installed by a certified SAP HANA professional. (A) Signup and view all the answers

What is the minimum bandwidth requirement for the enterprise storage when using Fibre Channel in a TDI setup?

8 GbF (D) Signup and view all the answers

In a TDI setup, which zone is used for communication between SAP HANA worker nodes (inter-node communication)?

Internal zone (A) Signup and view all the answers

According to the document, what is the minimum bandwidth requirement for the client zone?

There is no specified minimum bandwidth requirement for the client zone. (D) Signup and view all the answers

What does SAP recommend for network segmentation in a TDI setup?

Segmenting networks based on communication zones (Client, Internal, Storage). (B) Signup and view all the answers

Who is responsible for configuring network security and segmentation features in a TDI environment?

The network switch vendor (D) Signup and view all the answers

What does SAP provide regarding hardware certification for a TDI setup?

Certification for the combination of compute nodes and storage systems. (C) Signup and view all the answers

What does SAP suggest doing before going live with a TDI setup?

Performing a Go-Live Check with SAP Digital Business Services. (A) Signup and view all the answers

Which of the following statements is TRUE about SAP HANA TDI and hardware partners?

SAP provides a list of certified hardware partners in the SAP HANA Hardware Directory. (B) Signup and view all the answers

Study Notes

SAP HANA Sizing

SAP HANA sizing focuses on memory, determined from the source database size.
Data compression in SAP HANA varies by scenario, and sizing uses Quick Sizer, reports, and SAP Notes.
Hardware configuration selection follows memory sizing, with choices between SAP HANA appliance and tailored data center integration (TDI).
Sizing method depends on the customer's implementation scenario, use case and existing systems.
Quick Sizer is for new customers and greenfield implementations; sizing reports for migrating from SAP NetWeaver.
SAP experts are required for complex scenarios like consolidating or migrating large systems.

SAP HANA Tailored Data Center Integration (TDI)

TDI offers more hardware flexibility than appliances, allowing for reusing existing components and processes.
Hardware components must be certified by SAP and hardware partners for TDI deployments.
TDI systems avoid formal certification of infrastructure; instead, certified hardware components are validated.
Users needing to install SAP HANA must hold a valid SAP Certified Associate - Database Administrator - SAP HANA (or a newer version) certification.

SAP HANA Memory Sizing

Initial memory sizing uses both Quick Sizer and SAP Notes for accuracy.
Sizing for various solutions like SAP Suite on SAP HANA, SAP BW/4HANA and more are available using corresponding reports and SAP Notes.
Static memory relates to table data, while dynamic memory is for objects created during queries or data loading, with dynamic sizing required to be double the static requirements.
Virtualized and scale-out environments require additional considerations via SAP Notes.

SAP HANA Storage Requirements

Persistent storage includes data and log volumes.
Data volume size calculation includes net disk size plus 20% for delta merge operations and year-on-year growth.
Log volume size varies depending on the data changes between SAP HANA checkpoints; the log size depends on memory.
A greater database size means proportionally larger space requirements for backups and exports.

SAP HANA Installation Storage

/hana/shared/ stores binaries, traces, and configuration files; the directory setup depends on the single-node or scale-out configuration.
Minimum disk space recommendations vary based on the size of the database and the number of worker nodes in a multi-node system.

SAP HANA Backup Requirements

Complete backups require space for stored backups and the number of backup generations.
Log backups ensure zero-data loss recovery and provide a point-in-time recovery capability.
Central shared storage for multiple backups can be used with parallel processes but must account for potential data throughput limitations.

SAP HANA Export Space Requirement

Storage space for binary exports for analysis purposes; two times the size of the largest table is considered sufficient in routine cases.

SAP HANA Network Requirements

Enterprise networks for SAP HANA TDI use client, internal, and storage zones.
Internal and storage zones require a minimum 10 Gbit/s Ethernet or 8 Gb Fibre Channel to meet data throughput and latency requirements.

SAP HANA CPU Sizing

CPU requirements are calculated using a formula (300 SAPS per active user / 0.65).
An active user is one consuming CPU power at any time.
Initial estimation; verification via testing with significant transactions is recommended.

SAP HANA Quick Sizer

Quick Sizer calculates CPU, disk, memory requirements in a hardware/database-independent format.
Multiple predefined scenarios available for initial sizing recommendation, including predefined scenarios for different product suites like SAP Business Suite on SAP HANA, SAP S/4HANA, SAP BW/4HANA, Standalone SAP HANA and SAP S/4HANA Cloud.
Sizing is an iterative process involving the customer, vendor and SAP.

SAP HANA Appliance Sizing

Memory sizing determines hardware recommendation for an appliance; storage and CPU sizing are already included in certified appliances.

SAP HANA Sizing Non-NetWeaver

SAP Note 1514966 describes sizing for non-NetWeaver scenarios, which should not be used for SAP BW/4HANA, Suite on HANA systems, or SAP S/4HANA.

Other Data Handling and Storage

SAP HANA native storage extension improves cost-to-performance ratio by managing less-frequently accessed data without loading it into memory.
Non-active data concept improves resource management for large BW systems, enabling data displacement based on the last-recently-used concept.
Nearline storage solutions for cold data management.
SAP HANA smart data access provides access to remote data without copying to SAP HANA.
Deprecated SAP HANA dynamic tiering extends SAP HANA memory with a disk-centric columnar store for less frequent access data.

Studying That Suits You

Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

Description

This quiz covers the essential aspects of SAP HANA sizing, focusing on memory, data compression, and hardware configuration selection. It also explores Tailored Data Center Integration (TDI), emphasizing its flexibility and certification requirements for hardware components. Test your knowledge on these critical topics in SAP HANA implementation!