본문 바로가기

분류 전체보기

 (200)
[Python] 모니터링 구현을 위한 소켓통신 소켓통신 적용 Client Side OS 및 DB의 현황을 Gathering해서 Server쪽으로 TCP-통신을 통해서 전달 Server Side Client로부터 들어오는 Socket을 받아서 처리 1:1 통신에서는 간단하게 처리 되지만 N:1으로 처리하기 위해서 Threading 사용 필요 받은 데이터는 DB (Sqlite3)에 저장하는 기능 구현
[HANA] Trace file 통합 확인 보호되어 있는 글입니다.
[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) 보호되어 있는 글입니다.

티스토리툴바