Contents of the System Monitor reports

The report files generated by the System Monitor tool contain information that is useful when troubleshooting potential WorldServer errors.

On the master node (the one containing database stats), the System Monitor report should contain the following files:
NameDescription
connections.jsonActive connections with the last SQL query. This file is included only if you enable connection logging.
dbStatsLogger_<machine name>.jsonContains information about blocked sessions, monitored at a frequency of your choice.
lock_sequence_dump_<timestamp>.jsonContains information about database locks (if you configured System Monitor to report such information).
spGetBlockedSessions.htmlContains information about blocked sessions. The file should contain only the entries for the WorldServer database (check dbName).
spGetCurrentQueries_<timestamp>.htmlCurrent SQL queries. This file should contain only the entries for the WorldServer database (check dbName).
spGetLockedObjects.html Contains information about locked objects. The file should contain only the entries for the WorldServer database (check dbName).
spGetQueryStats.html Contains information about the slowest queries. The file should contain only the entries for the WorldServer database (check dbName).
spGetSessions.html Contains information about SQL sessions. These sessions correspond to active WorldServer connections from the connection pool. Not necessary all sessions have active transactions. The file should contain only the entries for the WorldServer database (check dbName).
sysinfo.jsonGeneral JVM and database information in .json format.
threadDumpLogger_<machine name>.json

thread_dump_<timestamp>.txt

JVM thread dumps monitored at a frequency of your choice.
ws.log The standard WorldServer log file.
On other nodes than the master node, the System Monitor report should contain the following files:
NameDescription
connections.json Active connections with the last SQL query. This file is included only if you enable connection logging.
dbStatsLogger_<machine name>.json Contains information about blocked sessions, monitored at a frequency of your choice.
lock_sequence_dump_<timestamp>.jsonContains information about database locks (if you configured System Monitor to report such information).
sysinfo.json General JVM and database information in .json format.
threadDumpLogger_<machine name>.json

thread_dump_<timestamp>.txt

JVM thread dumps monitored at a frequency of your choice.
ws.logThe standard WorldServer log file.