Class ResourceGovernorSchema.DataContext

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

public class ResourceGovernorSchema.DataContext

Inheritance

object

ResourceGovernorSchema.DataContext

Extension Methods

Map.DeepCopy<T>(T)

Constructors

DataContext(IDataContext)

public DataContext(IDataContext dataContext)

Parameters

dataContext IDataContext

Properties

Configurations

sys.resource_governor_configuration (Transact-SQL)

Applies to: √ SQL Server (all supported versions)

Returns the stored Resource Governor state.

See sys.resource_governor_configuration.

public ITable<ResourceGovernorSchema.Configuration> Configurations { get; }

Property Value

ITable<ResourceGovernorSchema.Configuration>

ExternalResourcePools

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.

public ITable<ResourceGovernorSchema.ExternalResourcePool> ExternalResourcePools { get; }

Property Value

ITable<ResourceGovernorSchema.ExternalResourcePool>

ResourcePools

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.

public ITable<ResourceGovernorSchema.ResourcePool> ResourcePools { get; }

Property Value

ITable<ResourceGovernorSchema.ResourcePool>

WorkloadGroups

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.

public ITable<ResourceGovernorSchema.WorkloadGroup> WorkloadGroups { get; }

Property Value

ITable<ResourceGovernorSchema.WorkloadGroup>