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
|
|