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)
sys.dm_resource_governor_resource_pool_affinity (Transact-SQL)
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें