{"id":309,"date":"2014-03-20T16:02:57","date_gmt":"2014-03-20T21:02:57","guid":{"rendered":"http:\/\/www.hpux.ws\/?p=309"},"modified":"2014-03-20T16:02:57","modified_gmt":"2014-03-20T21:02:57","slug":"performance-measurement-using-measureware","status":"publish","type":"post","link":"https:\/\/www.hpux.ws\/?p=309","title":{"rendered":"Performance Measurement using measureware"},"content":{"rendered":"

Measureware Extract Documentation<\/span><\/p>\n

\u00a0<\/span><\/p>\n

\u00a0<\/span><\/p>\n

\u00a0<\/span><\/p>\n

Necessary Processes:<\/span><\/p>\n

root@myserver:\/tmp\/fog<\/a>> ps -ef | grep scopeux<\/span><\/b><\/span><\/p>\n

\u00a0\u00a0\u00a0 <\/span>root<\/span><\/span>\u00a0 <\/span>3246<\/span><\/span>\u00a0\u00a0\u00a0\u00a0 <\/span>1<\/span><\/span>\u00a0 <\/span>0<\/span><\/span>\u00a0 <\/span>Mar 19<\/span><\/span>\u00a0 <\/span>?<\/span><\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>0:40 \/opt\/perf\/bin\/scopeux<\/span><\/span><\/p>\n

List of possible reporting parameters:<\/span><\/p>\n

\/var\/opt\/perf\/reptfile<\/span><\/p>\n

\u00a0<\/span><\/p>\n

Running datafiles live here:<\/span><\/p>\n

root@myserver:\/root<\/a>> ll \/var\/opt\/perf\/datafiles<\/span><\/b><\/span><\/p>\n

total 154528<\/span><\/p>\n

-rw-r–r–\u00a0\u00a0 <\/span><\/span>1 root<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>sys<\/span><\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>31 Feb 21 08:50 RUN<\/span><\/span><\/p>\n

-rw-r–r–\u00a0\u00a0 <\/span><\/span>1 root<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>root<\/span><\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>105 Sep 27<\/span><\/span>\u00a0 <\/span>2012 agdb<\/span><\/span><\/p>\n

-rw-r–r–\u00a0\u00a0 <\/span><\/span>1 root<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>root<\/span><\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>0 Sep 27<\/span><\/span>\u00a0 <\/span>2012 agdb.lk<\/span><\/span><\/p>\n

-rw-rw-rw-\u00a0\u00a0 <\/span><\/span>1 root<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>root<\/span><\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>168 Feb 21 18:28 classinfo.db<\/span><\/span><\/p>\n

-rw-r–r–\u00a0\u00a0 <\/span><\/span>1 root<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>root<\/span><\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>4206652 Feb 21 18:20 logappl<\/span><\/span><\/p>\n

-rw-r–r–\u00a0\u00a0 <\/span><\/span>1 root<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>root<\/span><\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>24054172 Feb 21 18:25 logdev<\/span><\/span><\/p>\n

-rw-r–r–\u00a0\u00a0 <\/span><\/span>1 root<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>root<\/span><\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>6464936 Feb 21 18:25 logglob<\/span><\/span><\/p>\n

-rw-r–r–\u00a0\u00a0 <\/span><\/span>1 root<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>root<\/span><\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>352232 Feb 21 10:55 logindx<\/span><\/span><\/p>\n

-rw-r–r–\u00a0\u00a0 <\/span><\/span>1 root<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>root<\/span><\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>15 Sep 27<\/span><\/span>\u00a0 <\/span>2012 logpcmd0<\/span><\/span><\/p>\n

-rw-r–r–\u00a0\u00a0 <\/span><\/span>1 root<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>root<\/span><\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>32673802 Feb 21 18:28 logproc<\/span><\/span><\/p>\n

-rw-r–r–\u00a0\u00a0 <\/span><\/span>1 root<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>root<\/span><\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>9740096 Feb 21 18:25 logtran<\/span><\/span><\/p>\n

drwxr-xr-x\u00a0\u00a0 <\/span><\/span>2 root<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>root<\/span><\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>96 Sep 27<\/span><\/span>\u00a0 <\/span>2012 lost+found<\/span><\/span><\/p>\n

-rw-r–r–\u00a0\u00a0 <\/span><\/span>1 root<\/span>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/span>root<\/span><\/span>\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0<\/span><\/span>1504540 Oct 31<\/span>\u00a0 <\/span>2012 mikslp.db<\/span><\/span><\/p>\n

\u00a0<\/span><\/p>\n

Here is a typical template to generate data into a spreadsheet.<\/span><\/p>\n

cat mwatemplate<\/span><\/p>\n

REPORT “MWA Export on !SYSTEM_ID”<\/span><\/p>\n

FORMAT ASCII<\/span><\/p>\n

HEADINGS ON<\/span><\/p>\n

SEPARATOR=”|”<\/span><\/p>\n

SUMMARY=60<\/span><\/p>\n

MISSING=0<\/span><\/p>\n

DATA TYPE GLOBAL<\/span><\/p>\n

YEAR<\/span><\/p>\n

DATE<\/span><\/p>\n

TIME<\/span><\/p>\n

GBL_CPU_TOTAL_UTIL<\/span><\/p>\n

GBL_CPU_SYS_MODE_UTIL<\/span><\/p>\n

GBL_CPU_USER_MODE_UTIL<\/span><\/p>\n

GBL_CPU_SYSCALL_UTIL<\/span><\/p>\n

GBL_CPU_INTERRUPT_UTIL<\/span><\/p>\n

GBL_PRI_QUEUE<\/span><\/p>\n

GBL_CPU_CSWITCH_UTIL<\/span><\/p>\n

GBL_SWAP_SPACE_UTIL<\/span><\/p>\n

GBL_DISK_UTIL_PEAK<\/span><\/p>\n

GBL_DISK_SUBSYSTEM_QUEUE<\/span><\/p>\n

GBL_MEM_UTIL<\/span><\/p>\n

GBL_MEM_CACHE_HIT_PCT<\/span><\/p>\n

GBL_MEM_PAGEIN_RATE<\/span><\/p>\n

GBL_MEM_PAGEOUT_RATE<\/span><\/p>\n

GBL_MEM_SWAPIN_RATE<\/span><\/p>\n

GBL_MEM_SWAPOUT_RATE<\/span><\/p>\n

GBL_MEM_QUEUE<\/span><\/p>\n

GBL_NET_PACKET_RATE<\/span><\/p>\n

GBL_NET_OUTQUEUE<\/span><\/p>\n

GBL_NETWORK_SUBSYSTEM_QUEUE<\/span><\/p>\n

\u00a0<\/span><\/p>\n

Here is a script to process the measureware output and generate a spreadsheet using the above template file:<\/span><\/p>\n

\u00a0<\/span><\/p>\n

#################### Begin Sample Extract Script ####################<\/span><\/p>\n

#!\/usr\/bin\/ksh<\/span><\/p>\n

#<\/span><\/p>\n

# Extract to spreadsheet midnight to 6 am<\/span><\/p>\n

\/opt\/perf\/bin\/extract -xp -r \/root\/mwatemplate -g -b today 0:00 -e today 06:00 -f testfile.txt<\/span><\/strong><\/p>\n

#################### \u00a0<\/span><\/span>End Sample Extract Script <\/span>\u00a0<\/span>####################<\/span><\/span><\/p>\n

\u00a0<\/span><\/p>\n

It is simple but effective. The command above looks at data between midnight and 6 am today. A look at the man page for extract will show you how to look at different data sets. There are an endless number of options. Choose template options based on the nature of the problem you are facing.<\/span><\/p>\n

\u00a0<\/span><\/p>\n

\u00a0<\/span><\/p>\n

\u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Measureware Extract Documentation \u00a0 \u00a0 \u00a0 Necessary Processes: root@myserver:\/tmp\/fog> ps -ef | grep scopeux \u00a0\u00a0\u00a0 root\u00a0 3246\u00a0\u00a0\u00a0\u00a0 1\u00a0 0\u00a0 Mar 19\u00a0 ?\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0:40 \/opt\/perf\/bin\/scopeux List of possible reporting parameters: \/var\/opt\/perf\/reptfile \u00a0 Running datafiles live here: root@myserver:\/root> ll \/var\/opt\/perf\/datafiles total 154528 -rw-r–r–\u00a0\u00a0 1 root\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 sys\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 31 Feb 21 08:50 RUN -rw-r–r–\u00a0\u00a0 1 root\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 root\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 105 Sep […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_kadence_starter_templates_imported_post":false,"footnotes":""},"categories":[28,12,8],"tags":[85,86],"class_list":["post-309","post","type-post","status-publish","format-standard","hentry","category-capacity-planning","category-perf","category-sysadmin","tag-measureware","tag-performance-measurement"],"_links":{"self":[{"href":"https:\/\/www.hpux.ws\/index.php?rest_route=\/wp\/v2\/posts\/309"}],"collection":[{"href":"https:\/\/www.hpux.ws\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hpux.ws\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hpux.ws\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hpux.ws\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=309"}],"version-history":[{"count":1,"href":"https:\/\/www.hpux.ws\/index.php?rest_route=\/wp\/v2\/posts\/309\/revisions"}],"predecessor-version":[{"id":310,"href":"https:\/\/www.hpux.ws\/index.php?rest_route=\/wp\/v2\/posts\/309\/revisions\/310"}],"wp:attachment":[{"href":"https:\/\/www.hpux.ws\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=309"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hpux.ws\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=309"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hpux.ws\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=309"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}