To isolate areas where performance is lacking in your application, the solidDB® provides the following diagnostic tools for observing database performance:
▪SQL info facility
▪EXPLAIN PLAN FOR statement
These tools are helpful in tuning your application and identifying any inefficient SQL statements in it. Read Diagnostics and troubleshooting for SQL for additional information about how to use these tools.
In addition, the following commands provide useful information for evaluating performance.
ADMIN COMMAND 'status'
This command returns statistics information from the server. For details, read about this command in solidDB® Administrator Guide.
ADMIN COMMAND 'perfmon'
The command returns detailed performance statistics from the server. For details on producing performance reports with this command, see “Performance counters (perfmon)” in the solidDB® Administrator Guide.
ADMIN COMMAND 'trace'
This command switches tracing on for SQL statements and network communication. For complete syntax, see the trace option syntax under ADMIN COMMAND.