monitor-queries

Monitor Teradata query execution with real-time resources and historical logs.

7|Updated Dec 3, 2025

Search Tags:#performance analysis #workload management #teradata #query monitoring #tdwm-mcp #query logs

Ready to run

npx skills add https://github.com/teradata-labs/claude-cookbooks --skill monitor-queries

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: monitor-queries
Source: https://github.com/teradata-labs/claude-cookbooks/tree/main/skills/operations/workloadmanagement/monitoring/monitor-queries
Command: npx skills add https://github.com/teradata-labs/claude-cookbooks --skill monitor-queries

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill helps you understand and diagnose query performance issues by tracking execution, analyzing query bands, and reviewing historical logs.

Core Features & Use Cases

Real-time Monitoring: Instantly view active queries and their resource usage.
Historical Analysis: Investigate past query performance and identify trends.
Classification Insights: Understand how queries are categorized and if they are hitting throttles.
Use Case: If users report slow queries, you can use this skill to quickly see which queries are running, how long they've been active, and if they are being delayed by workload management rules.

Quick Start

Show me the current query activity across all workloads.

Frequently Asked Questions about monitor-queries

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

FAQPage Schema

How do I monitor Teradata query execution in real-time?▼

You can monitor Teradata query execution in real-time by tracking active queries and their system resource usage. This skill leverages real-time data streams to instantly view current query activity across all workloads.

Why are my Teradata queries being delayed by workload management rules?▼

Queries are delayed by workload management rules when they hit throttling limits or are misclassified. This skill diagnoses workload classification and throttling issues by analyzing query bands and reviewing system resource allocation.

How do I analyze historical query logs to identify performance trends?▼

You can analyze historical query logs to identify performance trends by investigating past query execution data. This skill reviews historical logs to help you understand past query performance and pinpoint recurring performance patterns.

What is the best way to diagnose slow query performance using query bands?▼

The best way to diagnose slow query performance using query bands is to analyze how queries are categorized and identify if they are hitting throttles. This skill tracks execution and analyzes query bands to pinpoint performance issues.

Can I use tdwm-mcp tools to track active queries and their resource usage?▼

Yes, you can use tdwm-mcp tools to track active queries and their resource usage. This skill leverages tdwm-mcp tools and real-time system resources to provide comprehensive insight into query execution and workload management.