Developer Workflow / Data Workflow
Identify SQL Server Performance Bottlenecks Using DMV Queries
Identify SQL Server performance bottlenecks using DMV queries. Covers wait stats, slow queries, active requests, performance counters, and connection analysis.
Use Cases
- Use Identify SQL Server Performance Bottlenecks Using DMV Queries to handle repeatable data workflow tasks in a local AI agent workflow.
- Turn an ad hoc developer workflow request into a structured checklist the agent can follow.
- Prepare inputs, expected outputs, and verification steps before running the workflow.