20 Mar 14 Performance Measurement using measureware
Measureware Extract Documentation
Necessary Processes:
root@myserver:/tmp/fog> ps -ef | grep scopeux
root 3246 1 0 Mar 19 ? 0:40 /opt/perf/bin/scopeux
List of possible reporting parameters:
/var/opt/perf/reptfile
Running datafiles live here:
root@myserver:/root> ll /var/opt/perf/datafiles
total 154528
-rw-r–r– 1 root sys 31 Feb 21 08:50 RUN
-rw-r–r– 1 root root 105 Sep 27 2012 agdb
-rw-r–r– 1 root root 0 Sep 27 2012 agdb.lk
-rw-rw-rw- 1 root root 168 Feb 21 18:28 classinfo.db
-rw-r–r– 1 root root 4206652 Feb 21 18:20 logappl
-rw-r–r– 1 root root 24054172 Feb 21 18:25 logdev
-rw-r–r– 1 root root 6464936 Feb 21 18:25 logglob
-rw-r–r– 1 root root 352232 Feb 21 10:55 logindx
-rw-r–r– 1 root root 15 Sep 27 2012 logpcmd0
-rw-r–r– 1 root root 32673802 Feb 21 18:28 logproc
-rw-r–r– 1 root root 9740096 Feb 21 18:25 logtran
drwxr-xr-x 2 root root 96 Sep 27 2012 lost+found
-rw-r–r– 1 root root 1504540 Oct 31 2012 mikslp.db
Here is a typical template to generate data into a spreadsheet.
cat mwatemplate
REPORT “MWA Export on !SYSTEM_ID”
FORMAT ASCII
HEADINGS ON
SEPARATOR=”|”
SUMMARY=60
MISSING=0
DATA TYPE GLOBAL
YEAR
DATE
TIME
GBL_CPU_TOTAL_UTIL
GBL_CPU_SYS_MODE_UTIL
GBL_CPU_USER_MODE_UTIL
GBL_CPU_SYSCALL_UTIL
GBL_CPU_INTERRUPT_UTIL
GBL_PRI_QUEUE
GBL_CPU_CSWITCH_UTIL
GBL_SWAP_SPACE_UTIL
GBL_DISK_UTIL_PEAK
GBL_DISK_SUBSYSTEM_QUEUE
GBL_MEM_UTIL
GBL_MEM_CACHE_HIT_PCT
GBL_MEM_PAGEIN_RATE
GBL_MEM_PAGEOUT_RATE
GBL_MEM_SWAPIN_RATE
GBL_MEM_SWAPOUT_RATE
GBL_MEM_QUEUE
GBL_NET_PACKET_RATE
GBL_NET_OUTQUEUE
GBL_NETWORK_SUBSYSTEM_QUEUE
Here is a script to process the measureware output and generate a spreadsheet using the above template file:
#################### Begin Sample Extract Script ####################
#!/usr/bin/ksh
#
# Extract to spreadsheet midnight to 6 am
/opt/perf/bin/extract -xp -r /root/mwatemplate -g -b today 0:00 -e today 06:00 -f testfile.txt
#################### End Sample Extract Script ####################
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.
