Skip to content

sys-dm-exec-compute-pools.md

Latest commit

 

History

History
38 lines (33 loc) · 1.37 KB

sys-dm-exec-compute-pools.md

File metadata and controls

38 lines (33 loc) · 1.37 KB
title sys.dm_exec_compute_pools (Transact-SQL) | Microsoft Docs
ms.custom
ms.date 11/04/2019
ms.prod sql
ms.prod_service database-engine, big-data-clusters
ms.reviewer
ms.technology system-objects
ms.topic language-reference
f1_keywords
sys.dm_exec_compute_pools
dm_exec_compute_pools_TSQL
dm_exec_compute_pools
dev_langs
TSQL
helpviewer_keywords
sys.dm_exec_compute_pools dynamic management view
ms.assetid
author MikeRayMSFT
ms.author mikeray
monikerRange >=sql-server-ver15||=sqlallproducts-allversions||>=sql-server-linux-2017

sys.dm_exec_compute_pools (Transact-SQL)

[!INCLUDEtsql-appliesto-ssver15-xxxx-xxxx-xxx_md]

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 [!INCLUDEssNoVersion_md], requires VIEW SERVER STATE permission.

See Also

[What are [!INCLUDEbig-data-clusters-2019]](../../big-data-cluster/big-data-cluster-overview.md)?