Configuring Navicat Monitor
The rest of the article will explore how to configure Navicat Monitor on Windows 10. You can download the trial version from the Navicat site. It will provide you with 14 days of full functionality to give it a thorough evaluation.
The Navicat Monitor icon is added to the Taskbar during installation. Right-clicking it displays a context menu with several commands, including one to Start monitoring, enable Auto-start, as well as Open Navicat Monitor in the default browser.
Navicat Monitor Context Menu
Upon first launching the monitor in the browser, you're greeted by the Welcome Screen. From there, you can either set the Monitor's initial settings or import them from another installation.
Navicat Monitor Welcome Screen
A wizard guides you through the configuration of the admin account, repository database, and monitor application settings, and then presents a summary of the initial settings.
Navicat Monitor Initial Settings
Clicking the Finish button then configures Navicat Monitor and the launches the Login screen in a new browser tab.
Configuring a New DB Server Instance
You can specify DB servers to monitor via the + New Instance button. Clicking it opens the New Instance dialog.
In the New Instance window, you can enter a name to best describe your instance in Instance Name and select the Group of your instance. Groups include "Production" and "Testing" by default, but you can add a new group by clicking the + New Group button. Then, provide login information to connect your server.
New DB Server Instance
Monitoring CPU and Memory
Navicat Monitor can collect your server's system performance metrics such as CPU and memory resources using SSH (Secure Shell) and SNMP (Simple Network Management Protocol).
Simple Network Management Protocol (SNMP) is an Internet Standard protocol for collecting and organizing information about managed devices on IP networks and for modifying that information to change device behavior. SNMP exposes management data in the form of variables on the managed systems organized in a management information base (MIB) which describe the system status and configuration. These variables can then be remotely queried by applications such as Navicat Monitor.
You don't have to provide the SNMP login information, but you can only monitor your server without CPU or Memory metrics.
As someone who has a fair amount of experience with database monitoring, I know that the operating system has to be configured in order for applications to collect CPU and Memory related metrics. For the purposes of illustration, here are the steps for setting up SNMP in Windows 10:
SNMP is not enabled by default, so you have to activate it by clicking the box on the Windows Features dialog:
- Next, we need to configure the SNMP service. On the Services dialog, right-click the SNMP Service, and select Propertiesfrom the popup menu.
- On the SNMP Service Properties dialog, click on the Traps tab, provide a name in the Community name combobox, such as "navicat", and click the Add to listbutton. Make sure that the Trap destinations include "localhost".
SNMP Service Properties
Click Apply to commit your changes.
On the Security tab, check the Send authentication trap box, and add the "navicat" Community name to the Accepted community names list with READ ONLY rights.
Check the Send Authentication Trap Box
Click OK to commit the changes and close the dialog.
Be sure to enter the "navicat" Community name in the Community text field on the New Instance screen to collect CPU and Memory metrics.
You can test your connection settings by clicking the Test Connection button. Watch for the green "Connection success!" confirmation message before proceeding.
Click the New button to add the new instance to the Navicat Monitor Dashboard.
Click the New Button
In today's article, we got a first look at the new Navicat Monitor by exploring some of its many features and learning how to configure it on Windows 10.
Should you decide to purchase Navicat Monitor at the end of the evaluation period, you can purchase a token for each target server that you'd like to monitor. For example, if you need to monitor three MySQL Servers, you will need to purchase three tokens. If you need to monitor four MySQL Servers and one MariaDB Servers, you will need to purchase a total of five tokens. For each order, you will receive one Navicat Monitor key. Each Navicat Monitor key is for a single machine that has Navicat Monitor installed on it.
Tokens costs $399.00 USD each, but volume discounts are available for multiple licenses:
- 5-9 licenses: receive a discount of 20% off
- 10+ licenses: receive a discount of 30% off
A Non-commercial license for Navicat Monitor will also be available soon. It will cost less than half the price of a commercial license at only $159.00 USD per token.
See all articles by Rob Gravelle