Edit

Share via


sys.dm_exec_compute_pools (Transact-SQL)

Applies to: SQL Server 2019 (15.x)

Column name Data type Description
name sysname Name of the compute pool. Is not nullable. Returns default for the default compute pool.
compute_pool_id int Unique identifier for the pool. Key for this view.
location sysname Endpoint to controller in a SQL Big Data cluster. Is not nullable.

Permissions

On SQL Server, requires VIEW SERVER STATE permission.

Permissions for SQL Server 2022 and later

Requires VIEW SERVER PERFORMANCE STATE permission on the server.

See also

What are SQL Server Big Data Clusters?