Muokkaa

Jaa


sys.resource_governor_external_resource_pools (Transact-SQL)

Applies to: SQL Server 2016 (13.x) and later versions

Applies to: SQL Server 2016 (13.x) R Services (In-Database) and SQL Server 2017 (14.x) Machine Learning Services

Returns the stored external resource pool configuration in SQL Server. Each row of the view determines the configuration of a pool.

Column name Data type Description
external_pool_id int Unique ID of the resource pool. Is not nullable.
name sysname Name of the resource pool. Is not nullable.
max_cpu_percent int Maximum average CPU bandwidth allowed for all requests in the resource pool when there is CPU contention. Is not nullable.
max_memory_percent int Percentage of total server memory that can be used by requests in this resource pool. Is not nullable. The effective maximum depends on the pool minimums. For example, max_memory_percent can be set to 100, but the effective maximum is lower.
max_processes int Maximum number of concurrent external processes. The default value, 0, specifies no limit. Is not nullable.
version bigint Internal version number.

Permissions

Requires VIEW SERVER STATE permission.

See also

Resource governance for machine learning in SQL Server

Resource Governor Catalog Views (Transact-SQL)

sys.dm_resource_governor_resource_pools (Transact-SQL)

Resource Governor

sys.dm_resource_governor_resource_pool_affinity (Transact-SQL)

external scripts enabled Server Configuration Option

ALTER EXTERNAL RESOURCE POOL (Transact-SQL)