본문 바로가기

전체 글

 (198)
[HANA] Scale-out Table replication Table Replication OSTR설정 -- Replicate 수행 alter table bench.a7 add synchronous replica at 'hana1-slave:30003'; -- 현황 조회 select * from m_table_locations where schema_name = 'BENCH'; select * from m_table_replicas; 시나리오> Table Replicate 수행 OSTR 삭제 -- Replica 삭제 alter table bench.a7 drop replica at all locations; -- 상태 확인 select * from m_table_locations where schema_name = 'BENCH'; select * from m_t..
[HANA] Scale-out table relocation TABLE GROUP 지정 USER의 GROUP NAME별 위치 지정 BENCH / GRP_M - Master / GRP_S - Slave Command -- User별 Default Location 지정 ALTER SYSTEM ALTER TABLE PLACEMENT (SCHEMA_NAME => 'BENCH') SET(LOCATION=>'master'); -- User - GROUP별 Default Location 지정 ALTER SYSTEM ALTER TABLE PLACEMENT (SCHEMA_NAME => 'BENCH', GROUP_NAME => 'GRP_M') SET(LOCATION=>'master'); ALTER SYSTEM ALTER TABLE PLACEMENT (SCHEMA_NAME => 'B..
[HANA] Load 측정 KPI - Current Load Current Load select left(now()||'',19) Time , m_t_running , m_t_nw_poll , m_t_jobexec_wait , m_t_mutex_wait , m_t_exlock_enter , m_t_semaphore_wait , m_t_shlock_enter , m_t_joining , m_t_intentlockenter , m_t_all - (m_t_running+m_t_nw_poll+m_t_jobexec_wait+m_t_mutex_wait+m_t_exlock_enter+m_t_semaphore_wait+m_t_shlock_enter+m_t_joining+m_t_intentlockenter) m_t_other , s_t_running , s_t_nw_poll , ..
[HANA] Load 측정 KPI - Load History Load History with raw as ( select a.timemi , a.host -- 1. Host , a.host_cpu_util , a.host_mem_resd_mb , a.host_mem_tot_resd_mb , a.host_mem_usd_mb , a.host_mem_alloc_lim_mb , a.host_mem_sz_mb , a.host_swap_in_mb_sum , a.host_swap_out_mb_sum , a.host_disk_sz_mb , a.host_disk_usd_mb , a.host_nw_in_mb_sum , a.host_nw_out_mb_sum -- 2. Service , b.cpu_util , b.system_cpu_util , b.used_mem_mb , b.mall..
[HANA] 2491748 - How-To: Analyzing Runtime Dumps with SAP HANADumpViewer 출처 : https://launchpad.support.sap.com/#/notes/2491748 https://launchpad.support.sap.com/#/notes/2491748 launchpad.support.sap.com 2491748 - How-To: Analyzing Runtime Dumps with SAP HANADumpViewer Symptom You are interested in analyzing SAP HANA runtime dumps Environment SAP HANA Cause Attention: The SAP HANADumpViewer functionality is now fully integrated in the more comprehensive SAP HANA Dump..
[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..

티스토리툴바