In SAP HANA system, you use statistics serve as a key to internal monitoring infrastructure. You will be notified when a critical alert raised in your HANA environment and you can also get all the historical monitoring data for analysis.Statistical Server is responsible for collecting the data related to system resources, their allocation, and consumption of the resources and overall performance of HANA system.For more details, you can refer our SAP HANA core architecture topichttps://www.tutorialspoint.com/sap_hana/sap_hana_core_architecture.htm

_SYS_STATISTICS- This schema stores all system configuration and parameter details of HANA system.You can find this under Catalog folder in HANA Studio once you select relevant HANA system in System pane.

In SAP HANA database, there are 3 types of schema −User Defined Schema: These schemas are created by database users or administrators. All the schemas under Catalog tab except from System defined and SLT derived schemas are user defined schemas.System Defined Schema: These are generated as result of using HANA related functions. These are of following types −_SYS_BI_SYS_BIC_SYS_REPO_SYS_STATISTICS_SYS_XS-ENGINESLT Derived Schema: These schema are generated as part of SLT Data replication in HANA.

In SAP HANA, Delivery unit is known as single unit, which can be mapped to multiple packages and can be exported as a single entity so that all the packages assigned to Delivery Unit can be treated as a single unit.Delivery units can be used to export all the packages that make a delivery unit and the relevant objects contained in it to a HANA Server or to the local Client location.The user should create Delivery Unit prior to using it. This can be done through HANA Modeler -> Delivery Unit -> Select System and Next -> Create -> Fill ... Read More

In SAP HANA system, you can see all the packages under Content tab in HANA studio. All HANA modeling objects are created inside packages. Packages can be used for migrating modeling views in HANA system.You can also create a sub-package, and different HANA modeling views- Attribute view, Analytic View and Calculation view in a package. When you expand Content tab, you can see list of all available packages. When you expand a package you can see different Attribute, analytic and calculation views in that package.You can also create Decision Table, Define Analytic Privilege and create Procedures in a Package.When you ... Read More

When we create a model and activate it, the runtime column views are created and stored under column view section of _SYS_BIC schema. _SYS_BIC schema stores all the columns views of activated objects.When the user activates the Attribute View/Analytic View/Calculation View/Analytic Privilege /Procedure, the respective run-time objects are created under _SYS_BIC/ Column Views.

SAP HANA Cockpit with Fiori-based Launchpad shows the content in the form of tiles arranged in groups. Using these tiles, you can access individual applications and can also access app-specific data for immediate review.You can also perform a drill on these tiles to see the detailed information about specific applications.Following roles are required to open and access tile-based SAP HANA Cockpit − sap.hana.admin.roles:: Monitoring or sap.hana.admin.roles:: AdministratorYou can also open SAP HANA Cockpit via HANA Studio. Navigate on HANA system -> Configuration and Monitoring -> Open SAP HANA Cockpit.You can also open HANA Cockpit in an offline mode using a ... Read More

M_BLOCKED_TRANSACTIONS System View is used to provide a transaction list waiting for locks.You can run the following SQL query in the editor −SELECT * FROM M_BLOCKED_TRANSACTIONS;Details available under M_BLOCKED_TRANSACTIONS System View in SAP HANA

In SAP HANA Administration Perspective, you can select your HANA system in Studio and navigate to Administration option at the top.When you go to Alerts tab, you can see all the current alert. You can see Description of alerts, date and time when an alert is raised and priority of alert- low, medium or high.From drop down, you can also check All Alerts raised in the past.Also note that you can also check alerts raised between specific time duration. To set the filters, click on Filter icon on right side.