GBase8s數(shù)據(jù)庫監(jiān)控指標

指標分類 指標名稱系統(tǒng)類指CPUBusyRateOSCPU CPUBusyCPUBusyCPUI/OWaitOSMemoryPageInOSMemoryPage

指標說明CPU繁忙率CPUCPUCPUI/O內存頁換出

采集方式sigarsigarsigarsigar系統(tǒng)命令系統(tǒng)命令

相關命令sigar.getCpuPercList();sigar.getCpuPercList();sigar.getCpuPercList();sigar.getCpuPercList();vmstat-s|greppagevmstat-s|greppageOSMemory

OSFreePhysicalMemory空閑物理內存

sigar

sigar.getMem().getActualFree()BufferReadCacheBufferWriteCacheBufferWaits/SecDISKI/OBusy

內存等待率磁盤繁忙率

vmstat對應cachevmstat對應buff取%utiliostat–d–x–k取%utiliostat–d–x–k取%util取平均值11iostat–d–x–k取%util取最大值11iostat–d–x–k取await11iostat–d–x–k取await取平均值11DISKI/OBusy磁盤繁忙率平均OSDisk DISKI/OBusy磁盤繁忙率最大

系統(tǒng)命令系統(tǒng)命令DiskI/OWaitDiskI/O

IO磁盤等待平均值

系統(tǒng)命令系統(tǒng)命令DiskI/OWait（Max）DiskReads（Kb/Sec）DiskWrites（Kb/Sec）DiskReads/Writes（Kb/Sec）

磁盤等待最大值系統(tǒng)命令磁盤每秒讀取字節(jié)數(shù)系統(tǒng)命令硬盤每秒寫入字節(jié)數(shù)系統(tǒng)命令磁盤讀寫速度系統(tǒng)命令iostat–d–x–k取await取最大值iostat–d–x–k取await取最大值11iostat–d–x–k取rkB/s11iostat–d–x–k取wkB/s11上面兩個之和NetworkReceivingQueueOSConnectionNetworkConnections

系統(tǒng)平均負載網(wǎng)絡接收速度（Kb/sec）當前網(wǎng)絡連接數(shù)

系統(tǒng)命令sigar系統(tǒng)命令

系統(tǒng)命令uptime取值：loadaverage:0.14,0.38,0.25sigar接口netstat-nat|grepESTABLISHED|wc-lNetworkConnectionWait當前等待連接數(shù)

系統(tǒng)命令

netstat|grepTIME_WAIT|wc-lDBVPDBMemory

數(shù)據(jù)庫指標DBVPBusyRateDBVPBusyRate（Avg）VPQueueDBVirtualMemoryAllocation

數(shù)據(jù)庫VP的繁忙率SQL/命令數(shù)據(jù)庫VP的繁忙率SQL/命令（平均值）數(shù)據(jù)庫VP的等待隊列命令數(shù)數(shù)據(jù)庫虛擬內存分配命令數(shù)量

onstat-gonstat-gonstat-gonstat-gDBVirtualMemoryUtillizationDBPageReadsDBPageWrites

數(shù)據(jù)庫虛擬內存使用量數(shù)據(jù)庫中DBPage的Reads數(shù)數(shù)據(jù)庫中DBPage的Writes數(shù)

命令SQL/命令SQL/命令

onstat-gsegDBDiskReadsDBDisk

數(shù)據(jù)中磁盤read數(shù)SQL/命令onstat-p【其中的pagreads值】onstat-ponstat-p【其中的pagreads值】onstat-p【其中的pagwrits值】onstat-p【其中的dskreads值】onstat-p【其中的dskwrits值】DBDisk

DBSpacePageReads

數(shù)據(jù)庫中每個DBSpacePage的ReadsSQL/數(shù)數(shù)據(jù)庫中每個DBSpacePage

DBSpacePageWrites

SQL/命令數(shù)據(jù)庫中每個DBSpaceUtilization 命令 onstatDBSpace使用率ActiveSQLAP DBTransactionLockRequests

數(shù)據(jù)庫中活動的SQL命令數(shù)數(shù)據(jù)庫執(zhí)行的事務數(shù)SQL/命令數(shù)據(jù)庫中的鎖請求數(shù)SQL/命令

onstat-gsql【sqlstmttype不為空的onstat-p 【其中的commit+rollbk值】onstat-p 【其中的lockreqs值】ActiveLocksDBCommits

數(shù)據(jù)庫中當前活動的鎖數(shù)數(shù)據(jù)庫中提交的事務數(shù)

SQL/SQL/

onstat-k取最后一行的數(shù)量onstat-p 【其中的commit以下為即時采集功能（頁面添加定時刷新）TopBusy

數(shù)據(jù)庫中最忙的Session

SQL

selectsp.sid,ss.username,ss.connected,(sp.isreads+sp.iswrites+sp.isdeletes+sp.isrewrites)TOP_OP,sp.locksheld,sp.locksheld,sp.seqscans,sdb.odb_dbnamefromsyssesprofsp,syssessionsss,sysopendbsdbwheresp.sid=ss.sidandss.sid=sdb.odb_sessionid;ListInfo

TopI/OSessionsTopMemorySessions

數(shù)據(jù)庫中IO最多的Session數(shù)據(jù)庫中內存使用最多的Session

SQLSQL+命令

selectsp.sid,ss.username,ss.connected,(sp.isreads+sp.iswrites)TOP_OP,sum(sp.isreads+sp.iswrites)RW,sum(sp.isreads)DR,sum(sp.iswrites)DW,sp.seqscans,sdb.odb_dbnamefromsyssesprofsp,syssessionsss,sysopendbsdbwhereandss.sid=sdb.odb_sessionidgroupbysid,username,connected,top_op,seqscans,odb_dbname;selectsp.sid,ss.username,ss.connected,slt.memtotal,slt.memused,sp.total_sorts,sp.locksheld,sp.bufreads,sp.bufwrites,sp.seqscans,sdb.odb_dbnamefromsyssesprofsp,syssessionsss,sysscblstslt,sysopendbsdbwheresp.sid=ss.sidandss.sid=slt.sidandslt.sid=sdb.odb_sessionid;BusyTable列表SQL邏輯【步驟1】selectnamefromsysmaster:sysdatabases;【步驟2】遍歷步驟1的結果，變量是database_name{selectp.tabname,sum(sin.ti_nrows)nrows,format_units(sum(sin.ti_nptotal),max(sd.pagesize))total_size,format_units(sum(sin.ti_npused),max(sd.pagesize))used_size,sum(seqscans)asseqscans,sum(pagreads)diskreads,sum(bufreads)bufreads,sum(bufwrites)bufwrites,sum(pagwrites)diskwrites,sum(pagreads)+sum(pagwrites)disk_rsws,TopBusyTables 數(shù)據(jù)庫中最忙的表

trunc(decode(sum(bufreads),0,0,(100-((sum(pagreads)*100)/sum(bufreads+pagreads)))),2)rbufhitsfromdatabase_name:systabless,sysmaster:sysptprofp,sysmaster:systabinfosin,sysmaster:sysdbspacessd,sysmaster:systabnameswheres.tabid>99ands.tabname=p.tabnameandp.dbsname=st.dbsnameandsd.dbsnum=trunc(st.partnum/1048576)p.partnum=st.partnumands.tabname=st.tabnameandst.partnum=sin.ti_partnumandst.dbsname='database_name'groupby1orderby10desc;";}【步驟3】步驟2中的locklevel字段顯示selectlocklevelfromdatabase_namewheretabname='tabname';如果locklevel為PPageLock顯示YEPageNOTopBusyIndexes 數(shù)據(jù)庫中最忙的索引

BusyIndex列表SQL邏輯【步驟1】selectnamefromsysmaster:sysdatabases;【步驟2】遍歷步驟1的結果，變量是database_name{selectst.dbsnamedatabasename,dt.tabname,di.idxname,dbs_name,format_units(sin.ti_nptotal,sd.pagesize)total_size,pagreadsdiskreads,bufreads,bufwrites,pagwritesdiswrites,trunc(decode(sum(bufreads),0,0,(100-((sum(pagreads)*100)/sum(bufreads+pagreads)))),2)rbufhitsfromsysmaster:systabnamesst,sysmaster:sysdbspacessd,sysmaster:systabinfosin,database_name:sysindexesdi,database_name:systablesdt,sysmaster:sysptprofpwheresd.dbsnum=trunc(st.partnum/1048576)anddt.tabid>99anddi.idxname=st.tabnameanddt.tabid=di.tabidandst.partnum=sin.ti_partnumandst.dbsname='database_name'andp.partnum=st.partnumgroupbydbs_name,tabname,idxname,databasename,total_size,diskreads,bufreads,bufwrites,diswritesorderby1,2,3;}TopRunningTopLocktables

數(shù)據(jù)庫中正在運行的SQL數(shù)據(jù)庫中鎖請求最多的表

SQL

onstat-gsql【sqlstmttype不為空的】以及onstat-gsqlsessionid獲取具體的sqlTopLockTables【步驟1】selectskip0first10dbsname,tabname,lockreqs,lockwts,lktouts,pagreads,pagwrites,bufreads,bufwrites,seqscansfromsysmaster:sysptproforderbylockreqsdesc;【步驟2】頁面total總數(shù)的顯示selectcount(1)astotalfrom(步驟1SQL)頁面列表