Collects statistics on the buffer caches for a Sybase IQ database.
IQ UTILITIES { MAIN | PRIVATE }
[ INTO ] table-name
{ START MONITOR ['monitor-options']
| STOP MONITOR }
{ -summary | { -append | -truncate } -bufalloc | -cache | -cache_by_type | -contention | -debug | -file_suffix suffix| -io | -interval seconds | -threads }...
Starts the buffer cache monitor and records activity for the IQ temp buffer cache:
IQ UTILITIES PRIVATE INTO monitor START MONITOR '-cache -interval 20'
START MONITOR starts the IQ buffer cache monitor. For START and STOP MONITOR, the table_name is a dummy table. You can specify any IQ base or temporary table, although it is best to have a table that you use only for monitoring. Results go to a text file, dbname.connection#-main-iqmon for MAIN buffer cache results, or dbname.connection#-temp-iqmon for PRIVATE (Temp) buffer cache results. Running the monitor again from the same database and connection number overwrites previous results. To set the directory location of the monitor output file, set the MONITOR_OUTPUT_DIRECTORY option.
The monitor-options define the content and frequency of results. You can specify more than one, and they must be enclosed with quotation marks.
-summary displays summary information for both the main and temp (private) buffer caches. This option is the default.
-append | -truncate appends to the existing output file or truncates the existing output file, respectively. Truncate is the default.
-bufalloc displays information on the main or temp buffer allocator, which reserves space in the buffer cache for objects like sorts, hashes, and bitmaps.
-cache displays main or temp buffer cache activity in detail.
-cache_by_type produces the same results as -cache, but broken down by IQ page type. This format is used mainly to supply information to Sybase Technical Support.
-contention displays many key buffer cache and memory manager locks.
-debug displays all the information that is available to the performance monitor, whether or not there is a standard display mode that covers the same information. This option is used mainly to supply information to Sybase Technical Support.
-file_suffix suffix creates
a monitor output file named <dbname>.<connid>-<main_or_temp>-<suffix>.
If you do not specify a suffix, it defaults to iqmon.
-io displays main or temp buffer cache I/O rates and data compression ratios.
-interval specifies the reporting interval in seconds. The default is every 60 seconds. The minimum is every 2 seconds.
-threads displays information about processing threads.
None
None
“sp_iqsysmon procedure” in Chapter 7, “System Procedures” in Reference: Building Blocks, Tables, and Procedures
MONITOR_OUTPUT_DIRECTORY option
Chapter 5, “Monitoring and Tuning Performance” in the Performance and Tuning Guide for examples of monitor results
Chapter 1, “Using Procedures and Batches” in System Administration Guide: Volume 2 for advanced use of IQ UTILITIES to create procedures that extend the functionality of Sybase IQ system stored procedures
