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.

Related content

• What are SQL Server Big Data Clusters