Monitor and Manage with DBCC
DBCC is the web console for SynxDB clusters. It reports on the cluster and its databases through dashboards and metrics, and it also carries out day-to-day administration from the browser: renaming or retiring a cluster, editing database parameters and authentication rules, managing resource groups, and routing alerts to the right people. One console can watch several clusters, and you switch between them from the menu in the top-right corner.
Start with the architecture topic to understand how the console collects data, then install it. The remaining topics follow the console’s own navigation: what you can observe, what you can change, and how alerts reach the right people.
Understand and install
How the console is built and how it collects data from MPP database clusters.
Deploy the console and connect it to the clusters you want to watch.
Observe the cluster
The Dashboard page, which gives an at-a-glance overview of the cluster.
Near-real-time status and metric data on the Cluster Metrics and Cluster Status pages.
The Storage Usage page, which shows how space is consumed across the cluster.
Per-pool throughput over time, for clusters that clients reach through PgBouncer.
Inspect databases and queries
Details about tables and other database objects on the Tables page.
In-progress and historical SQL statements on the Query Monitoring page.
Suggested table optimizations, focused on high bloat ratios and data skew.
Administer from the console
Rename a cluster, put it into maintenance mode, or remove it.
Change database parameters and connection settings without editing postgresql.conf by hand.
Create, edit, and delete resource groups and assign database roles to them, without writing SQL.
Set up alerts
Rules that watch system events and resource usage and raise an alert when a threshold is crossed.
Who gets notified when an alert fires.