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.

Figure 8. Speedgain for Databases Add DB Wizard

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”.

Figure 9. Database Registration

The next step is to create a login for the Database.

Figure 10. Create a Database Login

To create a new login click on “new login” and enter the credentials for the database and click “add login”.

Figure 11. Add a new database 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”.

Figure 12. Add a new 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.

Figure 13. Server Registration

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.

Figure 14. Summary Add DB Wizard

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.