분류 전체보기 (200) 썸네일형 리스트형 [HANA] hdbsql options SAP HANA HDBSQL Options Set information for the database and for database objects by using SAP HANA HDBSQL commands. In addition to SAP HANA HDBSQL commands, you can also enter an SQL statement or a database procedure. The statement or procedure must be enclosed in quotation marks. Configuration Options Use the following options to modify the operation of SAP HANA HDBSQL commands. Database Sessi.. [HANA] Database trace설정 (savepoint) 설정 방법 HANA Studio -> Administator -> Trace Configuration -> Database Trace Component = savepoint 선택 Trace Level = 'INFO' -> 'DEBUG'로 변경하여 ON Savepoint Trace 예시 == Trace 미설정 상태 [620581]{-1}[-1/-1] 2019-07-12 08:49:07.030953 i Savepoint SavepointImpl.cpp(02995) : Savepoint current savepoint version: 11954, restart redo log position: 0xa90f2a482, next savepoint version: 11955, last snapshot SP vers.. [HANA] Memory GC Trigger 관련 파라미터 https://launchpad.support.sap.com/#/notes/2169283 Memory Garbage collection Auto Trigger 시점 관련 Parameter global.ini -> [memorymanager] -> async_free_target Default = 95 % Trigger 되면 할당된 메모리를 global allocation limit의 특정 비율(aync_free_target) 만큼 줄임 global.ini -> [memorymanager] -> async_free_threshold Default = 100 % global allocation limit의 특정 비율(async_free_threshold) 만큼 도달하면 proactive Memory GC가 .. [HANA] NUMA Node를 user-specific하게 지정하는 방법 == 현황 조회 hdbsql TMP=> select schema_name, table_name, column_name, NUMA_NODE_INDEXES from table_columns where table_name = 'CUSTOMER1TST' and column_name = 'C_ZIP'; | SCHEM | TABLE_NAME | COLUM | N | | ----- | ------------ | ----- | - | | BENCH | CUSTOMER1TST | C_ZIP | ? | 1 row selected (overall time 103.392 msec; server time 803 usec) hdbsql TMP=> select schema_name, table_name, column_name, n.. [HANA] 2470289 - FAQ: SAP HANA Non-Uniform Memory Access (NUMA) https://launchpad.support.sap.com/#/notes/2470289 NUMA Node overview Concept Memory architecture of multi-processor systems where a certain amount of memory is assigned to every processor, but other CPUs are also able to access it (Distributed shared memory) Accessing locally assigned memory is faster than accessing memory assigned to a differenct CPU HANA 1.0 SPS10 부터 NUMA-aware NUMA configurat.. [HANA] 2114710 - FAQ: SAP HANA Threads and Thread Samples https://launchpad.support.sap.com/#/notes/2114710 Thread Overview Threads description The SAP HANA work, like executing of SQL statements or background tasks is performed by threads Each SAP HANA process like indexserver or xsengine consists of a set of threads Information about historic thread activityes are available Monitoring view M_SERVICE_THREAD_SAMPLES .ini -> [resource_tracting] -> servi.. [HANA] HSR 구성 보호되어 있는 글입니다. [HANA] Insert Only Operation 보호되어 있는 글입니다. 이전 1 ··· 16 17 18 19 20 21 22 ··· 25 다음