tune-workloads

Analyze and configure Teradata workload classification rules, filters, and priorities via MCP tools.

7|Updated Dec 3, 2025
One-click install
npx skills add https://github.com/teradata-labs/claude-cookbooks --skill tune-workloads
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: tune-workloads
Source: https://github.com/teradata-labs/claude-cookbooks/tree/main/skills/operations/workloadmanagement/optimization/tune-workloads
Command: npx skills add https://github.com/teradata-labs/claude-cookbooks --skill tune-workloads

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

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.

Frequently Asked Questions about tune-workloads

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I fix Teradata query misclassification causing SLA violations?

You can fix Teradata query misclassification by autonomously analyzing and adjusting workload classification rules, filters, and priorities. This Skill adds or modifies criteria to ensure queries route correctly, directly addressing performance degradation and unmet SLAs.

How do I autonomously configure Teradata workload management rules?

You can autonomously configure Teradata workload management by using MCP tools to analyze and adjust workload definitions. This process involves adding or modifying classification criteria, leveraging predefined templates, and verifying changes for improved routing.

Can I add fine-grained criteria like MINSTEPTIME to Teradata workload filters?

Yes, you can add fine-grained sub-criteria like MINSTEPTIME and FTSCAN to Teradata workload filters. This provides precise management of query execution time and scan types to ensure accurate classification within your workload rulesets.

What's the best way to route critical ETL queries to a higher priority workload?

The best way to route critical ETL queries is to add a new classification rule to the appropriate filter, such as matching the ETL_LOADER application within an ETL_FILTER. This ensures they are correctly routed to improve ETL job performance.

Does this workload classification adjustment use predefined templates?

Yes, workload classification adjustment uses predefined templates for common classification patterns based on application, user, or query complexity. This template-driven configuration streamlines the process of adding or modifying rules.

Why are my Teradata database queries misclassified despite existing rulesets?

Teradata database queries are often misclassified when existing workload rulesets lack the necessary criteria to distinguish them. Autonomously adding sub-criteria like FTSCAN or MINSTEPTIME resolves this by enabling finer query distinction and proper routing.