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.

Filter: Click to apply or create Groups to filter out queries from the Query Feed. See following Query Filters section.

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.

Query Filters

Displays a list of Filters associated with the selected Group Name. Queries containing these Filters are excluded from the Query Feed.

Filters: Grid shows Filter Text added to the currently selected Group.

• Group: Displays the name of the selected Group.
• Filter: Displays the added Filter Text.

Group: Change the currently selected Group, edit a Group Name, or create a new Group.

• Name: Click to select a Group to filter by or to modify. Default selection is "None" which cannot be changed or added to.
• Change Name: Click to edit the name of the selected Group.
• New Group: Click to create a new Group.

Add: Click to add Filter Text to the selected Group.

Import: Click to import a new Group with its Filters.

• Prompts to select a JSON file to import. If import is successful, the new Filters are imported into a new Group Name called "New Import" and is automatically selected as the current Group.
• If "New Import" already exists, it appends an auto incremented number to the end of the group name (i.e., "New Import 2").

Export: Click to export all Filters for the currently selected Group.

Query Filter Edit

Edit Filter Text for a Group. Double-click into an existing Filter from the Filters grid in the Query Filters window.

Group Name: Select the Group Name that the Filter Text applies to.

Filter Text: Enter text to exclude queries that contain said text from the Query Feed.

Delete: Click to delete the Filter for the selected Group Name.

Save: Click to keep changes.