4.3. How to monitor a first database
If everything is running fine and the web frontend is started, head to the settings icon in the upper left corner. click on it and choose “Configuration”. In the top right is a green “Add DB Wizard” button. Click on it and the following window opens.
Enter a Display Name of your choosing. Leave enabled active, enter a Instance if you need, a database name, the port and choose the kind of database in DBMS that you want to monitor. Then choose a standard policy (all active) for the type of database you chose. Click “next”.
The next step is to create a login for the Database.
To create a new login click on “new login” and enter the credentials for the database and click “add login”.
After you clicked on next a server must be added. The server is the environment that hosts the database. Usually, it is a Windows or Linux server. To add a new server, click “Add Server”.
Add a name of your choosing, the ip address and the ssh port that would be 22 in most cases. Choose the Operating system and a policy. The policy can be a local or a remote policy if the server is not the same system that has the backend collector.
Click “next”. Also the server needs its own login. Create a new login in the same way you did for the database. Click “next” for a summary and finish to create the server. Then you will be lead back to the “Add DB Wizard”. Click here “next”. A summary will be shown.
After you click “finish” the monitoring of the database will start immediately. You can navigate to the top left. Click on the type of database you created and choose “Overview”. After a short while (a few minutes) the newly gathered performance data will appear in the charts.