tune-workloads

What problem does it solve?

This Skill addresses issues where database queries are misclassified, leading to performance degradation and unmet Service Level Agreements (SLAs). It automates the process of analyzing and adjusting workload definitions to ensure queries are routed and managed correctly.

Core Features & Use Cases

• Autonomous Classification Adjustment: Automatically adds or modifies classification rules, filters, and priorities based on analysis.
• Template-Driven Configuration: Utilizes predefined templates for common classification patterns (e.g., by application, user, or query complexity).
• Fine-grained Control: Supports adding sub-criteria like query execution time (MINSTEPTIME) or scan type (FTSCAN) for precise management.
• Use Case: If critical ETL queries are being misclassified into a lower-priority workload, this Skill can autonomously add a new classification rule to the appropriate filter to ensure they are correctly routed, improving ETL job performance.

Quick Start

Use the tune-workloads skill to add classification criteria to the 'ETL_FILTER' in the 'Tactical' ruleset to match the 'ETL_LOADER' application.