본문 바로가기

Database

 (103)
[HANA] Scale-out Workshop with SAP (3/3) 보호되어 있는 글입니다.
[HANA] Group지정 및 Table 위치 지정 그룹관리 그룹의 위치 지정 ALTER SYSTEM ALTER TABLE PLACEMENT (SCHEMA_NAME => 'SAPABAP1', GROUP_NAME => 'USR_CUST') SET (LOCATION => 'slave#1'); 그룹 지정 제거 ALTER SYSTEM ALTER TABLE PLACEMENT (SCHEMA_NAME => 'SAPABAP1') UNSET; 그룹 기본 위치 지정 ALTER SYSTEM ALTER TABLE PLACEMENT (SCHEMA_NAME => 'SAPABAP1') SET (LOCATION => 'master'); OSTR 기본 위치 지정 ALTER SYSTEM ALTER TABLE PLACEMENT (SCHEMA_NAME => 'SAPABAP1', GROUP_..
[HANA] Table Replication - 출처 : https://help.sap.com/viewer/6b94445c94ae495c83a19646e7c3fd56/2.0.04/en-US/59244f4e0c8d437db363e37dfeacac68.html SAP Help Portal help.sap.com Table replication In a scale-out system tables (or selected columns of column store tables) may be replicated to multiple hosts. Sysnchronous and Asynchronous Replication 장단점 비교 Optimistic Synchronous Table Replication (OSTR)Asynchronous Table Replic..
[HANA] Table Replacement - 출처 : https://help.sap.com/viewer/6b94445c94ae495c83a19646e7c3fd56/2.0.04/en-US/22888f9344954f258284d2dd936d0d0a.html SAP Help Portal help.sap.com Table Placement Table Classification and Placement Rules Rule은 SYS.TABLE_PLACEMENT에 정의됨 기본적으로 다음 영역에서 얘기됨 - Classification : 관련된 테이블들은 동일한 Group에 위치 - 파티션을 관리하기 위한 Configuration 설정 (초기에 몇개의 파티션, Split하는 기준 등) - 테이블이나 파티션의 서버 landscape 내에서의 물리적 분산 및 위..
[HANA] Scale-out Workshop with SAP (2/3) 보호되어 있는 글입니다.
[HANA] Scale-out Workshop with SAP (1/3) 보호되어 있는 글입니다.
[HANA] 2780767 - Hesitantly locking Delta Merge and Optimize Compression Delta merge의 성능 영향도를 줄이기 위해 1. Hesitantly locking 사용 2. Partition 조정 https://launchpad.support.sap.com/#/notes/2780767 https://launchpad.support.sap.com/#/notes/2780767 launchpad.support.sap.com 2780767 - Hesitantly Locking Delta Merge and Optimize Compression Version 7 from 2020.02.11 in EnglishShow Changes DescriptionSoftware Components References Languages Symptom Lock contention during exclu..
[HANA] (Embedded Statistics Service) HOST_LOAD_HISTORY_SERVICE View - Reference : https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.04/en-US/8ed14f3ad2124d99a13475407acf2a01.html SAP Help Portal help.sap.com This view contains information only for the last 42 days. The collection interval is 3600 seconds. -> 10초별 데이터 쌓임 Structure Column nameData typeDescription SNAPSHOT_ID TIMESTAMP Timestamp ID (UTC) SERVER_TIMESTAMP TIMESTAMP Processing Timestam..

티스토리툴바