The SAP HANA Administration Guide does not cover administration tasks related to SAP HANA options and capabilities, such as SAP HANA. Server Architecture of SAP HANA XS Advanced Runtime Platform. . SAP Solution Manager for SAP HANA Administration. time data platform is the SAP HANA database, which is fundamentally This tutorial will teach you SAP HANA Administration tasks in a single and distributed.
|Language:||English, Spanish, Indonesian|
|Distribution:||Free* [*Register to download]|
SAP HANA Administration Tutorial in PDF - Learn SAP HANA Administration in simple and easy steps starting from basic to advanced concepts with examples. distributed SAP HANA instances that allow scaling out the database, thereby .. application is available from within the administration tool SAP HANA Studio. PUBLIC SAP HANA Platform SPS 12 Document Version: – SAP HANA Administration Guide Content 1 Getting Started.
Calculated Measure: Calculated Measures are created using some calculation on top of an existing measures or attributes. Private Measures: Private Measures are measures used inside a modeling views and cannot be used outside the view. As such, they can only contain the values available in the Columns they relate to.
Variables do not impact the execution HANA Input parameters used to manipulate the execution based on user input. Sometimes you might not want a variable to just restrict the data of a view. But you also want to take input from the user and process it, returning dynamic data based on the user selection. Input Parameters makes this possible. To avoid the risk of losing data in case of hardware failure or power cutoff, persistence layer comes as a savior and stores all the data in the hard drive which is not volatile.
Mention what is modeling studio? Distinct Values: It displays all attributes along with data in graphical format.
Analysis: It displays all attributes and measures in graphical format. Also HANA Column-based storage makes it easy to execute operations in parallel using multiple processor cores. In a column store data is already vertically partitioned. This means that operations on different columns can easily be processed in parallel.
If multiple columns need to be searched or aggregated, each of these operations can be assigned to a different processor core. In addition operations on one column can be parallelized by partitioning the column into multiple sections that can be processed by different processor cores.
What are the different types of Input parameters supported? Currency: Use this during currency conversion where the end user should specify a source or target currency. If the monitored system supports drilling down into alerts, you can click the listed alerts to display further details. If the monitored system supports impact analysis, you can see the relationship between the monitored and other systems in your landscape and how these might be affected if the monitored system has an issue.
The Enterprise Health Monitor displays a list of systems with health indicators for availability, capacity, performance, and alerts. Hover your mouse over a health indicator icon an arrow, for example to see an explanation of what it means.
Click in the System, Availability, Capacity, Performance, or Alerts column for a system to display information provided by the system's cockpit. The links available vary; some systems do not provide links for every column.
You may be prompted to log in to the system. If the list is long, focus on systems of interest by clicking Running Systems or Stopped Systems at the top of the screen, or use the search and filter tools.
Authenticate with a system before you try to start or stop it. Instead, use this user to create dedicated database users for administrative tasks and to assign privileges to these users. Database Header The name of the system or database appears in the shell bar of the launchpad. If the system has the system usage type production, this is also indicated.
Context Sensitive Help The cockpit header now also includes a help icon. This provides easy access to the documentation for the currently opened app. You can configure the intervals in the homepage settings. It is only available in the system database. The following tiles are available: Manage Databases - indicates overall system health and provides access to the Manage Databases app where you can monitor the status and resource usage of individual databases, as well as perform other administration tasks System Alerts - indicates the number of high and medium alerts currently raised in tenant databases and provides access to the Alerts app where you can view and analyze alert details SAP SE or an SAP affiliate company.
Manage Databases You monitor the overall availability, resource usage, and performance of tenant databases and the system database itself from the system database using the Manage Databases app.
If you want to examine a particular database in more detail, you can drill-down further by clicking the aspect you're interested in for example, database name, alerts or used memory. Further operations on a tenant database stop, start, and delete are available in the footer toolbar. Manage Databases Drill Down If you want to examine a particular database in more detail, you can drill-down further by clicking the aspect you're interested in for example, database name, alerts or used memory.
The corresponding applications display tenant specific information e. Creating a Tenant Database You create tenant databases from the system database using the Manage Databases app.
Choose Create Tenant Database in the footer toolbar. Specify the host on which the database is to be created. Click Create Tenant Database. The system starts creating the database. This may take a few moments to complete. The new tenant database is automatically added to the Manage Databases app. System Alerts The System Alerts tile indicates the number of high and medium alerts currently raised in tenant databases and provides access to the Alerts app where you can view and analyze alert details.
The system administrator can see only those alerts that identify situations with a potentially system-wide impact, for example, the physical memory on a host is running out. Alerts that expose data in the tenant database for example, table names are not visible to the system administrator in the system database.
It may be helpful to see how alerts are configured in individual tenant databases. The system administrator cannot change the configuration. SAP HANA Database Administration Tiles of this catalog are used to administer an individual database either a single-container system, a tenant database or the system database of a multiple-container system.
Manage Services The tile displays the overall database status. In the app, the status of all services is displayed. For each service, detailed information about its memory and CPU consumption is available. Service administration tasks e. Most important actions are directly available in the footer toolbar, more actions are available using the menu.
If a service is offline, a link to the corresponding crash dump is available If high priority alerts exist, this is shown on the tile as well as in the app. Direct access to the Alerts app is provided for further analysis of such alerts. Memory Allocation Statistics Open the Memory Allocation Statistics app from the Manage Services app by clicking the value in the Used Memory column of the service whose memory allocation history you want to see.
Use the History Graph to analyze the used memory history of the component and its subcomponents. Several options are available, for example: To visualize the memory usage of individual subcomponents over the same time period as the selected component, simply select them in the subcomponents table. To see time-specific values, move the mouse over the graph. Alerts The tile shows a summary of alerts The Alerts app provides more information about these alerts and allows to analyze historical occurrences.
The current alerts are displayed in list format on the left. To see more detailed information about a specific alert on the right, simply select it. The details include a link to follow-up actions or analysis apps and a display of past occurrences of this alert. To see past alerts, click Past Alerts in the footer toolbar.
Options for filtering, searching, and sorting are available to customize the list of alerts. To get to the check configuration, click Configuration Alert in the footer toolbar.
Configure Alerts All alert checkers are displayed in list format on the left. To see more detailed information about a specific check on the right, simply select it. The following configuration options are possible for alert checkers: Change the threshold values that trigger alerts of different priorities.
Set up e-mail notifications so that specific people are informed when alerts are issued. In addition, you can perform the following actions on checks: Run checks on a once-off basis, regardless of their configured schedule or status Switch checks off and on. User Tables The tile shows the comparative memory utilization by host and the number of high and medium priority alerts.
Using the app you can visualize tables by size, explore the usage history of tables, and move tables to extended storage if SAP HANA dynamic tiering is installed. Large in-memory tables that are accessed infrequently are good candidates for extended storage, which is provided by the SAP HANA dynamic tiering option.
Tables in extended storage disappear from table analysis display. Monitor Statements Allows to analyze the most critical statements currently running in the database. This can help you identify the root cause of poor performance, CPU bottlenecks, or out- of-memory situations. Contains KPIs like statement runtime, lock wait time, and cursor duration By default, statements are listed in order of longest runtime.
You can identify the application, the application user and the database user running the statement. You can easily identify blocking situations. You can cancel a session in a blocking situation either the blocking or the blocked session can be canceled. Performance Monitor Allows to visually analyze historical performance data across a range of key performance indicators.
Initially visualizes resource usage on the master host and master index server according to the selected tile. You can customize the information displayed in several ways, for example: Add additional KPIs Add additional hosts and index servers Increase or decrease the date range of collected data Zoom in to a specific time. System Replication The System Replication tile is available in catalog SAP HANA System Replication It indicates whether or not the system is part of a system replication configuration With the System Replication app you can monitor the status of replication between the primary system and the secondary system s.
Successful, Running, Canceled, Error By clicking the tile, the backup catalog is opened. It shows: Time range that the backup catalog covers Size of the backup catalog itself Information on the last data backups status, start time, backup type, duration, size, destination type and comment By clicking an entry in the catalog, detailed information on the respective backup is displayed New backups can be created.
System Restarts Tile Indicates the number of services that have been manually or automatically restarted. If restarts have been detected, this tile provides access to the Alerts app where you can view the related alerts. Number of Dumps Tile Indicates the number of dump files in the system's trace directory.
TraceViewer or the parent role sap. SecurityAdmin or the parent role sap. Further Catalogs Applications that provide core administration and monitoring features are available by default. Applications that allow you to manage optional components are only available if the optional component has been installed.
The knowledge center is structured according to the product lifecycle: So you can find e.
No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP SE or an SAP affiliate company.
Please see http: Some software products marketed by SAP SE and its distributors contain proprietary software components of other software vendors. These materials are provided by SAP SE or an SAP affiliate company for informational purposes only, without representation or warranty of any kind, and SAP SE or its affiliated companies shall not be liable for errors or omissions with respect to the materials.
The only warranties for SAP SE or SAP affiliate company products and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty.
In particular, SAP SE or its affiliated companies have no obligation to pursue any course of business outlined in this document or any related presentation, or to develop or release any functionality mentioned therein. The information in this document is not a commitment, promise, or legal obligation to deliver any material, code, or functionality.
All forward- looking statements are subject to various risks and uncertainties that could cause actual results to differ materially from expectations. Readers are cautioned not to place undue reliance on these forward-looking statements, which speak only as of their dates, and they should not be relied upon in making downloading decisions.
Flag for inappropriate content.
You can use this information to analyze performance and to diagnose and debug errors. This is good for recording a scenario. By default, the SQL trace is inactive. Expensive statements trace Expensive statements are individual SQL queries whose execution time was above a configured threshold.
The expensive statements trace records information about these statements for further analysis. By default, the expensive statements trace is inactive. Plan trace If the plan trace is active, you can visualize and analyze the execution plans for every query that has been executed in the specified application.
It records performance indicators for individual query processing steps in the database kernel. By default, the performance trace is inactive.
By default, the kernel profiler is inactive.