sys.dm_os_memory_pools

Description

Analytics Platform System (PDW) Returns a row for each object store in the instance of SQL Server. You can use this view to monitor cache memory use and to identify bad caching behavior Memory address of the entry that represents the ID of a specific pool within a set of pools. Is not nullable. Type of object pool. Is not nullable. For more sys.dm_os_memory_clerks (Transact- System-assigned name of this memory object.

Permissions

Analytics Platform System (PDW) SQL database in Microsoft Fabric Returns a row for each object store in the instance of SQL Server. You can use this view to monitor cache memory use and to identify bad caching behavior Memory address of the entry that represents the memory pool. Is not nullable. ID of a specific pool within a set of pools. Is not nullable. Type of object pool. Is not nullable. For more information, see sys.dm_os_memory_clerks (Transact- SQL). System-assigned name of this memory object. Is not nullable. Maximum number of free entries that a pool can have. Is not nullable. Number of free entries currently in the pool. Is not nullable. Number of entries removed from the pool since the instance of SQL Server was started. Is not nullable. : Azure Synapse Analytics, Analytics Platform System (PDW) The identifier for the node that this distribution is on. ７ To call this from Azure Synapse Analytics or Analytics Platform System (PDW), use the name. This syntax is not supported by serverless SQL pool in Azure Synapse Analytics. ﾉ