Table of Contents

Class ResourceGovernorSchema.ExternalResourcePool

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

sys.resource_governor_external_resource_pools (Transact-SQL)

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

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.


See sys.resource_governor_external_resource_pools.

[Table(Schema = "sys", Name = "resource_governor_external_resource_pools", IsView = true)]
public class ResourceGovernorSchema.ExternalResourcePool
Inheritance
ResourceGovernorSchema.ExternalResourcePool
Extension Methods

Properties

ExternalPoolID

Unique ID of the resource pool. Is not nullable.

[Column("external_pool_id")]
[NotNull]
public int ExternalPoolID { get; set; }

Property Value

int

MaxCpuPercent

Maximum average CPU bandwidth allowed for all requests in the resource pool when there is CPU contention. Is not nullable.

[Column("max_cpu_percent")]
[NotNull]
public int MaxCpuPercent { get; set; }

Property Value

int

MaxMemoryPercent

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.

[Column("max_memory_percent")]
[NotNull]
public int MaxMemoryPercent { get; set; }

Property Value

int

MaxProcesses

Maximum number of concurrent external processes. The default value, 0, specifies no limit. Is not nullable.

[Column("max_processes")]
[NotNull]
public int MaxProcesses { get; set; }

Property Value

int

Name

Name of the resource pool. Is not nullable.

[Column("name")]
[NotNull]
public string Name { get; set; }

Property Value

string

Version

Internal version number.

[Column("version")]
[NotNull]
public long Version { get; set; }

Property Value

long