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;

You can use M_LICENSES System View which is used to provide the information on all of the licenses that are installed on this system.

The following table lists all the key server components in HANA, the corresponding services, and OS process details.

M_SYSTEM_LIMITS is a view to getting SAP HANA system limits. You can query this view to find the limitations of HANA system −SELECT * FROM M_SYSTEM_LIMITS;It will provide you details about Database Limitation Schema Limitations Tables and View Limitation Indexes and Constraints SQL SQL Script