Class ResourceGovernorSchema.WorkloadGroup

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

sys.resource_governor_workload_groups (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

Returns the stored workload group configuration in SQL Server. Each workload group can subscribe to one and only one resource pool.

See sys.resource_governor_workload_groups.

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

Inheritance

object

ResourceGovernorSchema.WorkloadGroup

Extension Methods

Map.DeepCopy<T>(T)

Properties

ExternalPoolID

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

ID of the external resource pool that this workload group uses.

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

Property Value

int

GroupID

Unique ID of the workload group. Is not nullable.

[Column("group_id")]
[NotNull]
public int GroupID { get; set; }

Property Value

int

GroupMaxRequests

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

[Column("group_max_requests")]
[NotNull]
public int GroupMaxRequests { get; set; }

Property Value

int

Importance

Note: Importance only applies to workload groups in the same resource pool.

Is the relative importance of a request in this workload group. Importance is one of the following, with MEDIUM being the default: LOW, MEDIUM, HIGH.

Is not nullable.

[Column("importance")]
[NotNull]
public string Importance { get; set; }

Property Value

string

MaxDop

Maximum degree of parallelism for the workload group. The default value, 0, uses global settings. Is not nullable.

Node: This setting will override the query option maxdop.

[Column("max_dop")]
[NotNull]
public int MaxDop { get; set; }

Property Value

int

Name

Name of the workload group. Is not nullable.

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

Property Value

string

PoolID

ID of the resource pool that this workload group uses.

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

Property Value

int

RequestMaxCpuTimeSec

Maximum CPU use limit, in seconds, for a single request. The default value, 0, specifies no limit. Is not nullable.

Note: For more information, see CPU Threshold Exceeded Event Class.

[Column("request_max_cpu_time_sec")]
[NotNull]
public int RequestMaxCpuTimeSec { get; set; }

Property Value

int

RequestMaxMemoryGrantPercent

Maximum memory grant, as a percentage, for a single request. The default value is 25. Is not nullable.

Note: If this setting is higher than 50 percent, large queries will run one at a time. Therefore, there is greater risk of getting an out-of-memory error while the query is running.

[Column("request_max_memory_grant_percent")]
[NotNull]
public int RequestMaxMemoryGrantPercent { get; set; }

Property Value

int

RequestMemoryGrantTimeoutSec

Memory grant time-out, in seconds, for a single request. The default value, 0, uses an internal calculation based on query cost. Is not nullable.

[Column("request_memory_grant_timeout_sec")]
[NotNull]
public int RequestMemoryGrantTimeoutSec { get; set; }

Property Value

int