Hint. Resize the suggestion list by dragging the lower right corner. You can enable or disable the code completion feature in Preferences. Clipboard Stack When you copy or cut some codes as usual in the editor, the copied content will also be added to Clipboard Stack. Clipboard Stack can store up to 10 recent items and use the last-in-first-out logic. To paste an item from Clipboard Stack, you can press COMMAND-SHIFT-V. Press COMMAND-SHIFT-V multiple times to cycle through Clipboard Stack. Code Folding Code folding feature enables you to collapse blocks of code such that only the first line of the block appears in the editor. A block of code that can be folded is indicated by an icon to the left of the first line of the block. A vertical line extends from the icon to the bottom of the foldable code. In contrast, a folded block of code is indicated by an icon to left of the code block. You can fold the block by clicking or expand it by clicking . Brace Highlight Navicat Data Modeler supports to highlight the matching brace in the editor, i.e. () .
Hint. The cursor must be on a brace to show the highlight. Zoom In/Zoom Out Navicat Data Modeler has the ability to zoom in or zoom out the SQL in the editor. Zoom In: [CTRL++] or [CTRL+Mousewheel Up] Zoom out: [CTRL+-] or [CTRL+Mousewheel Down] Reset: [CTRL+0] Add a Foreign Key to a Physical Model To add a foreign key, click the Foreign Key button from the toolbar and drag and drop a field from the child table to the parent table. To show/hide the linked name label, simply check/uncheck the Show Name option in Properties pane. When you move your mouse over a foreign key connecter, the border of the parent and the child tables turn to green and blue respectively. Also, the referenced fields and the referencing fields are highlighted. The pop-up menu options of the foreign key in canvas include: Option Description
Hint. Click More Action and select Set Maintenance Window to set maintenance window for all selected instances. To edit the maintenance window
Hint. Zoom in/out of the chart using the mouse wheel to customize the time interval. Click and drag the chart left or right to change the time span. Move the mouse pointer over a point on the chart to show the time and the legend with metrics at that point. Calculated statistics (Mean, Min and Max) for the selected instance within the sample time are shown at the bottom. Compare Metrics You can display metrics of multiple instances on the same chart simultaneously to compare and analysis data. Each line / area on the chart represents the performance of a selected instance. Select the instances in the left pane to add their metrics to the chart. Remove the metrics from the chart in the same way. Export Charts All charts can be exported as PDF files. To export the current chart, click . A Single Chart A Compared Chart Chapter 5 - Alerts About Alerts Navicat Monitor raises alerts when it detects problems across your servers. There is two types of alerts: Warning (orange) and Critical (red). Warning alert does not affect the performance of the server, but may indicate a problem and require investigation. Critical alert indicates a serious issue which is affecting or will affect the performance of the server. Such issues require immediate attention. When an alert is raised, it displays on the Alerts History page and the Overview dashboard. Notifications will be sent to the assigned group members or specific people. You can customize thresholds to trigger alerts for specific instances and groups, and set sending alert notifications to whom. See Alert Policy and Alert Notification for details.
Hint. To set the Microsoft AD settings, you can go to LDAP / AD Settings.
Hint. To change the group of instances, simply drag-and-drop selected instances from a group to another. To suspend monitoring an instance 1. Select an instance.
Hint. Click More Action and select Enable Alert / Disable Alert to enable or disable alerts for all selected metrics. Delete an alert
Hint. When viewing the Plans chart for SQL Server instance, you can save execution plan information as XML files by clicking an entry in the DOWNLOAD XML column, and open them for viewing. Xxxxx over an entry in the legend to highlight the respective series in the chart for better visualization. The time selector is for selecting a time span and an interval (X-axis) to display within the chart. It contains a datetime picker, an interval drop-down menu and panning arrows.
