get_tempdb_usage
Identify top tempdb consumers per session in Azure SQL Database, showing user and internal object allocations and net usage in MB to pinpoint performance bottlenecks.
Instructions
Get per-session tempdb consumption: user/internal object allocations and net usage in MB.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Maximum sessions to return (largest tempdb consumers first, max 1000). | |
| database_name | No | Optional database name. Defaults to AZURE_SQL_DEFAULT_DATABASE. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||