types
SQLServerConfig2016sp2ent
SQL Server 2016 SP2 Enterprise edition supported configuration options are listed here.
Detailed description for each set of options is available in SQL Server documentation.
Any options that are not listed here are not supported.
maxDegreeOfParallelism : google.protobuf.Int64Value
Limits the number of processors to use in parallel plan execution per task.
See in-depth description in SQL Server documentation.
costThresholdForParallelism : google.protobuf.Int64Value
Specifies the threshold at which SQL Server creates and runs parallel plans for queries.
SQL Server creates and runs a parallel plan for a query only when the estimated cost to run a serial plan for the same query is higher than the value of the option.
See in-depth description in SQL Server documentation.
auditLevel : google.protobuf.Int64Value
Describes how to configure login auditing to monitor SQL Server Database Engine login activity.
Possible values:
- 0 - do not log login attempts;
- 1 - log only failed login attempts;
- 2 - log only successful login attempts (not recommended);
- 3 - log all login attempts (not recommended).
See in-depth description in SQL Server documentation.
fillFactorPercent : google.protobuf.Int64Value
Manages the fill factor server configuration option. When an index is created or rebuilt, the fill factor determines the percentage of space on each index leaf-level page to be filled with data, reserving the rest as free space for future growth.
Values 0 and 100 mean full page usage (no space reserved).
See in-depth description in SQL Server documentation.
optimizeForAdHocWorkloads : google.protobuf.BoolValue
Determines whether plans should be cached only after second execution.
Allows to avoid SQL cache bloat because of single-use plans.
See in-depth description in SQL Server documentation.
SQLServerConfig2016sp2std
SQL Server 2016 SP2 Standard edition supported configuration options are listed here.
Detailed description for each set of options is available in SQL Server documentation.
Any options that are not listed here are not supported.
maxDegreeOfParallelism : google.protobuf.Int64Value
Limits the number of processors to use in parallel plan execution per task.
See in-depth description in SQL Server documentation.
costThresholdForParallelism : google.protobuf.Int64Value
Specifies the threshold at which SQL Server creates and runs parallel plans for queries.
SQL Server creates and runs a parallel plan for a query only when the estimated cost to run a serial plan for the same query is higher than the value of the option.
See in-depth description in SQL Server documentation.
auditLevel : google.protobuf.Int64Value
Describes how to configure login auditing to monitor SQL Server Database Engine login activity.
Possible values:
- 0 - do not log login attempts;
- 1 - log only failed login attempts;
- 2 - log only successful login attempts (not recommended);
- 3 - log all login attempts (not recommended).
See in-depth description in SQL Server documentation.
fillFactorPercent : google.protobuf.Int64Value
Manages the fill factor server configuration option.
When an index is created or rebuilt, the fill factor determines the percentage of space on each index leaf-level page to be filled with data, reserving the rest as free space for future growth.
Values 0 and 100 mean full page usage (no space reserved).
See in-depth description in SQL Server documentation.
optimizeForAdHocWorkloads : google.protobuf.BoolValue
Determines whether plans should be cached only after second execution.
Allows to avoid SQL cache bloat because of single-use plans.
See in-depth description in SQL Server documentation.
SQLServerConfig2017ent
SQL Server 2017 Enterprise edition supported configuration options are listed here.
Detailed description for each set of options is available in SQL Server documentation.
Any options that are not listed here are not supported.
maxDegreeOfParallelism : google.protobuf.Int64Value
Limits the number of processors to use in parallel plan execution per task.
See in-depth description in SQL Server documentation.
costThresholdForParallelism : google.protobuf.Int64Value
Specifies the threshold at which SQL Server creates and runs parallel plans for queries.
SQL Server creates and runs a parallel plan for a query only when the estimated cost to run a serial plan for the same query is higher than the value of the option.
See in-depth description in SQL Server documentation.
auditLevel : google.protobuf.Int64Value
Describes how to configure login auditing to monitor SQL Server Database Engine login activity.
Possible values:
- 0 - do not log login attempts;
- 1 - log only failed login attempts;
- 2 - log only successful login attempts (not recommended);
- 3 - log all login attempts (not recommended).
See in-depth description in SQL Server documentation.
fillFactorPercent : google.protobuf.Int64Value
Manages the fill factor server configuration option. When an index is created or rebuilt, the fill factor determines the percentage of space on each index leaf-level page to be filled with data, reserving the rest as free space for future growth.
Values 0 and 100 mean full page usage (no space reserved).
See in-depth description in SQL Server documentation.
optimizeForAdHocWorkloads : google.protobuf.BoolValue
Determines whether plans should be cached only after second execution.
Allows to avoid SQL cache bloat because of single-use plans.
See in-depth description in SQL Server documentation.
SQLServerConfig2017std
SQL Server 2017 Standard edition supported configuration options are listed here.
Detailed description for each set of options is available in SQL Server documentation.
Any options that are not listed here are not supported.
maxDegreeOfParallelism : google.protobuf.Int64Value
Limits the number of processors to use in parallel plan execution per task.
See in-depth description in SQL Server documentation.
costThresholdForParallelism : google.protobuf.Int64Value
Specifies the threshold at which SQL Server creates and runs parallel plans for queries.
SQL Server creates and runs a parallel plan for a query only when the estimated cost to run a serial plan for the same query is higher than the value of the option.
See in-depth description in SQL Server documentation.
auditLevel : google.protobuf.Int64Value
Describes how to configure login auditing to monitor SQL Server Database Engine login activity.
Possible values:
- 0 - do not log login attempts;
- 1 - log only failed login attempts;
- 2 - log only successful login attempts (not recommended);
- 3 - log all login attempts (not recommended).
See in-depth description in SQL Server documentation.
fillFactorPercent : google.protobuf.Int64Value
Manages the fill factor server configuration option.
When an index is created or rebuilt, the fill factor determines the percentage of space on each index leaf-level page to be filled with data, reserving the rest as free space for future growth.
Values 0 and 100 mean full page usage (no space reserved).
See in-depth description in SQL Server documentation.
optimizeForAdHocWorkloads : google.protobuf.BoolValue
Determines whether plans should be cached only after second execution.
Allows to avoid SQL cache bloat because of single-use plans.
See in-depth description in SQL Server documentation.
SQLServerConfig2019ent
SQL Server 2019 Enterprise edition supported configuration options are listed here.
Detailed description for each set of options is available in SQL Server documentation.
Any options that are not listed here are not supported.
maxDegreeOfParallelism : google.protobuf.Int64Value
Limits the number of processors to use in parallel plan execution per task.
See in-depth description in SQL Server documentation.
costThresholdForParallelism : google.protobuf.Int64Value
Specifies the threshold at which SQL Server creates and runs parallel plans for queries.
SQL Server creates and runs a parallel plan for a query only when the estimated cost to run a serial plan for the same query is higher than the value of the option.
See in-depth description in SQL Server documentation.
auditLevel : google.protobuf.Int64Value
Describes how to configure login auditing to monitor SQL Server Database Engine login activity.
Possible values:
- 0 - do not log login attempts;
- 1 - log only failed login attempts;
- 2 - log only successful login attempts (not recommended);
- 3 - log all login attempts (not recommended).
See in-depth description in SQL Server documentation.
fillFactorPercent : google.protobuf.Int64Value
Manages the fill factor server configuration option. When an index is created or rebuilt, the fill factor determines the percentage of space on each index leaf-level page to be filled with data, reserving the rest as free space for future growth.
Values 0 and 100 mean full page usage (no space reserved).
See in-depth description in SQL Server documentation.
optimizeForAdHocWorkloads : google.protobuf.BoolValue
Determines whether plans should be cached only after second execution.
Allows to avoid SQL cache bloat because of single-use plans.
See in-depth description in SQL Server documentation.
SQLServerConfig2019std
SQL Server 2019 Standard edition supported configuration options are listed here.
Detailed description for each set of options is available in SQL Server documentation.
Any options that are not listed here are not supported.
maxDegreeOfParallelism : google.protobuf.Int64Value
Limits the number of processors to use in parallel plan execution per task.
See in-depth description in SQL Server documentation.
costThresholdForParallelism : google.protobuf.Int64Value
Specifies the threshold at which SQL Server creates and runs parallel plans for queries.
SQL Server creates and runs a parallel plan for a query only when the estimated cost to run a serial plan for the same query is higher than the value of the option.
See in-depth description in SQL Server documentation.
auditLevel : google.protobuf.Int64Value
Describes how to configure login auditing to monitor SQL Server Database Engine login activity.
Possible values:
- 0 - do not log login attempts;
- 1 - log only failed login attempts;
- 2 - log only successful login attempts (not recommended);
- 3 - log all login attempts (not recommended).
See in-depth description in SQL Server documentation.
fillFactorPercent : google.protobuf.Int64Value
Manages the fill factor server configuration option.
When an index is created or rebuilt, the fill factor determines the percentage of space on each index leaf-level page to be filled with data, reserving the rest as free space for future growth.
Values 0 and 100 mean full page usage (no space reserved).
See in-depth description in SQL Server documentation.
optimizeForAdHocWorkloads : google.protobuf.BoolValue
Determines whether plans should be cached only after second execution.
Allows to avoid SQL cache bloat because of single-use plans.
See in-depth description in SQL Server documentation.
SQLServerConfigSet2016sp2ent
effectiveConfig : SQLServerConfig2016sp2ent
Effective settings for an SQL Server 2016 SP2 cluster (a combination of settings defined in user_config and default_config).
userConfig : SQLServerConfig2016sp2ent
User-defined settings for an SQL Server 2016 SP2 cluster.
defaultConfig : SQLServerConfig2016sp2ent
Default configuration for an SQL Server 2016 SP2 cluster.
SQLServerConfigSet2016sp2std
effectiveConfig : SQLServerConfig2016sp2std
Effective settings for an SQL Server 2016 SP2 cluster (a combination of settings defined in user_config and default_config).
userConfig : SQLServerConfig2016sp2std
User-defined settings for an SQL Server 2016 SP2 cluster.
defaultConfig : SQLServerConfig2016sp2std
Default configuration for an SQL Server 2016 SP2 cluster.
SQLServerConfigSet2017ent
effectiveConfig : SQLServerConfig2017ent
Effective settings for an SQL Server 2017 cluster (a combination of settings defined in user_config and default_config).
userConfig : SQLServerConfig2017ent
User-defined settings for an SQL Server 2017 cluster.
defaultConfig : SQLServerConfig2017ent
Default configuration for an SQL Server 2017 cluster.
SQLServerConfigSet2017std
effectiveConfig : SQLServerConfig2017std
Effective settings for an SQL Server 2017 cluster (a combination of settings defined in user_config and default_config).
userConfig : SQLServerConfig2017std
User-defined settings for an SQL Server 2017 cluster.
defaultConfig : SQLServerConfig2017std
Default configuration for an SQL Server 2017 cluster.
SQLServerConfigSet2019ent
effectiveConfig : SQLServerConfig2019ent
Effective settings for an SQL Server 2019 cluster (a combination of settings defined in user_config and default_config).
userConfig : SQLServerConfig2019ent
User-defined settings for an SQL Server 2019 cluster.
defaultConfig : SQLServerConfig2019ent
Default configuration for an SQL Server 2019 cluster.
SQLServerConfigSet2019std
effectiveConfig : SQLServerConfig2019std
Effective settings for an SQL Server 2019 cluster (a combination of settings defined in user_config and default_config).
userConfig : SQLServerConfig2019std
User-defined settings for an SQL Server 2019 cluster.
defaultConfig : SQLServerConfig2019std
Default configuration for an SQL Server 2019 cluster.