Running a Monitored Query
The Monitor window, launched via the Tools->Data Monitor menu option, is where you active monitors and look at the results. The monitor tabs can be rearranged in the same way as all other tabs, pretty much any way you like. Please see Getting the Most Out of the GUI for details.
The monitor results can be viewed only as grids in DbVisualizer Free, while DbVisualizer Pro adds the capability to view them as charts or text.
The Monitor window has a toolbar at the top with an Auto Reload Interval field and a Adjust box. The Auto Reload Interval field is used to control how often, in seconds, to execute the monitors when auto update is running. The specified number of seconds may be increased automatically by DbVisualizer if the total execution time for all monitors is longer than the specified value. Check the Adjust box and the Monitor feature will automatically increase the number of seconds so that all monitors will complete before next auto-update.
The rest of the window holds result areas for each monitored statement with the Visible attribute enabled. Each individual monitor result tab or window may also have a toolbar with controls that apply just to that result. The screenshot is from DbVisualizer Pro, with View buttons in the toolbar for the selected monitor; these buttons are not included in DbVisualizer Free.
When auto reload is running, there is a progress bar shown to the left of the Auto Reload​ Interval field. This progress bar is only shown when auto update is running.
The main toolbar buttons have the following functions:
| Toolbar Button | Description |
|---|---|
| Close | Closes the Monitor window |
| Reload | Reloads all results (i.e., executes all monitors and updates the result sets) |
| Locate Current | Locates and select the monitor node in the Scripts tab corresponding to the currently selected result |
| Clear Current | Clears the currently selected result |
| Clear All | Clears all results |
| Show as Tabs | Shows the results as collapsed tabs |
| Show as Windows | Shows the results as tiled tabs |
| Show Grids | Shows all results as grids |
| Show Text | Shows all results as text |
| Show Chart | Shows all results as graph in the selected chart type |
| Show/Hide Chart Legends | Toggle this to show/hide chart legends |
| Show/Hide Monitor Toolbars | Toggle this to show/hide toolbars for each monitor |
| Start Monitors | Starts auto-update of all monitors, repeatedly executing all statements at the intervals specified by the Auto Reload Interval field |
| Stop Monitors | Stops the auto-update |
In the Tool Properties dialog, you can enable Show Monitor Window at Startup and Start Monitors Automatically, in the Monitor category under the General tab.