ResGeneralInfoView

対象日付 2009-09-15
利用状況作成SQL


SELECT
TheDate (FORMAT'yy/mm/dd', TITLE 'Date'),
TheTime (FORMAT'99:99:99', TITLE 'Time'),
/* Percent of time the CPUs were busy doing work */
SUM(CPUBusy) / SUM(Secs) (FORMAT 'ZZ9', TITLE 'CPU使用率(%)'),
/* Parallel efficiency of total pct of time CPUs were busy */
(AVG(CPUBusy)*100)/NULLIFZERO(MAX(CPUBusy)) (FORMAT 'ZZ9', TITLE 'CPUの並列効率(%)'),
/* Percent of time spent waiting for I/O */
SUM(CPUWaitIO)/SUM(Secs) (FORMAT 'ZZ9', TITLE 'I/O待ち(%)'),
/* Pct logical device I/Os done for paging */
SUM(PageOrSwapIO)*100/NULLIFZERO(SUM(LogicalDeviceIO)) (FORMAT 'ZZ9', TITLE 'I/Oに占めるページング・スワップの割合(%)'),
/* Percent of memory that is unused */
SUM(MemFreeKB)*100/NULLIFZERO(SUM(MemSize(FLOAT))*1024) (FORMAT 'ZZ9', TITLE '空きメモリ(%)'),
/* Percent of memory allocation attempts that failed */
SUM(MemFails)*100/NULLIFZERO(SUM(MemFails+MemTextAllocs+MemVprAllocs)) (FORMAT 'ZZ9', TITLE 'メモリ割り当て失敗(%)')
FROM
DBC.ResGeneralInfoView
WHERE
TheDate BETWEEN '2009-09-15' AND '2009-09-15'
/* and SUBSTR( cast(TheTime AS VARCHAR(8) ), 4, 2 ) in ('00', '15', '30', '45') */
/* and SUBSTR( cast(TheTime AS VARCHAR(8) ), 5, 1 ) in ('0', '5') */
GROUP BY
TheDate, TheTime
ORDER BY
TheDate, TheTime ;
※カラムを物理名で表示する場合は下記SQLを実行する。
SELECT
TheDate (FORMAT'yy/mm/dd', TITLE 'Date'),
TheTime (FORMAT'99:99:99', TITLE 'Time'),
/* Percent of time the CPUs were busy doing work */
SUM(CPUBusy) / SUM(Secs) (FORMAT 'ZZ9', TITLE 'CPU Bsy %'),
/* Parallel efficiency of total pct of time CPUs were busy */
(AVG(CPUBusy)*100)/NULLIFZERO(MAX(CPUBusy)) (FORMAT 'ZZ9', TITLE 'CPU Eff %'),
/* Percent of time spent waiting for I/O */
SUM(CPUWaitIO)/SUM(Secs) (FORMAT 'ZZ9', TITLE 'WIO %'),
/* Pct logical device I/Os done for paging */
SUM(PageOrSwapIO)*100/NULLIFZERO(SUM(LogicalDeviceIO)) (FORMAT 'ZZ9', TITLE 'P+S % of IOs'),
/* Percent of memory that is unused */
SUM(MemFreeKB)*100/NULLIFZERO(SUM(MemSize(FLOAT))*1024) (FORMAT 'ZZ9', TITLE 'Fre Mem %'),
/* Percent of memory allocation attempts that failed */
SUM(MemFails)*100/NULLIFZERO(SUM(MemFails+MemTextAllocs+MemVprAllocs)) (FORMAT 'ZZ9', TITLE 'Mem Fai %')
FROM
DBC.ResGeneralInfoView
WHERE
TheDate BETWEEN '2009-09-15' AND '2009-09-15'
/* and SUBSTR( cast(TheTime AS VARCHAR(8) ), 4, 2 ) in ('00', '15', '30', '45') */
/* and SUBSTR( cast(TheTime AS VARCHAR(8) ), 5, 1 ) in ('0', '5') */
GROUP BY
TheDate, TheTime
ORDER BY
TheDate, TheTime ;
参考： カラム論理名 カラム物理名 観測内容
CPU使用率(%) CPU Bsy % CPUを使用する割合
I/O待ち(%) WIO % I/Oを待つことで、CPUがアイドル状態になる。
CPUの並列効率性 CPU Eff% 複数のノートでバランスよくCPUを使用している。
I/Oに占めるページング・スワップの割合(%) P+S % of Ios ページング・スワップが発生すると、そのオーバーヘッドによりシステムの性能が低下する。
空きメモリ(%) Fre Mem % メモリが少ないと、資源枯渇となる。
メモリ割り当て失敗(%) Mem Fai % メモリ割り当て失敗すると、再割当するため、オーバーヘッドが発生する。

Tweet