detect_query_bottlenecks
Identify and analyze database query performance issues to optimize SQL Server execution efficiency and resolve bottlenecks.
Instructions
Detect and analyze query bottlenecks in the database
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | No | Database name (optional) | |
| limit | No | Maximum number of bottlenecks to return (optional, defaults to 10) | |
| severity_filter | No | Filter by severity level: LOW, MEDIUM, HIGH, CRITICAL (optional) |
Input Schema (JSON Schema)
{
"properties": {
"database": {
"description": "Database name (optional)",
"type": "string"
},
"limit": {
"description": "Maximum number of bottlenecks to return (optional, defaults to 10)",
"type": "number"
},
"severity_filter": {
"description": "Filter by severity level: LOW, MEDIUM, HIGH, CRITICAL (optional)",
"enum": [
"LOW",
"MEDIUM",
"HIGH",
"CRITICAL"
],
"type": "string"
}
},
"type": "object"
}