dba_resusageSummary

Analyze Teradata system resource usage by time periods, workload types, and complexity levels to identify performance patterns and optimize database operations.

Instructions

Get the Teradata system usage summary metrics by weekday and hour for each workload type and query complexity bucket.

Arguments: dimensions - list of dimensions to aggregate the resource usage summary. All dimensions are: ["LogDate", "hourOfDay", "dayOfWeek", "workloadType", "workloadComplexity", "UserName", "AppId"] user_name - user name date - Date to analyze, formatted as YYYY-MM-DD dayOfWeek - day of the week to analyze hourOfDay - hour of day to analyze workloadType - workload type to analyze, example: 'LOAD', 'ETL/ELT', 'EXPORT', 'QUERY', 'ADMIN', 'OTHER' workloadComplexity - workload complexity to analyze, example: 'Ingest & Prep', 'Answers', 'System/Procedural' AppId - Application ID to analyze, example: 'TPTLOAD%', 'TPTUPD%', 'FASTLOAD%', 'MULTLOAD%', 'EXECUTOR%', 'JDBC%'

Input Schema

Name	Required	Description	Default
`AppId`	No
`date`	No
`dayOfWeek`	No
`dimensions`	No
`hourOfDay`	No
`user_name`	No
`workloadComplexity`	No
`workloadType`	No

Input Schema (JSON Schema)

{ "properties": { "AppId": { "anyOf": [ { "type": "string" }, { "type": "null" } ], "default": null, "title": "Appid" }, "date": { "anyOf": [ { "type": "string" }, { "type": "null" } ], "default": null, "title": "Date" }, "dayOfWeek": { "anyOf": [ { "type": "string" }, { "type": "null" } ], "default": null, "title": "Dayofweek" }, "dimensions": { "anyOf": [ { "items": { "type": "string" }, "type": "array" }, { "type": "null" } ], "default": null, "title": "Dimensions" }, "hourOfDay": { "anyOf": [ { "type": "string" }, { "type": "null" } ], "default": null, "title": "Hourofday" }, "user_name": { "anyOf": [ { "type": "string" }, { "type": "null" } ], "default": null, "title": "User Name" }, "workloadComplexity": { "anyOf": [ { "type": "string" }, { "type": "null" } ], "default": null, "title": "Workloadcomplexity" }, "workloadType": { "anyOf": [ { "type": "string" }, { "type": "null" } ], "default": null, "title": "Workloadtype" } }, "type": "object" }

Teradata MCP Server