| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | monikerRange | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.dm_exec_compute_pools (Transact-SQL) |
sys.dm_exec_compute_pools (Transact-SQL) |
rwestMSFT |
randolphwest |
02/24/2023 |
sql |
system-objects |
reference |
|
|
|
>=sql-server-ver15||>=sql-server-linux-2017 |
[!INCLUDEsqlserver2019]
| 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. |
On [!INCLUDEssNoVersion_md], requires VIEW SERVER STATE permission.
Requires VIEW SERVER PERFORMANCE STATE permission on the server.
[What are [!INCLUDEbig-data-clusters-2019]](../../big-data-cluster/big-data-cluster-overview.md)?