Troubleshoot > Troubleshooting: Common database errors > Troubleshooting: Database debug

Troubleshooting: Database debug

You can add the debugdbquery parameter to the sm.ini file to allow the server to run the database debug utility. You can then use Microsoft Excel to sort the query results.

Examples:

  • To show all database access, use the following syntax: debugdbquery:999.
  • To show all queries that exceed n number of seconds, use the following syntax: debugdbquery:n/.

Troubleshooting: Interpreting debugdbquery output
Tuning: Improving query speed
Tuning: Number of fields in files