We have 7 default modules available when you start dbWatch Control Center. This article will only introduce you to what these instances are and give a brief description of them. You need to be familiar with the navigation tree to have a better idea of how these modules work.
In this module, you can monitor all your registered instances. When you select a server group, it will display all the instances under that server group. For example, you wanted to view a server called Dalna in group MSSQL_oslo. You only need to select MSSQL_oslo group represented by a folder icon.
In this example, we are currently seeing the dbWatch Server with different dbWatch servers found under it. We are currently in the Instance status tab where it shows the count of instances with different statuses and glaring issues found in all of our instances.
The management module is where you can directly deploy changes to your databases. If you click on an instance, Control Center will display options for you. You can check the performance, sessions, databases, error logs, audit logs, and memory. You are also given the option to configure the database’s current configuration and access control. Plus, you can set up backups and jobs.
In this example, we are given an overview of the server we are currently looking at.
The farm module is an expanded version of the monitoring module and management module. In essence, you have a more powerful tool to monitor and manage your database farm.
Currently, we are looking at the job status on our entire database farm. If you want to learn more about Farm Management, you can check out our library on database farm management
This module scans a specified server for active database instances. Afterward, it will list down all database servers found.
You can learn more about auto-discover by clicking on the link provided.
You can script queries under this worksheet. You can cross-check them manually under one window.
The worksheet follows the native query language of your database. To learn more about this, you can check SQL Worksheets.
FDL Console Module
You can script FDL queries in this module. This works well for database farms and it’s not applicable for single instances.
In the example above, we are checking jobs and status for each instance. Check out the section of FDL to learn more.
When you click on the report module, a report wizard will appear and guide you in generating the report.
You can learn more about reports in our section on Reporting
Finally, we have a special module that tracks the information of your dbWatch server and other dbWatch servers currently controlled by your dbWatch monitor.