The solidDB® server provides various tools for gathering information about database server activity and database operations.
ADMIN COMMAND 'userlist'
The ADMIN COMMAND 'userlist -l' command displays a list of users currently logged in to the database. The output provides information about various database operations and settings for each user.
ADMIN COMMAND 'report'
The ADMIN COMMAND 'report' command produces a report that contains information about the server, users, and database operations. The report also includes the configuration file (solid.ini) settings and a list of the performance counters.
ADMIN COMMAND 'pmon'
The ADMIN COMMAND 'pmon' command displays the solidDB® performance counters (called perfmons or pmons) that provide information about various database operations and performance
ADMIN COMMAND 'status'
The ADMIN COMMAND 'status' command displays statistics information about memory usage, process size, transaction count, cache count, user count, database operations.
ADMIN COMMAND 'monitor'
The ADMIN COMMAND 'monitor' command 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.
ADMIN COMMAND 'trace'
The ADMIN COMMAND 'trace' command controls the solidDB® trace facility.
ADMIN COMMAND 'sqllist'
The ADMIN COMMAND 'sqllist' command displays a list of the longest running SQL statements among the currently running statements. You can limit the number of statements shown by specifying the number of statements as an attribute (ADMIN COMMAND 'sqllist top<no_of_statements>').
ADMIN COMMAND 'backuplist'
The ADMIN COMMAND 'backuplist' command displays the status of the last local backup.
ADMIN COMMAND 'proctrace'
The ADMIN COMMAND 'proctrace' command controls tracing in stored procedures and triggers.
ADMIN COMMAND 'comprinfo'
The ADMIN COMMAND 'comprinfo' command will display information about state of compression in each table.
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 into a log file.