The following tools are available to help collect, format, or analyze diagnostic data.

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.

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.

The ADMIN COMMAND 'pmon' command displays the solidDB^® performance counters (called perfmons or pmons) that provide information about various database operations and performance

The ADMIN COMMAND 'status' command displays statistics information about memory usage, process size, transaction count, cache count, user count, database operations.

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.

The ADMIN COMMAND 'trace' command controls the solidDB^® trace facility.

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:

The ADMIN COMMAND 'backuplist' command displays the status of the last local backup.

The ADMIN COMMAND 'proctrace' command controls tracing in stored procedures and triggers.

The EXPLAIN PLAN FOR SQL statement shows the execution plan that the SQL optimizer has selected for a given SQL statement.

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.