Optimizing system performance

Tune the workload and infrastructure to ensure consistent, high-speed execution and system continuity.

Monitoring and evaluating queries: Track real-time SQL execution to identify bottlenecks and use the editor to test query logic or performance improvements.
Managing system resources: 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.
Planning storage capacity: Monitor 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.

Monitor active workloads, execute SQL, and leverage AI-driven optimization tools.

Configure and monitor CPU, memory, and concurrency limits to optimize workload performance for resource groups and resource queues.

Explore database structures, monitor storage health, and optimize performance metrics.

Monitor disk capacity, usage distribution, and historical growth across the WarehousePG cluster.

Monitor data protection lifecycles, audit snapshot health, and verify recovery point objectives.