DB Dashboard

DB Dashboard

The DB Dashboard helps administrators review server health, database activity, storage usage, table bloat, and database backup progress from one simple screen.

Important: Use this feature carefully. Actions such as killing a query, running vacuum, or creating a backup should be handled by an administrator who understands the current system workload.

1. Open the Dashboard

Step 1: Open Administration > Monitor > Dashboard.
Step 2: Wait for the dashboard cards and tables to load.
Step 3: Click the refresh button whenever you need the latest values.
[Insert image: DB Dashboard main screen]

2. Review Server Health

The top cards show the current resource usage of the Axanta environment. These values help you quickly understand whether the server has enough capacity.

Card What It Shows How to Read It
CPU Usage Current processor usage in percentage. High usage for a long time can mean heavy processing or slow requests.
Memory Usage Current RAM usage in percentage. High usage may require checking running processes or increasing capacity.
Disk Usage Used space on the server disk. Keep enough free disk space for backups, logs, uploads, and regular operations.
Database Size Current database size in MB. Use this to track database growth over time.
Filestore Storage used by uploaded files and attachments. Large filestore growth can increase backup size and storage cost.
Tip: If CPU, memory, or disk usage stays high, review active queries and storage usage before running heavy operations.

3. Check Active Queries

The Active Queries table lists database queries that are currently running. It helps administrators identify slow or long-running activity.

Column Description Action
ID The process ID of the running query. Use it to identify the query session.
DB The database where the query is running. Confirm the query belongs to the expected database.
User The user connected to the query session. Contact the user if the activity needs confirmation.
State The current status of the query. Review active items first.
Duration How long the query has been running. Long-running queries may need investigation.
Actions Show query details or stop a query. Only administrators can use Kill Query.
Step 1: Click Show to view the full query text.
Step 2: Use Copy Query when the query must be shared for review.
Step 3: Use Kill only when the query is confirmed to be unsafe or blocking work.
[Insert image: Active Queries table with Show and Kill buttons]

4. Review Bloated Tables

The Bloated Tables section highlights tables with dead rows and unused space. It helps administrators decide when a table needs maintenance.

[Insert image: Bloated Tables section showing bloat percentage, dead rows, and Vacuum button]
Column Meaning What to Check
Table Name of the table being reviewed. Confirm it belongs to the expected application area.
Live Rows Rows currently used by the table. Compare with dead rows to understand table health.
Dead Rows Rows that are no longer active. A high count can increase table size and slow operations.
Bloat % Estimated percentage of unused table space. Warning and critical colors indicate higher priority.
Dead Size Estimated space used by dead rows. Large values may require maintenance.
Last Vacuum Last recorded maintenance time for the table. Older dates may require attention.
Recommendation: Run Vacuum during a suitable maintenance window when possible. This action is available only for administrators.

5. Create a Database Backup

The Backup button opens a separate backup screen where administrators can start, stop, monitor, and download a database backup.

Step 1: From the dashboard, click Backup.
Step 2: Click Start to begin the backup.
Step 3: Watch the progress steps: Dumping DB, Zipping, and Ready.
Step 4: If needed, click Stop to cancel the running backup.
Step 5: When the backup is ready, click Download Backup.
[Insert image: Database Backup progress screen]
Note: Backup time depends on database size, filestore size, disk speed, and current server load.

6. Access and Permissions

User Type Allowed Actions Restricted Actions
Standard User View dashboard information when access is granted. Cannot kill queries or run vacuum actions.
Administrator View metrics, kill queries, run vacuum, and manage backups. Should perform critical actions only after review.

7. When to Contact Support

CONTACT SUPPORT: Contact the Axanta support team if the same issue appears repeatedly, a backup fails more than once, disk usage remains high, or queries continue to become slow even after review.
Situation What to Do
Backup fails or gets interrupted repeatedly Do not keep retrying during business hours. Share the error message with support.
Disk usage is close to full Inform the administrator or hosting team before running large backups or imports.
Same query becomes slow again and again Do not only kill the query. Report it for proper investigation.
Vacuum fails on a table Stop further maintenance actions and contact support.
IMPORTANT: Backup, Kill, and Vacuum actions can affect users or system performance. Use them only when required and preferably during low-usage hours.

Next Topics :

 Company Setting
Users
User Groups
Configurations