Sybase IQ's sysmon procedure produces a log file which is similar to the one generated for ASE ; here are some sample calls.
set option Monitor_Output_Directory = "/opt/sybase/IQBACKUP/sysmon/HELENA"
go
sp_iqsysmon start_monitor, filemode,'-interval 120 -file_suffix sysmon.2013_May6'
go
commit
go
waitfor delay '00:59:00'
commit
go
sp_iqsysmon stop_monitor
go
Below is a handy script for processing the sysmon output. It filters the data, and shows recommended levels/benchmarks.
#!/bin/bash
#========================================================
# sysmon log file analyzer
#
#
#========================================================
fname=$1
if ! test -f $fname; then
echo "Error: file $fname not found."
exit
fi
date
echo "============================================================================="
echo "IQ Sysmon Log Analyzer"
echo "============================================================================="
sleep 2
echo "Threads: Free vs Reserved Benchmark: ThrNumFree > ThrReserved"
echo " "; echo " "; sleep 2
egrep 'Thr' $fname | egrep 'Free|Reserved' | head -25
echo "============================================================================="; sleep 3
echo "Press enter to continue."
read sel1
echo "Pinned Buffers Benchmark: Pinned < 90%"
echo " "; echo " "; sleep 2
egrep 'Pool|Pin' $fname | head -25
echo "============================================================================="; sleep 3
echo "Press enter to continue."
read sel1
echo "Buffers in Use % Benchmark: ~= 100%"
echo " "; echo " "; sleep 2
egrep 'Pool|InUse' $fname | head -25
echo "============================================================================="; sleep 3
echo "Press enter to continue."
read sel1
echo "CPU Time Benchmark: CPU Sys < 20%"
echo " "; echo " "; sleep 2
grep 'CPU Sys' $fname | head -25
echo "============================================================================="; sleep 3
echo "Press enter to continue."
read sel1
echo "LRU Waits Benchmark: < 20%"
echo " "; echo " "; sleep 2
grep 'LRUNumTime' $fname | head -25
echo "============================================================================="; sleep 3
echo "Press enter to continue."
read sel1
echo "Buffer Busy Waits Benchmark: ~= 0"
echo " "; echo " "; sleep 2
egrep 'Manager|BusyWaits' $fname | egrep -v 'Memory|Transaction|Thread|fetch' | head -25
echo "============================================================================="; sleep 3
echo "Press enter to continue."
read sel1
echo "Grabbed Dirty Benchmark: ~=0"
echo " "; echo " "; sleep 2
egrep -i 'grabbeddirty' $fname | head -25
echo "============================================================================="; sleep 3
echo "Press enter to continue."
read sel1
echo "HR% - Cache Hit Rate Benchmark: Hit% > 90%"
echo " "; echo " "; sleep 2
egrep -i 'hit%' $fname | head -25
echo "============================================================================="
