Class ResourceGovernorSchema.ResourcePool

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

sys.resource_governor_resource_pools (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

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

See sys.resource_governor_resource_pools.

[Table(Schema = "sys", Name = "resource_governor_resource_pools", IsView = true)]
public class ResourceGovernorSchema.ResourcePool

Inheritance

object

ResourceGovernorSchema.ResourcePool

Extension Methods

Map.DeepCopy<T>(T)

Properties

CapCpuPercent

Applies to: SQL Server 2012 (11.x) and later.

Hard cap on the CPU bandwidth that all requests in the resource pool will receive. Limits the maximum CPU bandwidth to the specified level. The allowed range for value is from 1 through 100.

[Column("cap_cpu_percent")]
[NotNull]
public int CapCpuPercent { 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

MaxIopsPerVolume

Applies to: SQL Server 2014 (12.x) and later.

The maximum I/O operations per second (IOPS) per volume setting for this pool. 0 = unlimited. Cannot be null.

[Column("max_iops_per_volume")]
[NotNull]
public int MaxIopsPerVolume { 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

MinCpuPercent

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

[Column("min_cpu_percent")]
[NotNull]
public int MinCpuPercent { get; set; }

Property Value

int

MinIopsPerVolume

Applies to: SQL Server 2014 (12.x) and later.

The minimum I/O operations per second (IOPS) per volume setting for this pool. 0 = no reservation. Cannot be null.

[Column("min_iops_per_volume")]
[NotNull]
public int MinIopsPerVolume { get; set; }

Property Value

int

MinMemoryPercent

Guaranteed amount of memory for all requests in the resource pool. This is not shared with other resource pools. Is not nullable.

[Column("min_memory_percent")]
[NotNull]
public int MinMemoryPercent { 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

PoolID

Unique ID of the resource pool. Is not nullable.

[Column("pool_id")]
[NotNull]
public int PoolID { get; set; }

Property Value

int