SQL/MX 3.x Installation and Management Guide (H06.22+, J06.11+)

Enhancing SQL/MX Database Performance
HP NonStop SQL/MX Installation and Management Guide—640325-001
15-11
Using SCF STATS DISK to Monitor SQL/MX
Statistics and Reuse Failures
In Use................... 53621 Failed FST....... 12
Failed ID........ 1929
SCF - T9082H01 - (04DEC06) (15NOV06) - 12/06/2010 17:52:01 System \DMR11
(C) 1986 Tandem (C) 2006 Hewlett Packard Development Company, L.P.
(Invoking \DMR11.$SYSTEM.SYSTEM.SCFCSTM)
1-> stats disk $*,sqlmx
STORAGE - Stats DISK \DMR11.$SYSTEM
SQL/MX Statistics:
Session Data bytes....... 81920 KB Max Data bytes... 131072 KB
Total Sessions........... 0 Active Sessions.. 0
- 4KB Blocks - - - - - - - - - - - - Reuse - - - - - - - - - -
Max...................... 32640 Attempts......... 499463
Number................... 20352 OK............... 499460
In Use................... 0 Failed FST....... 0
Failed ID........ 3
•
Max Data bytes identifies the configured size of the SQL/MX buffer for the disk.
In the given examples, the disk has been configured for 131072 KB, or 128 MB,
which is the default value.
•
Session Data bytes identifies the amount of virtual memory currently allocated
to SQL/MX buffer space for this DP2 process. The session data bytes can be
configured to be less than the Max Data bytes. DP2 can increase Session
Data bytes to a higher value based on resource and other factors. This value
cannot exceed Max Data bytes.
•
Total Sessions identifies the total number of sessions, including both active
and ended sessions.
•
Active Sessions identifies the number of SQL/MX sessions stored in the buffer
that are currently active.
•
MAX (under the heading 4KB Blocks) identifies the maximum number of 4 KB
blocks located in the SQL/MX buffer for the current value of Max Data bytes. It
can also be interpreted as the maximum number of 4 KB blocks that will be located
in the SQL/MX buffer when the Session Data bytes are equal to the Max
Data bytes.
•
Number (under the heading 4KB Blocks) identifies the number of 4 KB blocks
located in the SQL/MX buffer for the current value of Session Data bytes.
•
In Use under 4KB Blocks identifies the number of 4 KB blocks in the buffer that
are currently in use or reusable.
•
Attempts under Reuse identifies the number of times an attempt has been made
to reuse plan fragments located in the SQL/MX buffer.
•
OK under Reuse identifies the number of times a successful attempt has been
made to reuse plan fragments located in the SQL/MX buffer.
•
Failed FST under Reuse identifies the number of plan fragments that are not
located in the free space table of the SQL/MX buffer and not available for reuse.
Failed ID under Reuse identifies the number of plan fragments that are present
in the free space tables but whose IDs reported that they could not be reused.