skills.rest
teradata-labs
teradata-labsOFFICIAL
Explore all skills by this author →
WebsiteGitHub

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
One-click install
npx skills add https://github.com/teradata-labs/claude-cookbooks --skill monitor-queries
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
teradata-labsteradata-labs
7

monitor-resources

Monitor Teradata AMP processor load, CPU, memory, and I/O utilization in real-time.

Official
Advanced
teradata-labsteradata-labs
7

manage-workloads

Automate creation and management of Teradata workload filters, throttles, and classification rules.

Official
Advanced
interflownexinterflownex
2

alloydb-postgres-monitor

Monitor AlloyDB for PostgreSQL query performance, system metrics, and lock states.

Community
Advanced
jeremylongshorejeremylongshore
2.6k

monitoring-database-health

Monitor PostgreSQL and MySQL database health with real-time metrics and alerts.

Community
Advanced