When opening the management module in its initial state, you get the status dashboard:
This will give an overview of the system, displaying some instance information, the largest databases, logical reads, session load, and memory usage. When a graph indicates “Off: 17 min” there is a time drift between the client and the database server.
There is a tree structure on the left side of the main window, with areas focusing on specific areas of the database instance.
The subnodes of this wiki page will go into detail for each node in the management tree.
- dbWatch alerts
- SQL performance
- Server activity
- Disk and Memory usage
- SQL Server Error logs
- SQL Server Agent
- Operating System Manager
- SQL Worksheet