Optimizing system performance
Tune the workload and infrastructure to ensure consistent, high-speed execution and system continuity.
Monitoring and evaluating queries: Use the Query Monitor panel to track real-time SQL execution to identify bottlenecks and use the editor to test query logic or performance improvements.
Managing system resources: The Resource Management panel allows you to control CPU and memory boundaries via resource groups and resource queues to prevent contention.
Analyzing data distribution: Investigate table statistics, data skew, and bloat to improve query execution plans via the Data Analysis panel.
Planning storage capacity: Use the Storage panel to monitori disk utilization and historical growth trends across all hosts to prevent "disk full" events.
Securing backups: Manage the status and history of backup operations to ensure reliable recovery points with the Backups panel.
Monitoring and evaluating queries
Use the Query Monitor panel to monitor active workloads, execute SQL, and leverage AI-driven optimization tools.
Managing system resources
Use the Resource Groups panel to configure and monitor CPU, memory, and concurrency limits to optimize workload performance for resource groups and resource queues.
Analyzing data distribution
Use the Data Analysis panel to explore database structures, monitor storage health, and optimize performance metrics.
Planning storage capacity
Use the Storage panel to monitor disk capacity, usage distribution, and historical growth across the WarehousePG cluster.
Securing backups
Use the Backups panel to monitor data protection lifecycles, audit snapshot health, and verify recovery point objectives.
Could this page be better? Report a problem or suggest an addition!