SAP HANA DB Servers


Monitor Information


METRICS:


Overall Memory and CPU:


S.NO:
METRIC
DESCRIPTION
UNITS
1
Memory Utilization
Percentage of Memory Utilized by HANA System as a whole
%
2
CPU Utilization
Percentage of CPU Utilized by HANA System as a whole %
3
CPU  Available
No. of CPU Available
-
4
CPU Used
Used no. of CPU
-
5
Total Physical Memory
Total Physical Memory of HANA System
GB
6
Used Physical Memory
Memory Used by HANA System
GB
7
Total Swap Memory
Total Swap Memory allocated for HANA System
GB

Connection Statistics:


S.NO:
METRIC
DESCRIPTION
UNITS
1
Active Connections
Total No. of Active Connections
-
2
Inactive Connections
Total No.of Inactive connections
-
 

Memory Details of Host:


S.NO:
METRIC
DESCRIPTION
UNITS
1
Total Physical Memory
Total Memory for each host in the HANA system.
GB
2
Free Physical Memory
Free Memory Available in individual host
GB
3
Used Physical Memory
Used Memory in individual host (HANA+other appllications)
GB
4
Swap Memory
Swap Memory of individual host
GB
5
Used Swap Memory
Swap Memory used.
GB
6
Peak Memory
Peak Memory used in each host
GB


Memory Used By HANA:


S.NO:
METRIC
DESCRIPTION
UNITS
1
Allocation Limit
Memory allocated for HANA in each host
GB
2
HANA used memory
Memory Used only by HANA in each host (Total resident)
GB
3
Memory Used by Column Tables

GB
4
Memory Used by Row tables

GB
5
Code & Stack Memory
Memory used by HANA Code and Stack
GB
6
DataBase Resident

GB


Disk Usage:


S.NO:
METRIC
DESCRIPTION
UNITS
1
Disk usage Type
Disk usage type.
Type
2
Total Disk Space
Total Space allocated for each Disk
GB
3
Disk Used
Disk Used
GB
4
Disk Free percentage

%
5
Disk Path
 Disk Location

6
Disk Volume size

GB


Services:


S.NO:
METRIC
DESCRIPTION
UNITS
1
Service name


2
CPU used
Percentage of CPU used by each service
%
3
Memory Used
Memory used by each service
GB
4
Requests per sec


5
Response Time

ms
6
Active Requests count


7
Pending requests count


8
Active Threads count


9
Open File Count


10
Service status


Service Workload:


S.NO:
METRIC
DESCRIPTION
UNITS
1
Current Execution Rate/min


2
Current Compilation Rate/min


3
Current Transaction Rate/min


4
Current Commit Rate/min


5
Current Rollback Rate/min


6
Current Memory Usage Rate/min

MB

System Replication:


  

S.No
COLUMN NAME
DESCRIPTION
1

HOST

Host name
2

SERVICE_NAME

Name of the Service

3
SITE_NAME
Logical site name
4
SECONDARY_HOST
Secondary Host
5
SECONDARY_SITE_NAME
Secondary Logical site name
6
REPLICATION_STATUS
Replication Status
 
Backup Catalog: Latest 10 Backups


S.NO:
METRIC
DESCRIPTION
UNITS
1
Backup Size

GB
2
Source Type name
Type of persistence to be backed up: 'volume', 'topology'
3
Service Type Name

Type of database service: 'indexserver', 'nameserver', 'statisticsserver'


4
Entry type Name
Classification of backup catalog entries: 'complete data backup', 'data snapshot', 'log backup', 'log missing'
5
Start time
Time stamp when backup started

6
Total Time
TimeTaken for Backup

7
Backup status
Result of corresponding action: 'successful', 'failed', 'running', 'cancel pending', 'canceled'

Schema Details


S.NO:
METRIC
DESCRIPTION
UNITS
1
No.of Column Tables


2
Size of Column Tables

MB
3
No. of Row Tables


4
Size of row tables

MB

JOBS: (Long Running Jobs)


S.NO:
METRIC
DESCRIPTION
UNITS
1
Connection Id
Connection that triggered the operation
2
Schema name
Schema of the object
3
Object name
Name of the object
4
Job Name
Type of the operation
5
Start Time


6
Current Job Progress



Transaction Statistics:


S.NO:
METRIC
DESCRIPTION
1
Active Transactions
No. of Active Transactions
2
InActive Transactions

3
Precommited Transactions

4
Aborting Transactions

5
Partial Aborting Transactions

6
Active_prepare_commit Transactions


Blocked transactions:


S.NO:
METRIC
DESCRIPTION
UNITS
1

BLOCKED_TRANSACTION_ID

Transaction object ID of the transaction waiting for a lock
2
LOCK_OWNER_TRANSACTION_ID

Transaction object ID of the transaction holding the lock


3
BLOCKED_TIME

4

WAITING_SCHEMA_NAME

Name of the schema on which the lock is currently placed


5

WAITING_OBJECT_NAME

Name of the object on which the lock is currently placed


6
LOCK_TYPE

Lock type: 'RECORD', 'TABLE', 'METADATA'


7

LOCK_MODE

Lock mode: 'SHARED', 'EXCLUSIVE', 'INTENTIONAL EXCLUSIVE'
8
Blocked Statement
Statement that is blocking the transaction

CACHES:


S.NO:
METRIC
DESCRIPTION
UNITS
1
Cache id
unique identifier for the cache
2
Total Size
maximum available memory for each cache instance MB
3
Used Size
Memory Used by Cache instance MB
4
Hits Count
number of cache hits for the cache instance
5
Misses Count
number of cache misses for the cache instance



Expensive Statements:  Top 10 Statements with longer duration


S.NO:
METRIC
DESCRIPTION
UNITS
1
Statement Duration
 
microseconds
2
Records
Number of records
3

MEMORY_SIZE

Memory required for computing the statement KB
4

CPU_TIME


microseconds
5
DB User


6
Operation
Type of operation: e.g. prepare, execute, fetch, close
7
Statement
Statement string
8

ERROR_CODE



9

ERROR Message




Alerts: Latest 100 Alerts between last Datacollection and current datacollection


S.NO:
METRIC
DESCRIPTION
UNITS
1

ALERT_ID



2
Alert rating


3
Alert TimeStamp


4
Description
Description of the alert



 

See Also

Creating New Monitor - IBM DB2 Database Server