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:
| Name | Description |
|---|---|
| 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>.json | Contains information about database locks (if you configured System Monitor to report such information). |
| spGetBlockedSessions.html | Contains information about blocked sessions. The file should contain only the entries for the WorldServer database (check dbName). |
| spGetCurrentQueries_<timestamp>.html | Current 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.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.log | The standard WorldServer log file. |
On other nodes than the master node, the System Monitor report should contain the following files:
| Name | Description |
|---|---|
| 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>.json | Contains 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.log | The standard WorldServer log file. |