get_memory_grants
Retrieve active and pending memory grants to identify queries waiting for memory or likely to spill to tempdb.
Instructions
Get active and pending memory grants. Identifies queries waiting for memory (RESOURCE_SEMAPHORE) and queries likely spilling to tempdb.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database_name | No | Optional database name. Defaults to AZURE_SQL_DEFAULT_DATABASE. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||