SAP Articles - Page 36 of 104

This can be checked using system view M_EXPENSIVE_STATEMENTS.SELECT * FROM M_EXPENSIVE_STATEMENTSIn SAP HANA, the M_EXPENSIVE_STATEMENTS view provides convenient access to the most expensive statements that were executed on the system. A statement is considered being expensive if its runtime exceeds a particular threshold. Please note that the expensive statements trace needs to be activated first in the Performance → Expensive Statements Trace screen in the SAP HANA studio. Click Configure the Trace Configuration dialog

When you add a HANA system in HANA Studio, you can see different tabs under system pane. Each pane has different object types of HANA system.To see the list of all schema and tables, you need to navigate to Catalog tab.Other available tabs in HANA Studio includes:BackupCatalogProvisioningContentSecurityYou can check under table type- if a table is row store or column store. On right top corner, it is mentioned.New tables can be created using the two methods given below −Using SQL editorUsing GUI optionThe new table can be created using SQL Create Table statement −Create column Table Test1 (    ID ... Read More

You can make use of M_VOLUME_IO_TOTAL_STATISTICS System View which shows information about basic I/O operations on I/O subsystems (paths).

This can be checked in Performance tab under Administration icon in SAP HANA.In this tab, you can check the following:ThreadsSessionsBlocked TransactionsSQL Plan CacheExpensive statement traceJob ProgressLoad

The following information is available under SAP HANA M_BLOCKED_TRANSACTIONS System View

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

M_DISKS System View is used to provide information about disk configuration and utilization of the host machine. The following information is available −

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.

You can make use of M_DISKS System View which provides information about disk configuration and utilization of the host machine.SELECT * FROM M_DISKS;