The Query Monitor window allows you to view query requests made to the MySQL database server as they execute in real-time.

In the Main Menu, click Help, Query Monitor.

This window can remain open in the background to allow monitoring during normal use of the program. Activity displayed is only from the instance of Open Dental from which it was launched. It does not allow you to monitor all queries being processed by the MySQL server.

Query Feed: Grid shows details on queries sent to the MySQL server.

• Server: Computer name of the server that received the monitored query. This may be the name of the database server, report server, or read-only server.
• Command: Exact SQL query command sent.
• DateTimeStart: Recorded date and time of the query.
• Elapsed: Amount of time to process the query command.

Start: Click to begin monitoring queries.

Stop: Click to suspend monitoring queries.

Clear: Click to clear the Query Feed.

Log: Click to save a log of queries captured while monitoring. Monitoring must be stopped to use. Log file is saved to the QueryMonitorLogs folder in the OpenDentImages folder.

Query Details: Highlight an entry above to see complete details on the query submitted.

• Command: Full text of the query selected above.
• Start: Date and time when the selected query started.
• Stop: Date and time when the selected query completed execution.
• Elapsed: Amount of time the query took to complete.

Copy: Copy contents of the Command window from Query Details.