본문 바로가기

분류 전체보기

 (200)
[HANA] Admission control 2019/05/06 - [Database] - [HANA] 2222250 - FAQ: SAP HANA workload Management 2019/05/01 - [Database] - [HANA] Workload Management (internal) Overview Load 정도를 위한 임계치 설정 Host CPU Used memory / memory limit (GAL) Overload protextion behaviors Queueing incomming requests Rejecting incomming requests 예외 Admin-privileged session (예. SESSION_ADMIN, WORKLOAD_ADMIN 등) 자원의 소비를 줄이도록 도와주는 요청 들 (예. Commit, ..
[HANA] 2222250 - FAQ: SAP HANA workload Management * https://launchpad.support.sap.com/#/notes/2222250 https://launchpad.support.sap.com/#/notes/2222250 launchpad.support.sap.com What is SAP HANA workload HANA에서의 Workload OLAP workload - BW system OLTP workload - transactions in an ERP system Mixed workload - both OLAP and OLTP = modern ERP system Internal workload - merges, backups and savepoints 병목이 될 수 있는 resource Memory CPU and threads Netwo..
[HANA] Trouble shooting - Version GC Issue GC Blocker 찾기 GC를 blocking하고 있는 Statement와 connection을 찾아야 함 Statement Library MVCC Blocker Connection MVCC Blocker Statement MVCC Blocker Transaction Connection ID, Statement 확인 필요 (Example) MVCC Blocker Statemen Type = GLOBAL - Global version garbage collection blocker = TABLE - The specific table의 garbage collecton blocker TABLE의 GC blocker에 의한 Timestamp가 Global timestamp보다 낮음 수행 후 바로 TABLE t..
[HANA] Trouble shooting - MVCC Issue MVCC Problem Identification Transactions blocking garbage collection은 다음으로부터 발생 가능 Long-running or unclosed cursor Long-running trancation with isolation mode 'serializable' or 'repeatable read' Hanging threads MVCC 관련 문제가 있는지 확인 위해 active version 수를 확인 해야 함 select * from m_mvcc_tables where name in ('NUM_VERSIONS','MAX_VERSIONS_PER_RECORD','TABLE_ID_OF_MAX_NUM_VERSIONS'); -> NUM_VERSIONS and MA..
[Linux] sar 사용예 1. CPU 사용률 (오늘) sar [root@zetawiki ~]# sar Linux 2.6.32.59-0.7-xen (jmnote) 10/24/12 _x86_64_ 00:00:01 CPU %user %nice %system %iowait %steal %idle 00:10:01 all 20.63 0.00 11.65 2.17 0.08 65.46 00:20:01 all 9.32 0.00 4.34 1.99 0.05 84.30 00:30:01 all 11.32 0.00 6.61 1.17 0.13 80.77 ... (생략) Average: all 10.28 0.00 6.03 2.03 0.12 81.53 → 00시부터 현재까지 10분마다 CPU 사용률 측정한 기록을 보여준다.[1] 2. CPU 사용률 (날짜별) ..
[HANA] Workload Management (internal) 보호되어 있는 글입니다.
[HANA] HANA DB Trace Trace Structure Trace entries ([_] 공백으로 구분) []{}[/] :
[Python] File I/O Printing to the Screen The simplest way to produce output is using the print statement where you can pass zero or more expressions separated by commas. This function converts the expressions you pass into a string and writes the result to standard output as follows Reading Keyboard Input Python provides two built-in functions to read a line of text from standard input, which by default comes fro..

티스토리툴바