A number of ADMIN COMMAND commands are available to help you monitor your solidDB server.
▪ ADMIN COMMAND 'userlist' displays a list of users currently logged in to the database, see USERLIST.
▪ ADMIN COMMAND 'report' produces a report that contains information about the server, users, and database operations, see REPORT.
▪ ADMIN COMMAND 'perfmon' displays the solidDB performance counters (called perfmons or pmons) that provide information about various database operations and performance, see PERFMON.
▪ ADMIN COMMAND 'status' displays statistics information about memory usage, process size, transaction count, cache count, user count, database operations, see STATUS.
▪ ADMIN COMMAND 'monitor' controls monitoring of user activity and SQL calls. The information is logged into the soltrace.out file. Monitoring can also be turned on with the command-line option -m at solidDB startup, see MONITOR.
▪ ADMIN COMMAND 'trace' controls the solidDB trace facility, see TRACE.
▪ ADMIN COMMAND 'sqllist' command displays a list of the longest running SQL statements from the set of currently running statements, see SQLLIST.
▪ ADMIN COMMAND 'backuplist' command displays the status of the last local backup, see BACKUPLIST.
▪ ADMIN COMMAND 'proctrace' controls tracing in stored procedures and triggers, see PROCTRACE.
EXPLAIN PLAN FOR
The EXPLAIN PLAN FOR SQL statement shows the execution plan that the SQL optimizer has selected for a given SQL statement.
ODBC Driver Manager trace facility (Windows)
The Windows ODBC Driver Manager has a trace facility that allows the sequence of function calls made by an ODBC application to be recorded in a log file.