Class ResourceGovernorSchema.Configuration

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

sys.resource_governor_configuration (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

Returns the stored Resource Governor state.

See sys.resource_governor_configuration.

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

Inheritance

object

ResourceGovernorSchema.Configuration

Extension Methods

Map.DeepCopy<T>(T)

Properties

ClassifierFunctionID

The ID of the classifier function as it is stored in the metadata. Is not nullable.

Note This function is used to classify new sessions and uses rules to route the workload to the appropriate workload group. For more information, see Resource Governor.

[Column("classifier_function_id")]
[NotNull]
public int ClassifierFunctionID { get; set; }

Property Value

int

IsEnabled

Indicates the current state of the Resource Governor:

0 = Resource Governor is not enabled.

1 = Resource Governor is enabled.

Is not nullable.

[Column("is_enabled")]
[NotNull]
public bool IsEnabled { get; set; }

Property Value

bool

MaxOutstandingIoPerVolume

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

The maximum number of outstanding I/O per volume.

[Column("max_outstanding_io_per_volume")]
[NotNull]
public int MaxOutstandingIoPerVolume { get; set; }

Property Value

int