sys.dm_exec_compute_pools (Transact-SQL)

Applies to: yesSQL 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.

See Also

What are SQL Server Big Data Clusters?