Intelligent workload management, a serverless SQL warehouse capability that forecasts the resources each query will need, holds queries in a queue when capacity runs short and scales out clusters rapidly.
Also called Intelligent Workload Management.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains IWM in context, with comparison tables and the common traps.
Terms in this definition
- Serverless
Compute tier for single Azure SQL databases that scales automatically, pauses when idle and charges by the second. It is offered in General Purpose and Hyperscale, not Business Critical, and reserved capacity does not apply.
- SQL warehouse
Compute dedicated to running SQL queries, dashboards and BI tools, available as serverless, pro or classic. Serverless is the recommended type where offered, and every type runs Photon by default.
- Capability
Something that a person, organisation or system is able to do.
- Capacity
A reserved block of compute for a tenant whose size is fixed by its SKU; Fabric F SKUs express it in capacity units (CUs). Workspaces assigned to it unlock features like Copilot, and from F64 upwards people with free licences can view Power BI content.
- Agents (classic) API
First-generation Foundry Agent Service API, based on threads, messages and runs. It is deprecated, replaced by conversations and responses, and retires on 31 March 2027.