Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
SAP HANA Articles
Page 18 of 58
Details available under M_BLOCKED_TRANSACTIONS System View in SAP HANA
The following information is available under SAP HANA M_BLOCKED_TRANSACTIONS System View
Read MoreM_Expensive statement in SAP HANA
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
Read MoreChecking information about basic I/O operations on I/O subsystems in SAP HANA
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).
Read MoreDisk utilization and configuration details view in SAP HANA
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;
Read MoreChecking System limits in SAP HANA
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
Read MoreMaximum Column name length in SAP HANA
Maximum column name length supported in a table in SAP HANA is 127 chars.
Read MoreMaximum number of columns in a table in SAP HANA
The maximum number of columns in a table is 1000.
Read MoreMaximum Table name length in SAP HANA
Maximum table name length supported in SAP HANA is 127 characters.
Read More