System Information
The information provided in these sections is helpful for analyzing performance issues.
Connections
This section provides detailed information about open connections.
To display a full SQL statement, select a row and choose Display Statement String.
Connection Statistics
This section provides information about open connections, such as network IO statistics.
Transactions
This section displays open transactions.
Caches
This section provides information about caches created by SAP HANA database.
The Total Size column shows the size of the available caches.
Large Tables
This section provides historical information about the largest tables in the database.
By default, the information for large tables is displayed from the time that the statistics server collector was last run. To display the current live statistics, select Current.
If the statistics server collectors that collect the statistical data have been deactivated, no data is shown here.
More information: SAP Note 2147247 (FAQ: SAP HANA Statistics Server) in Related Information
This information is helpful for analyzing performance and system dimensions. You can see the table sizes in main memory, the delta sizes, and the fastest growing tables.
Statistics are displayed in separate tabs for Memory Sizes of Column Tables, Memory Sizes of Row Tables, and Disk Sizes.
More information: SAP Note 1864506 (_SYS_STATISTICS tables not showing sizes of specific tables) in Related Information
|
Function |
Description |
|---|---|
|
Display the absolute values for the table memory sizes history collected by the statistics server. |
Leave all selections empty. |
|
Display the statistics for a specific schema. |
Specify a schema name. Choose Possible Values to display the available schemas. Choose Apply Selection. |
|
Highlight the tables that have grown fastest over a specific period. |
After you have selected a schema, select Fastest Growth and specify a number of days and the number of hits to display. Choose Apply Selection. |
|
Display the current live size statistics for all tables. |
Select Current. To display historical statistics, deselect Current. Note With older service packages, this option is not available.
You can also use native SQL to display live statistics. More information: See the code example in SQL Editor in Related Information |
|
Sort the size statistics. |
You can sort the statistics for column tables, row tables, and disk sizes by several different criteria. Select a sort option from the pull-down menu. |
|
Display the increment of the table sizes history collected by the statistics server. |
Select Fastest Growth and choose Apply Selection. |
SQL Workload
This section provides an overview of statements that were executed.
License
License keys are required to use SAP HANA databases. With DBA Cockpit, you can display information about the current license key, delete the license key, or install a new license key file.
A temporary license key, which is valid for 90 days, is automatically installed with a new SAP HANA system. During this period, you should request and apply a permanent license key.
You can request a permanent license key on the SAP Service Marketplace Support Portal under Keys, Systems & Installations. Permanent license keys are valid until the predefined expiration date. Furthermore, they specify the amount of memory licensed to the target SAP HANA installation. Before a permanent license key expires, you should request and apply a new permanent license key. If a permanent license key expires, a temporary license key valid for 28 days is automatically installed. During this time, you can request and install a new permanent license key.
Others
This section allows you to display system information that is not included elsewhere in DBA Cockpit for SAP HANA.
You can open several predefined SQL SELECT statements on system views.
To display more information, double-click an item in the overview.
To display the underlying SQL statement, choose Details.
Data Browser for System Tables
The tables and views in schemas SYS and _SYS_STATISTICS contain data that is useful for analyzing system performance.
This section shows all the views and tables in the schema SYS.
In field <Max. No. of Hits>, you can limit the length of the list displayed.
To display the content of a table, select the table and choose Display Table/View Content.
This section shows all the views and tables in the schema _SYS_STATISTICS.
In field <Time Frame>, specify how far back in the past to display changed tables or views.
In field <Max. No. of Hits>, you can limit the length of the list displayed.
To display the content of a table, select the table and choose Display Table/View Content.