 |
» |
|
|
|
Enables sampling of the data buffer pool
Scope | |
SQLMON Only
SQLMON Syntax | |
SET SA [MPLING] [ ON OFF ] Parameters | |
- ON
Specifies that SQLMON samples the data buffer pool
each time a SampleIO subsystem screen is refreshed.
The default value.
- OFF
Specifies that SQLMON does not sample the data
buffer pool. Improves the performance of SQLMON.
Description | |
It is recommended that you issue SET SAMPLING ON,
perform sampling, issue SET SAMPLING OFF, and then access
the SampleIO screens to view the results.
You may find it easier to use the SampleIO screens when
sampling is not being performed, because CPU utilization
is smaller.
SQLMON samples the data buffer pool only when SAMPLING
is ON and you access a SampleIO screen.
In that case, SQLMON samples the data buffer pool 25
times during each refresh cycle.
The SWAPIN, SWAPOUT, and TOTALIO counters on the
SampleIO screens are incremented to reflect activity
during sampling.
The counters are initialized to 0 when you issue
SET DBENVIRONMENT.
For more information, see the chapter
"Troubleshooting with SQLMON."
When sampling is ON, the DISPLAYSAMPLES variable determines
whether you see a scale or a screen when samples
are collected.
For more information, see the command page
for SET DISPLAYSAMPLES.
sequence. First, to turn on sampling, enter
SQLMONITOR SAMPLEIO => SET SAMPLING ON
|
|
