Rodolphe <email @ gmail com>
daily monitoring VX1
sender@orange.fr <sender@orange.fr>30 octobre 2020 à 11:46
À : email @ gmail com

Hello
Please find the results of our dailycheck 2020-10-30 11:41:00 on SAP VX1.

********* HANA CHECKS *********


1-- healtcheck CPU since 24H and top 20

HOST TIME MEMORY_USED_GB CPU ACTIVE_THREAD_COUNT WAITING_THREAD_COUNT MVCC_VERSION_COUNT CS_UNLOAD_COUNT
hostname 2020-10-30 11:25:23.461000 159.81 96 22 10 1061 0
hostname 2020-10-30 11:25:13.380000 159.7 92 30 17 1061 0
hostname 2020-10-30 11:25:03.304000 158.94 94 25 12 1083 0
hostname 2020-10-30 11:24:53.222000 158.37 96 25 12 875 0
hostname 2020-10-30 11:24:44.139000 158.12 97 25 13 875 0
hostname 2020-10-30 11:24:34.050000 157.87 97 26 13 876 0
hostname 2020-10-30 11:24:23.991000 157.57 97 25 12 875 0
hostname 2020-10-30 11:24:13.910000 157.32 95 25 12 875 0
hostname 2020-10-30 11:24:03.835000 157.05 94 25 12 897 0
hostname 2020-10-30 11:23:53.755000 156.76 97 26 13 684 0
hostname 2020-10-30 11:23:43.669000 156.46 96 26 13 695 0
hostname 2020-10-30 11:23:33.558000 156.21 97 26 13 684 0
hostname 2020-10-30 11:23:23.478000 155.95 97 26 13 684 0
hostname 2020-10-30 11:23:13.392000 155.65 94 26 13 684 0
hostname 2020-10-30 11:23:03.316000 154.57 94 22 9 720 0
hostname 2020-10-30 11:22:53.235000 153.18 96 18 5 512 0
hostname 2020-10-30 11:22:44.107000 153 96 19 5 512 0
hostname 2020-10-30 11:22:34.053000 152.82 94 18 6 499 0
hostname 2020-10-30 11:22:23.949000 152.54 94 17 5 498 0
hostname 2020-10-30 11:22:13.861000 152.31 79 18 5 498 0

2-- peak memory usage since 24H

TOP_MEMORY_USED_GB
160.38

3-- search high usage of memory > 8GB and top 10

APP_USER APPLICATION_NAME STATEMENT_HASH OPERATION REPLACE(SUBSTR(CONCAT('--',STATEMENT_STRING),1,50),CHAR(10),'') PARAMETERS START_TIME DURATION_SEC END_TIME Memory Size Gb
eba60085cded204c2538b5fe01229901 SELECT --WITH /* [NAME]- HANA_Configuration_MiniChec 2020-10-30 09:35:33.694000 258.501195 2020-10-30 09:39:52.694000 15.44
eba60085cded204c2538b5fe01229901 AGGREGATED_EXECUTION --WITH /* [NAME]- HANA_Configuration_MiniChec 2020-10-30 09:34:12.624000 341.89035 2020-10-30 09:39:54.624000 15.44
eba60085cded204c2538b5fe01229901 SELECT --WITH /* [NAME]- HANA_Configuration_MiniChec 2020-10-30 09:12:55.307000 325.771187 2020-10-30 09:18:21.307000 15.38
eba60085cded204c2538b5fe01229901 AGGREGATED_EXECUTION --WITH /* [NAME]- HANA_Configuration_MiniChec 2020-10-30 09:11:40.363000 403.069718 2020-10-30 09:18:23.363000 15.38
eba60085cded204c2538b5fe01229901 SELECT --WITH /* [NAME]- HANA_Configuration_MiniChec 2020-10-30 11:21:42.156000 233.554193 2020-10-30 11:25:36.156000 15.33
eba60085cded204c2538b5fe01229901 AGGREGATED_EXECUTION --WITH /* [NAME]- HANA_Configuration_MiniChec 2020-10-30 11:20:29.051000 309.065658 2020-10-30 11:25:38.051000 15.33
admin HDBStudio ddb4d137b9e199f19d07b299d21e5a87 SELECT --WITH /* [NAME]- HANA_Configuration_MiniChec 2020-10-29 15:45:54.282000 777.603611 2020-10-29 15:58:52.282000 15.32
admin HDBStudio ddb4d137b9e199f19d07b299d21e5a87 AGGREGATED_EXECUTION --WITH /* [NAME]- HANA_Configuration_MiniChec 2020-10-29 15:44:39.729000 854.579214 2020-10-29 15:58:54.729000 15.32
eba60085cded204c2538b5fe01229901 SELECT --WITH /* [NAME]- HANA_Configuration_MiniChec 2020-10-30 11:11:19.814000 239.057126 2020-10-30 11:15:18.814000 15.3
eba60085cded204c2538b5fe01229901 AGGREGATED_EXECUTION --WITH /* [NAME]- HANA_Configuration_MiniChec 2020-10-30 11:10:04.580000 316.643721 2020-10-30 11:15:21.580000 15.3

4-- duraction average for top 20 users from EXPENSIVE_STATEMENTS>1sec , H-24 and limit of 30K entries of EXPENSIVE_STATEMENTS table

APP_USER REQ_SQL AVG_SEC TOTAL_SEC
admin 11 166.91 1835.96
BPINST 32 18.94 606.14
SAPSYS 39 7.77 302.89
BGRFCUSER 40 7.33 293.19

5-- last backup db

ENTRY_TYPE_NAME SYS_START_TIME SYS_END_TIME STATE_NAME
log backup 2020-08-13 16:12:30 2020-08-13 16:12:30.011000 successful
complete data backup 2020-08-13 15:37:12.472000 2020-08-13 16:12:29.998000 successful
log backup 2020-07-31 12:28:56.223000 2020-07-31 12:28:56.231000 successful
complete data backup 2020-07-31 11:54:38.112000 2020-07-31 12:28:56.222000 successful
log backup 2020-03-22 00:17:07.634000 2020-03-22 00:17:07.641000 successful

6-- 1977214 - SAP HANA: Growing number of rowstore table versions when a persistent sequence is used.

HOST PORT NAME VALUE
hostname 30067 NUM_VERSIONS 0

7-- rowstore (1813245 - SAP HANA DB: Row store reorganization)

HOST PORT Row store Reorganization Recommended Free Space Ratio in % Allocated Size in MB Free Size in MB
hostname 30067 FALSE 39.76 4800.01 1908.6
hostname 30070 FALSE 91.68 192.01 176.05
hostname 30073 FALSE 87.19 128.01 111.62
hostname 30076 FALSE 87.19 128.01 111.62

8-- AVG daily MEM_USED compared to ALLOCATION_LIMIT_GB

DATEJ AVG_USED_GB ALLOCATION_LIMIT_GB
20201030 159 194
20201029 126 194
20201028 80 194
20201027 80 194
20201026 81 194
20201025 84 194
20201024 85 194
20201023 97 194
20201022 91 194
20201021 75 194

9-- Maximum peak used memory

Max Peak Used Memory GB
189.2

10-- daily unload sum

DATEJ SUM(CS_UNLOAD_COUNT)
20201030 0
20201029 0
20201028 0
20201027 0
20201026 0
20201025 0
20201024 0
20201023 0
20201022 0
20201021 0
20201020 0
20201019 -5

11-- top 10 table size

TABLE_NAME Memory Size Mb TOTAL_RECORD NB_PART
/SMB/SBA1_T_FILE 13259.11 357624818 1
ECLOG_DATA 5464.65 235515260 1
DOKTL 4117.98 78112443 1
D010TAB 3252.82 105042438 1
ECLOG_SCR 3122.7 127207076 1
REPOSRC 2441.5 8981405 1
D010INC 1757.25 41579285 1
SCPRVALL 1716.36 51326054 1
RSMPTEXTS 1642.27 40168786 1
E071K 1512.01 54329806 1

12-- last admission control limits

EVENT_TIME EVENT_TYPE EVENT_REASON QUEUE_WAIT_TIME CONNECTION_ID MESSAGE_TYPE STATEMENT_ID STATEMENT_HASH CPU_USAGE_RATIO MEMORY_RATIO HOST PORT

13-- last 5 Out of memory

HOST PORT TIME CONNECTION_ID STATEMENT_ID STATEMENT_HASH HEAP_MEMORY_CATEGORY MEMORY_REQUEST_SIZE MEMORY_USED_SIZE EVENT_REASON MEMORY_LIMIT_SIZE TRACEFILE_NAME

14-- Evaluation of CHECK_TABLE_CONSISTENCY results

TIMESTAMP NUM SCHEMA_NAME OBJECT_NAME OBJECT_TYPE COLUMN_NAME COUNT ERROR ERROR_MESSAGE
2020/10/29 09:24:10 1 SAPHANADB TIVBDOBJASSUSES TABLE OBJTYPE 24 5152 Inconsistency found: Inconsistent single index: inverted index iterator failed to find 24 valueIds
2020/10/29 09:24:10 1 SAPHANADB TIVBDOBJASSUSES TABLE OBJTYPE 1 5152 Inconsistency found: Inconsistent single index: inverted index references 1 invalid rows
2020/10/29 09:24:10 1 SAPHANADB TIVBDOBJASSUSES TABLE OBJTYPE 83 5152 Inconsistency found: Inconsistent single index: 83 row positions appear in index at a different position
2020/10/29 09:24:10 1 SAPHANADB TIVBDOBJASSUSES TABLE OBJTYPE 1 5152 Inconsistency found: Inconsistent single index: Checked 85 (valueId, row) pairs, but main has 84 non-null entries, and 85 in total.

15-- Check for potentially critical historic time frames

BEGIN_TIME HOST AGG TOT_CPU_PCT SYS_CPU_PCT MEM_USED_PCT UNLOADS SWAP_IN_MB PING_MS VERS_M LOAD_GAP_S PEND_SESS WAIT_THR BLK_TRANS REJECTS D_RD_PCT D_WR_PCT L_WR_PCT
2020/10/19 15:56:00 hostname AVG 4 0 13 0 0.00 7 0 * 25673 0 -1 -1 0 0 0 0
2020/10/15 15:42:00 hostname AVG -1 -1 * 100 0 0.00 -1 0 10 0 -1 -1 -1 0 0 0
2020/10/15 15:19:00 hostname AVG 4 0 19 0 0.00 8 0 * 13077 0 -1 -1 0 0 0 0
2020/10/14 17:33:00 hostname AVG -1 -1 * 100 0 0.00 -1 0 10 0 -1 -1 -1 0 0 0
2020/10/14 15:49:00 hostname AVG 2 0 11 0 0.00 5 0 * 47449 0 -1 -1 0 0 0 0
2020/10/08 14:42:00 hostname AVG 0 -1 30 0 0.00 10 0 * 44510 0 -1 -1 0 0 0 0
2020/10/06 19:26:00 hostname AVG 29 2 22 0 0.00 55 0 10 0 -1 -1 0 * 64 46 0
2020/10/06 10:17:00 hostname AVG -1 -1 * 100 0 0.00 -1 0 * 311048 0 -1 -1 -1 0 0 0

16-- Overview of out of memory (OOM) situations

OOM_TIME HOST PORT CONN_ID STATEMENT_HASH STATEMENT_ID NUM_OOMS MEM_REQ_GB MEM_USED_GB MEM_LIMIT_GB EVENT_REASON TRACEFILE_NAME

17-- Memory overview

NAME TOTAL_GB DETAIL_GB DETAIL2_GB
License memory limit 600
Physical memory (available) 378 378 (hostname)
Physical memory (used) 223 223 (hostname)
Global allocation limit 194 194 (hostname)
HANA instance memory (allocated) 194 194 (hostname)
HANA instance memory (peak used) 174 174 (hostname)
HANA instance memory (used) 160 160 (hostname)
HANA shared memory 12 12 (hostname)
HANA heap memory (used) 142 142 (hostname) 41 (Pool/ColumnStore/Main/Dictionary/RoDict)
9 (Pool/ColumnStore/Main/Index/PageableSingle)
9 (Pool/ColumnStore/System)
9 (Pool/ColumnStore/Main/Index/Single)
9 (Pool/PersistenceManager/UnifiedTableContainer)
8 (Pool/ColumnStore/Main/Rowid)
7 (Pool/ColumnStore/Main/Uncompressed)
7 (Pool/PersistenceManager/PersistentSpace/DefaultLPA/DataPage)
7 (Pool/ColumnStore/Main/Compressed/Indirect)
3 (Pool/ColumnStore/Delta)
Column store size 97 97 (hostname) 13 (/SMB/SBA1_T_FILE)
5 (ECLOG_DATA)
4 (DOKTL)
3 (D010TAB)
3 (ECLOG_SCR)
2 (REPOSRC)
2 (D010INC)
2 (SCPRVALL)
2 (RSMPTEXTS)
1 (E071K)
Row store size 6 3 (hostname) 1 (CS_COLUMNS_)
Disk size 201 201 (global) 37 (FPLAYOUTT)
31 (REPOLOAD)
10 (REPOSRC)
9 (/SMB/SBA1_T_FILE)
6 (/SMB/CONT_REF)
6 (REPOTEXT)
4 (ECLOG_DATA)
4 (DDNTF)
4 (DOKTL)
3 (OBJECT_HISTORY)

18-- General SAP HANA checks

CHID DESCRIPTION HOST VALUE EXPECTED_VALUE C SAP_NOTE
**** SAP HANA MINI CHECKS 1999993
M0006 Mini check version 2.00.040+ / 2.5.25 (2020/10/23)
M0007 Configured time intervals (days) short-term: 1, mid-term: 7, long-term: 31
M0010 Analysis date 2020/10/30 11:42:53 (CET)
M0011 Database name VX1
M0012 Revision level 52.00 >= 43.00 2378962
M0013 Version 2.0 2378962
M0110 Everything started yes yes 2177064
M0111 Host startup time variation (s) 0 <= 600 2177064
M0115 Service startup time variation (s) hostname 103384 <= 600 X 2177064
**** OPERATING SYSTEM
M0207 Recommended bigmem kernel flavor not used no no 2240716
M0208 Supported operating system hostname yes yes 2235581
M0209 Recommended operating system kernel version hostname yes yes 2235581
M0211 Hosts with varying CPU rates no no 2235581
M0215 Hosts with outdated CPU type 1 0 X 2399995
M0220 Current CPU utilization (%) hostname 45 <= 80 2100040
M0221 Peak CPU utilization (%, short-term) hostname 73 <= 90 2100040
M0222 Time since CPU utilization > 95 % (h) hostname 0.29 >= 12.00 X 2100040
M0226 Peak system CPU utilization (%, short-term) hostname 39 <= 30 X 2100040
M0227 External CPU utilization (%, short-term) hostname 7 <= 10 2100040
M0228 Erroneous system CPU calculation hostname no no 2222110
M0229 Discrepancy between NUMA nodes and sockets no no 2470289
M0232 Hyperthreading active in critical context no no 2711650
M0233 NUMA nodes with high CPU utilization none none 2470289
M0234 CPU steal share (%) 0.00 <= 10.00 2100040
M0235 Hosts with varying physical memory size no no 1999997
M0236 CPU threads per NUMA node variation (%) hostname 0 <= 50 2470289
M0242 Swap out (GB / day, mid-term) hostname 0.00 <= 10.00 1999997
M0245 Swap space size (GB) hostname 0.00 <= 35.00 1999997
M0250 Max. used disk size (%) hostname 58 <= 80 1870858
M0260 Open files limit configured hostname 1048576 >= 1048576 2600030
M0261 Open files limit used (%, current) 0.05 <= 50.00 2600030
M0262 Max. open files limit used (%, long-term) 0.02 <= 60.00 2600030
M0263 Asynchronous I/O queue size limit 18446744073709551615 18446744073709551615 1868829
M0264 Virtual memory map count limit 2147483647 2147483647 1980196
M0265 Network socket backlog limit 128 >= 4096 X 2382421
M0266 Non-acknowledged requests limit 2048 >= 8192 X 2382421
M0268 Open file limit 20000000 >= 20000000 2600030
M0269 Transparent huge pages active n/a no 2131662
M0270 Unknown hardware components 0 0 1828631
M0280 Maximum time variation between hosts (s) 0 <= 5
**** DISKS
M0312 I/O read latency data max. (ms, short-term) hostname never <= 20.00 1999930
M0313 I/O read latency data avg. (ms, short-term) hostname never <= 10.00 1999930
M0314 I/O read reload throughput avg. (MB/s) hostname n/a >= 200.00 1999930
M0315 I/O write throughput data min. (MB/s, short-term) hostname 677 >= 20 1999930
M0316 I/O write throughput data avg. (MB/s, short-term) hostname 436 >= 100 1999930
M0317 I/O read activity data avg. (%, short-term) hostname 0.00 <= 30.00 1999930
M0318 I/O write activity data avg. (%, short-term) hostname 0.05 <= 50.00 1999930
M0324 I/O write activity log avg. (%, short-term) hostname 0.17 <= 50.00 1999930
M0327 I/O write latency log max. (ms, short-term) hostname never <= 20.00 1999930
M0329 I/O write latency log avg. (ms, short-term) hostname never <= 5.00 1999930
M0330 Max. trigger read ratio (data) hostname 0.00 <= 0.50 1930979
M0331 Max. trigger write ratio (data, log) hostname 0.01 <= 0.50 1930979
M0340 Log switch wait count ratio (%) hostname 0 <= 1 2215131
M0341 Log switch race count ratio (%) hostname 0 <= 1 2215131
M0346 Long waitForLock savepoint phases (short-term) 0 0 2100009
M0348 Long critical savepoint phases (short-term) 0 0 2100009
M0351 Blocking savepoint phase avg. (s, short-term) 0.00 <= 2.00 2100009
M0355 Time since last savepoint (s) hostname 11 <= 900 2100009
M0357 Savepoint write throughput (MB/s, mid-term) hostname 316 >= 100 2100009
M0358 Savepoints taking longer than 900 s (short-term) 0 0 2100009
M0360 Number of failed I/O reads hostname 0 0 1999930
M0361 Number of failed I/O writes hostname 0 0 1999930
M0363 Redo log generation (TB / day, mid-term) n/a <= 2.00 1999930
M0364 Redo log per day vs. data (%, mid-term) n/a <= 20.00 1999930
M0367 Filesystems with unsupported types 0 0 1999930
M0370 Unused space in data files (%) hostname 12 <= 50 1870858
M0371 Unused space in packed LOBs vs. data (%) 2.12 <= 7.00 2220627
M0372 Unused space in file LOBs vs. data (%) 5.02 <= 7.00 2220627
M0373 Tables with many small file LOBs none none 2220627
M0374 Tables with many disk LOBs none none 2220627
M0380 Age of oldest backup snapshot (days) n/a <= 2.00 2100009
M0381 Age of oldest fallback snapshot (days) n/a <= 28.00 2100009
M0383 Max. size of shadow pages (GB, short-term) hostname 1.68 <= 200.00 2100009
M0385 Savepoint vol. per day vs. data (%, mid-term) 6.78 <= 150.00 2100009
M0386 Max. savepoint prepare flush retries (short-term) 3 <= 500 2100009
M0387 Avg. savepoint prepare flush retries (short-term) 2.95 <= 10.00 2100009
**** MEMORY
M0410 Current allocation limit used (%) hostname 82 <= 80 X 1999997
M0411 Current allocation limit used by tables (%) hostname 53 <= 50 X 1999997
M0413 Time since allocation limit used > 80 % (h) hostname 0 >= 24 X 1999997
M0415 Curr. max. service allocation limit used (%) hostname 81 <= 80 X 1999997
M0417 Time since service alloc. limit used > 80 % (h) hostname 0 >= 24 X 1999997
M0420 Large heap allocators (current) none none 1999997
M0421 Large heap allocators (short-term) none none 1999997
M0422 Large heap allocators (long-term) none none 1999997
M0423 Heap areas with potential memory leak none none 1999997
M0425 Pool/RowEngine/CpbTree leak size (GB) 0.07 <= 20.00 1999997
M0426 Row store table leak size (GB) 0.00 <= 20.00 2362759
M0430 Number of low memory unloads (short-term) 0 0 2127458
M0435 Number of shrink unloads (short-term) 0 <= 1000 2127458
M0437 Size of unloaded columns (% / day, long-term) 0.73 <= 3.00 2127458
M0438 Memory reclaim activity (s / day) hostname 2 <= 1200 1999997
M0439 Memory reclaim maximum duration (s) hostname 2 <= 60 1999997
M0440 Topology shared memory utilization (%) hostname 1 <= 70 1977101
M0445 Number of OOM events (short-term) 0 0 1999997
M0450 Tables with memory LOBs > 2 GB 0 0 1994962
M0452 Size of unique indexes (%) 18.73 <= 15.00 X 2160391
M0454 Size of non-unique concat attributes (%) 0.02 <= 5.00 1986747
M0455 Unused large non-unique concat attributes none none 1986747
M0460 Calc engine cache utilization (%) 0 <= 70 2000002
M0462 Caches with large size none none 2502256
M0470 Heap allocators with many instantiations none none 1999997
M0472 Booked vs. allocated memory (%) n/a <= 200 1999997
M0480 Address space utilization (%) hostname 0 <= 80 1999997
**** TABLES
M0510 Tables with > 100 partitions 0 0 2044468
M0511 Tables with many columns none none 1999997
M0512 Hash partitioning on multiple columns n/a 0 2044468
M0515 Partitioned tables with inverted hash indexes 0 0 2436619
M0519 Tables with large overflow partition none none 2044468
M0520 Tables / partitions > 1.5 billion rows 0 0 1921694
M0521 Table histories > 1.5 billion rows 0 0 1921694
M0522 Tables / partitions > 1.5 billion UDIV rows 0 0 2112604
M0523 Columns with many distinct text tokens none none 2154870
M0525 Tables / partitions with large memory size none none 2044468
M0526 Tables / partitions with large memory share /SMB/SBA1_T_FILE (7 %) none X 2044468
M0530 Row store size (GB) hostname 6 <= 300 2050579
M0533 Row store tables with more than 1 container 1 0 X 2000002
M0535 Row store fragmentation (%) none <= 30 1813245
M0537 Tables with long total merge time (short-term) none none 2057046
M0538 Delta merges > 900 s (short-term) 0 0 2057046
M0540 Failing delta merges (infos / day, short-term) hostname 0 <= 5000 2057046
M0541 Failing delta merges (errors / day, short-term) hostname 0 0 2057046
M0542 Auto merge tables with delta storage > 5 GB none none 2057046
M0543 Auto merge tables with many delta records none none 2057046
M0544 Non-auto merge tables with delta storage > 5 GB none none 2057046
M0545 Non-auto merge tables with many delta records none none 2057046
M0547 Non BW tables with disabled auto merge 0 0 2057046
M0548 Tables with disabled persistent merge 0 0 2057046
M0549 Non BW tables with disabled auto compression 0 0 2112604
M0550 Row store tables with ST_POINT columns 0 0 2038897
M0551 Proper setup of timezone table TTZZ no yes X 1791342
M0552 Number of current timezone alerts 2 0 X 1791342
M0553 Hard / forced merge duration (s, mid-term) 0 <= 500 2057046
M0559 Paged columns with old persistence format 0 0 2771956
M0560 Tables > 10 Mio. rows not compressed 0 0 2105761
M0561 Columns > 10 Mio. rows not compressed 0 <= 10 2112604
M0562 Columns with missing inverted indexes 0 0 2160391
M0563 Indexes on large SPARSE / PREFIXED columns 0 0 2112604
M0565 Tables > 10 Mio. rows and > 200 % UDIV rows 0 0 2112604
M0570 Number of temporary tables 9067 <= 100000 2800007
M0572 Number of no logging tables 3 <= 7000 2800007
M0573 Translation table cache utilization (%) 2.40 <= 80.00 1998599
M0574 Tables with small unused retention period 0 0 2127458
M0575 Tables with disabled delta logging (current) 0 0 1999930
M0576 Tables with disabled delta logging (long-term) 0 0 1999930
M0580 Tables assigned to wrong service 0 0
M0582 Tables with empty table location 0 0
**** TRACES, DUMPS AND LOGS
M0610 Kernel profiler configured no no 1804811
M0611 Memory profiler active no no 1999997
M0612 Performance trace enabled no no 1787489
M0613 Function profiler enabled no no 1787489
M0623 Traced expensive statements / day (short-term) 1046 <= 5000 2180165
M0624 Expensive statements trace retention (days) hostname 4.39 >= 7.00 X 2180165
M0638 Number of backup log files 1 >= 1 2797078
M0640 Number of trace files (total) hostname 75 <= 200 2119087
M0641 Number of trace files / day (short-term) hostname 18 <= 30 2119087
M0642 Size of trace files (GB, total) hostname 0.44 <= 6.00 2119087
M0643 Size of trace files / day (GB, short-term) hostname 0.12 <= 1.00 2119087
M0644 Size of largest trace file (MB) hostname 31.81 <= 50.00 2119087
M0645 Number of OOM trace files (short-term) hostname 0 0 1999997
M0646 Number of statement OOM trace files (short-term) hostname 0 0 1999997
M0650 Number of crash dumps (short-term) hostname 0 0 2177064
M0652 Number of page dumps (short-term) hostname 0 0 1977242
M0655 Number of RTE dumps (short-term) hostname 0 0 2119087
M0658 Time since last dump (days) n/a >= 7.00 2119087
M0661 Heap allocators with allocation stack trace none none 2222218
M0662 Heap allocators with other memory traces 0 0 2222218
M0663 Time since activated memory trace (days) n/a >= 7.00 2222218
M0670 Time since last trace file modification (s) hostname 0 <= 600 2119087
**** STATISTICS SERVER
M0710 Open alerts (high priority) 2 0 X 2445867
M0711 Open alerts (error state) 0 0 2445867
M0712 Internal statistics server errors (short-term) 1 0 X 2147247
M0715 Number of actions not executed as expected 0 0 2147247
M0716 Number of statistics server worker threads 5 >= 1 2147247
M0717 Number of disabled actions 0 0 2113228
M0718 Number of relevant inactive actions 0 0 2147247
M0719 Number of actions with unknown state 0 0 2147247
M0720 Events not acknowledged since >= 1800 s hostname 6 <= 100 2126236
M0730 Pending e-mails older than 3 days 0 <= 100 2133799
M0735 Alerts older than 42 days 0 <= 10000 2170779
M0736 Alerts reported frequently 0 0 2147247
M0740 Time since statistics server run (s) 40 <= 3600 2147247
M0744 Total SQL cache share of statistics server (%) hostname 5.24 <= 20.00 2124112
M0745 Total size of statistics server tables (GB) 0.53 <= 30.00 2147247
M0746 Total memory share of statistics server (%) 0.27 <= 2.00 2147247
M0747 Number of zero entries in HOST_SQL_PLAN_CACHE 0 <= 1000000 2084747
M0748 History of M_CS_UNLOADS collected no no 2147247
M0749 History of M_RECORD_LOCKS collected no no 2147247
M0750 Stat. server tables with retention < 42 days 0 0 2147247
M0751 Historic thread samples save interval (s) 600 <= 600 2147247
M0755 Embedded statistics server used yes yes 2092033
M0760 Status of embedded statistics server migration done (okay) done (okay) 2092033
M0762 Stat. server DDL statements (short-term) 0 0 2883644
M0770 Number of stat. server tables not on master 0 0 2091256
M0780 Unknown entries in HOST_OBJECT_LOCK_STATISTICS 0 <= 1000000 2147247
M0781 Orphan entry for alert 32 yes no X 2803904
**** TRANSACTIONS AND THREADS
M0810 MVCC versions in row store hostname 0 <= 5000000 2169283
M0811 Max. MVCC versions in row store (short-term) hostname 3838 <= 10000000 2169283
M0812 Max. versions per record in row store hostname 0 <= 30000 2169283
M0813 Max. versions per table in row store n/a <= 1000000 2169283
M0815 Age of transaction blocking row store MVCC (s) 113 <= 10800 2169283
M0830 Active commit ID range hostname 0 <= 3000000 2169283
M0832 Max. active commit ID range (short-term) hostname 1315 <= 8000000 2169283
M0841 Oldest active update transaction current (h) 0.00 <= 3.00 2169283
M0842 Oldest active update transaction (h, long-term) 0.91 <= 24.00 2169283
M0843 Longest running statement current (h) 0.00 <= 12.00 2169283
M0844 Longest running statement (h, long-term) 1.16 <= 24.00 2169283
M0846 Table MVCC snapshot range 0 <= 8000000 2169283
M0849 Orphan disk LOBs 0 <= 15000000 2220627
M0851 Time since last CS LOB garb. coll. (days) 0.00 <= 1.20 2220627
M0852 Undo and cleanup files 0 <= 3000000 2169283
M0854 Undo and cleanup file size (GB) n/a <= 50.00 2169283
M0856 Max. undo size of current transaction (MB) 0.00 <= 500.00 2169283
M0857 Max. redo size of current transaction (MB) 0.00 <= 1000.00 2169283
M0858 Rollbacks per second (mid-term) 0.08 <= 2.00 2169283
M0860 Current pending sessions 0 <= 5
M0863 Avg. pending sessions (short-term) 0.00 <= 1.00
M0864 Admission control events (short-term) 0 <= 100 2222250
M0865 Admission control rejections (long-term) 0 0 2222250
M0866 Admission control max. queue size (long-term) 0 <= 1000 2222250
M0867 Admission control queue timeout rejections 0 0 2222250
M0870 SelfWatchDog activity time (%, short-term) 0.05 <= 2.00 1999998
M0871 Max. load history gap (s, mid-term) hostname 21 <= 90 2222110
M0878 Connections in CANCEL REQUESTED state 0 0 2169283
M0880 Open connections (%) hostname 0.09 <= 90.00 1910159
M0881 Number of transactions 87 <= 20000 2154870
M0882 Max. parked JobWorker ratio 0.76 <= 2.00 2256719
M0883 Queued JobWorker threads 74 <= 200 2222250
M0885 SqlExecutor threads with significant duration 1 <= 10 2114710
M0887 Application users with significant threads none none 2114710
M0888 JobWorker queueing share (%, short-term) 34.97 <= 15.00 X 2222250
M0890 Unusual frequent thread methods (short-term) none none 2114710
M0892 Unusual frequent thread methods (long-term) none none 2114710
**** BACKUP
M0910 Age of last data backup (days) 77.83 <= 1.20 X 1642148
M0911 Age of last data backup error (days) never >= 7.00 1642148
M0920 Age of last log backup (hours) 1867.50 <= 1.00 X 1642148
M0921 Age of last log backup error (days) never >= 1.00 1642148
M0922 Maximum log backup duration (s, short-term) n/a <= 900 2063454
M0923 Log backup errors (long-term) 0 <= 10 1642148
M0940 Size of backup catalog (MB) 0.00 <= 50.00 2505218
M0942 Catalog size share (%, short-term) n/a <= 5.00 2505218
M0945 Age of oldest backup in catalog (days) 339 28 to 150 X 2505218
M0950 Log segments not free for reuse hostname 5 <= 100 2083715
M0952 Log segments free for reuse hostname 5 <= 250 2083715
M0955 Max. log backups / service / day (short-term) n/a <= 300 2083715
M0960 Days since backup history broken none >= 31.00 1642148
**** LOCKS
M1010 Age of oldest active trans. lock wait (s) 0 <= 60 1999998
M1011 Trans. lock wait durations > 600 s (short-term) 0 0 1999998
M1020 Threads currently waiting for locks 1 <= 10 1999998
M1031 Concurrently blocked transactions (short-term) hostname 0 <= 20 1999998
M1040 Total current transactional locks 4 <= 10000000 1999998
M1045 Transactional locks older than 1 day 0 0 1999998
M1052 Significant internal lock waits (short-term) none none 1999998
M1055 Locks with repeated wait spikes (long-term) none none 1999998
**** SQL
M1110 SQL using in average > 1 connection (short-term) none none 2000002
M1113 SQL using in average > 1 thread (short-term) none none 2000002
M1118 Longest running current job (s) 0 <= 3600 2000002
M1120 Exp. stmt. trace: SQL running > 1 h (short-term) none none 2000002
M1125 Columns with many scanned records none none 2000002
M1126 Row store tables with many scanned records none none 2000002
M1129 SQL cache evictions / h (short-term) hostname 14 <= 3000 2124112
M1130 SQL cache evictions / h hostname 42 <= 3000 2124112
M1131 SQL cache hit ratio (%) hostname 99.73 >= 90.00 2124112
M1140 SQL preparation runtime share (%) hostname 0.58 <= 5.00 2124112
M1142 Tables with high SQL cache utilization hostname SAPHANADB.DD02BND(7), SAPHANADB.DD08B(8) (62 %) none X 2124112
M1143 App. sources with high SQL cache utilization hostname CL_SQL_STATEMENT==============CP:1010 (62 %) none X 2124112
M1145 SQL cache used by IN lists >= 100 elements (%) 0.15 <= 30.00 2124112
M1146 SQL cache used by multiple OR concats (%) 1.13 <= 20.00 2124112
M1147 Duplicate statement hashes in SQL cache (%) hostname 0.42 <= 20.00 2124112
M1148 Statements existing > 100 times in SQL cache 0 0 2124112
M1149 Statements with SESSION LOCAL sharing type (%) hostname 0.00 <= 1.00 2124112
M1150 Referenced statements in SQL cache (%) hostname 0.14 <= 20.00 2124112
M1152 Max. SQL contexts per connection 997 <= 5000 2000002
M1155 Number of SQL statements in SUSPENDED state 0 <= 100 2169283
M1159 Hourly max. commit I/O time avg. (ms, long-term) hostname 4.95 <= 50.00 2000000
M1160 Average commit time (ms) hostname 0.91 <= 10.00 2000000
M1161 Maximum commit I/O time (s, long-term) hostname 2.24 <= 30.00 2000000
M1162 Average commit I/O time (ms, long-term) hostname 0.57 <= 10.00 2000000
M1163 Commit vs. execution ratio (%, mid-term) n/a <= 15.00 2000000
M1164 Unexpected distributed executions 0 <= 10 2000002
M1165 Internal executions (%) 1.10 <= 20.00 2000002
M1167 Statement hints with hint string being NULL 0 0 2913308
M1168 Delivered statement hints implemented no yes X 2700051
M1169 Total number of implemented statement hints 0 <= 100 2400006
M1170 Average database request time (ms) 1.90 <= 2.00 2000002
M1180 Avg. ABAP buffer loading sessions (short-term) 0.00 <= 0.50 2000002
M1182 Avg. compatibility view sessions (short-term) 0.00 <= 0.50 2000002
**** APPLICATION
M1210 DDLOG sequence cache size 500 >= 2 2000002
M1211 DDLOG sequence number range usage (%) 0.51 <= 80.00 1312102
M1220 QCM conversion tables 0 0 9385
M1221 BW shadow tables 0 0 2155151
M1230 ABAP row store tables on slave node 0 0 2222277
M1240 Connections without application information (%) n/a <= 50.00
M1250 Physical BPC tables 0 0 2445363
M1252 Physical ABAP pool and cluster tables 0 0 1892354
M1270 Two-column indexes including client column 0 0 2160391
M1280 Growth of short dump table SNAP (GB, short-term) n/a <= 0.50 2399990
M1285 Number of update records in error state 0 <= 100
**** SECURITY 2159014
M1312 Inconsistent secure store no no 2097613
M1331 Connection user with (password) expiration none none 2159014
M1340 CATALOG READ privilege granted to current user yes yes 1640741
M1360 Size of audit log table (GB) 0.00 <= 10.00 2388483
M1362 Active DML audit policies 0 <= 30 2159014
**** LICENSE
M1410 License usage (%) 27 <= 95 1704499
M1415 License expiration (days) never >= 100 1644792
M1420 Permanent license yes yes 1644792
**** NETWORK
M1510 Avg. intra node send throughput (MB/s) hostname 251 >= 20 2222200
M1512 Avg. inter node send throughput (MB/s) hostname never >= 16 2222200
M1520 Retransmitted TCP segments (%) 0.01360 <= 1.00000 2222200
M1522 Bad TCP segments (%) 0.00000 <= 0.10000 2222200
M1524 Current network collision share (%) 0.00 <= 1.00 2222200
M1525 Current send error share (%) 0.00 <= 0.10 2222200
M1526 Current receive error share (%) 0.00 <= 0.10 2222200
M1530 Avg. intra node communication volume (MB/s) hostname 0 <= 30 2222200
M1532 Avg. inter node communication volume (MB/s) hostname 0 <= 20 2222200
M1540 Host name resolution for non IP addresses 0 0 2222200
M1550 Network Poll thread state share (%, short-term) 1.25 <= 20.00 2222200
M1551 Network Read thread state share (%, short-term) 0.02 <= 10.00 2222200
M1552 Network Write thread state share (%, short-term) 0.19 <= 10.00 2222200
**** XS ENGINE
**** NAMESERVER
M1712 Avg. load history ping time (ms, short-term) hostname 36.57 <= 400.00 2222110
**** SYSTEM REPLICATION
M1810 Services with replication error 0 0 1999880
M1811 Services with unknown replication state 0 0 1999880
M1813 Replication connection closed (short-term) no no 1999880
M1814 Log position gap (MB) n/a <= 100 2436931
M1815 Current log shipping delay (s) 0 <= 60 1999880
M1816 Filling level of async shipping buffer (%) n/a <= 50 1999880
M1818 Async log shipping buffer full (short-term) n/a 0 1999880
M1820 Parameter deviations primary vs. secondary site 0 0 1999880
M1830 Age of oldest replication snapshot (h) n/a <= 10.00 1999880
M1835 Max. initial data shipping time (h) n/a <= 24.00 1999880
M1850 System replication op. mode logreplay used yes yes 1999880
M1852 Current log replay backlog (GB) 0 <= 10 2661878
M1853 Current log replay delay (s) 0 <= 600 2661878
M1854 Max. log replay backlog (GB, long-term) 0 <= 30 2661878
M1855 Max. log replay delay (s, long-term) 0 <= 1800 2661878
M1860 Datashipping combined with log retention no no 1999880
M1861 Both delta_datashipping and logreplay used no no 1999880
M1865 System replication savepoint delay (h) n/a <= 4.00 1999880
**** OBJECTS
M1920 Number of invalid procedures 71 0 X
M1940 Sequences with insufficient caching 0 0 2600095
M1945 Cross node triggers 0 0
M1950 Columns with significant text indexing errors none none 2800008
M1952 Documents queued for fulltext indexing 0 <= 1000000 2800008
M1960 Number of calculation scenarios 2780 <= 200000
M1962 Number of temporary views 0 <= 200000
**** BW
M2010 Empty TABLE_PLACEMENT table in BW yes no X 1908075
M2020 Partitioned SID tables 0 0 2044468
M2022 SID tables > 1.5 billion rows 0 0 1331403
M2025 Partitioned special BW tables < 1.5 bill. rows 0 0 2044468
M2027 Tables with high sub-partition PARTNO none none 2002607
M2040 Temporary BW tables 1 <= 1000 2388483
M2042 BW aggregate tables 0 0 2388483
M2050 BW tables with inverted hash indexes 0 0 2109355
**** CONSISTENCY
M2110 CHECK_TABLE_CONSISTENCY errors (long-term) 0 0 1977584
M2113 Last global table consistency check (days) 1.04 <= 32.00 2116157
M2115 Tables without recent consistency check 0 0 2116157
M2116 Tables with consistency check errors 1 0 X 2116157
M2118 Table container check with load configured yes no X 2116157
M2130 Inconsistencies between topology and daemon hostname 0 0 2222249
M2135 Inconsistent node role definition in topology no no
M2140 Inconsistencies of metadata and dependencies 0 0 2498587
M2150 Missing index concat attributes 0 0 2160391
**** SMART DATA ACCESS / SMART DATA INTEGRATION
M2210 SDA tables without statistics 0 0 2180119
M2220 SDI remote subscription exceptions 0 0 2400022
M2222 SDI max. remote subscription apply delay (s) 0 <= 300 2400022
M2230 Slave nodes with dpserver processes 0 0 2391341
M2240 Avg. SDI source select sessions (short-term) 0.00 <= 0.50 2400022
M2250 Max. dpagent phys. memory consumption (%) n/a <= 80.00 2400022
**** ADMINISTRATION
M2310 SAP HANA Studio connections 14 <= 100 2073112
M2315 Connections with old SAP HANA Studio versions 0 0 2073112
M2330 Parameters set on host level hostname enable_tracking = on (hostname) none X 2186744
hostname memory_tracking = on (hostname) none X 2186744
M2332 Parameter changes requiring a SAP HANA restart none none 2186744
M2334 Unsupported parameter settings none none 2186744
M2340 Deprecated features used (long-term) REPOSITORY - API none X 2425002
**** TABLE REPLICATION
M2410 Inactive table replicas 0 0 2340450
M2415 Last table replication deactivation dump (days) never >= 7.00 2400007
**** SLT 2014562
M2510 Orphan SLT sequences 0 0 2600095
M2520 Triggers with outdated substring calculation 0 0 2399990
**** ENTERPRISE SEARCH
M2610 Orphan calculated ESH columns 22 0 X 2685716
**** END OF CHECK

19-- Security related check list

CHID DESCRIPTION VALUE EXPECTED_VALUE C SAP_NOTE
**** SAP HANA SECURITY MINI CHECKS 2159014
S0010 Analysis date 2020/10/30 11:46:52 (CET)
S0011 Database name VX1
**** USERS
S0110 CATALOG READ privilege granted to current user yes yes 1640741
S0120 SYSTEM user deactivated no yes X
S0130 Non-technical users without password lifetime BPINST none X
HRF_TECH_USER none X
SAPHANADB none X
SYSTEM none X
TECH_MONI none X
**** PRIVILEGES
S0210 Users with special privileges for production none none
S0215 Users with special privileges BPINST (ADAPTER ADMIN) none X
BPINST (AGENT ADMIN) none X
BPINST (AUDIT ADMIN) none X
BPINST (AUDIT OPERATOR) none X
BPINST (BACKUP ADMIN) none X
BPINST (BACKUP OPERATOR) none X
BPINST (CERTIFICATE ADMIN) none X
BPINST (CREATE REMOTE SOURCE) none X
BPINST (CREDENTIAL ADMIN) none X
BPINST (EXTENDED STORAGE ADMIN) none X
BPINST (INIFILE ADMIN) none X
BPINST (LICENSE ADMIN) none X
BPINST (LOG ADMIN) none X
BPINST (MONITOR ADMIN) none X
BPINST (OPTIMIZER ADMIN) none X
BPINST (RESOURCE ADMIN) none X
BPINST (SAVEPOINT ADMIN) none X
BPINST (SERVICE ADMIN) none X
BPINST (SESSION ADMIN) none X
BPINST (SSL ADMIN) none X
BPINST (TABLE ADMIN) none X
BPINST (TRUST ADMIN) none X
BPINST (VERSION ADMIN) none X
HRF_TECH_USER (INIFILE ADMIN) none X
HRF_TECH_USER (SERVICE ADMIN) none X
SAPHANADB (BACKUP ADMIN) none X
SAPHANADB (INIFILE ADMIN) none X
SAPHANADB (LICENSE ADMIN) none X
SAPHANADB (OPTIMIZER ADMIN) none X
SAPHANADB (RESOURCE ADMIN) none X
SAPHANADB (SAVEPOINT ADMIN) none X
SAPHANADB (SERVICE ADMIN) none X
SAPHANADB (TABLE ADMIN) none X
SYSTEM (ADAPTER ADMIN) none X
SYSTEM (AGENT ADMIN) none X
SYSTEM (AUDIT ADMIN) none X
SYSTEM (AUDIT OPERATOR) none X
SYSTEM (BACKUP ADMIN) none X
SYSTEM (BACKUP OPERATOR) none X
SYSTEM (CERTIFICATE ADMIN) none X
SYSTEM (CREATE REMOTE SOURCE) none X
SYSTEM (CREDENTIAL ADMIN) none X
SYSTEM (EXTENDED STORAGE ADMIN) none X
SYSTEM (INIFILE ADMIN) none X
SYSTEM (LICENSE ADMIN) none X
SYSTEM (LOG ADMIN) none X
SYSTEM (MONITOR ADMIN) none X
SYSTEM (OPTIMIZER ADMIN) none X
SYSTEM (RESOURCE ADMIN) none X
SYSTEM (SAVEPOINT ADMIN) none X
SYSTEM (SERVICE ADMIN) none X
SYSTEM (SESSION ADMIN) none X
SYSTEM (SSL ADMIN) none X
SYSTEM (TABLE ADMIN) none X
SYSTEM (TRUST ADMIN) none X
SYSTEM (VERSION ADMIN) none X
S0220 Users with critical privilege combinations BPINST (AUDIT ADMIN / AUDIT OPERATOR) none X
BPINST (CREATE SCENARIO / SCENARIO ADMIN) none X
BPINST (CREATE STRUCTURED PRIVILEGE / STRUCTUREDPRIVILEGE ADMIN) none X
BPINST (USER ADMIN / ROLE ADMIN) none X
SAPHANADB (CREATE SCENARIO / SCENARIO ADMIN) none X
SAPHANADB (CREATE STRUCTURED PRIVILEGE / STRUCTUREDPRIVILEGE ADMIN) none X
SYSTEM (AUDIT ADMIN / AUDIT OPERATOR) none X
SYSTEM (CREATE SCENARIO / SCENARIO ADMIN) none X
SYSTEM (CREATE STRUCTURED PRIVILEGE / STRUCTUREDPRIVILEGE ADMIN) none X
SYSTEM (USER ADMIN / ROLE ADMIN) none X
S0230 DATA ADMIN privilege granted to users or roles BPINST no X 863362
S0231 DEVELOPMENT privilege granted to users or roles ABAP_DEV no X
BPINST no X
S0232 DEBUG privilege granted to users or roles BPINST no X
HRF_TECH_USER no X
_SYS_REPO no X
S0233 ATTACH_DEBUGGER priv. granted to users or roles no no
S0240 _SYS_BI_CP_ALL priv. granted to users or roles ABAP_DEV no X
BPINST no X
HRF_TECH_USER no X
SAPHANADB no X
USER no X
_SYS_REPO no X
sap.hrf.role.model::HRF_TECH_ROLE no X
sap.hrf.role.model::HrfAdmin no X
**** ROLES
S0310 CONTENT_ADMIN role granted to users or roles ABAP_DEV no X
BPINST no X
USER no X
S0311 MODELING role granted in production no no
S0312 Users with granted AFL roles none no
S0329 SAP_INTERNAL_HANA_SUPPORT granted no no
**** NETWORK
S0410 Global listeninterface configured no no 2222200
S0412 Global sys. rep. listeninterface configured no no 2222200
**** ENCRYPTION
S0510 SSFS instance master key still initial no no
S0512 SSFS system PKI master key still initial no no
S0520 Data volume encryption enabled no yes X
**** FILE SYSTEM
S0610 Adjusted file security settings no no
S0620 Users with EXPORT or IMPORT privilege 5 <= 5
**** AUDITING
S0710 Global auditing state activated no yes X
S0712 Activated audit policies 0 >= 1 X
S0720 Default audit trail type CSTABLE not CSVTEXTFILE 863362
S0723 Audit policies with trail type CSV none none
**** TRACES
S0810 Traces configured on debug level none none
S0815 SQL trace including results configured no no 863362
S0820 Runtime dumps older than 42 days 0 0
**** MULTITENANT
S0910 Disabled customizable functionalities in MDC 1 >= 1
**** AUTHENTICATION
S1010 Adjusted authentication methods no yes X
S1020 Users with LDAP authentication without SSL 0 0
**** END OF CHECK

script executed on hostname.
Rodolphe