Подключиться
Yandex Managed Service for SQL Server™

Cluster

Статья создана

A set of methods for managing SQL Server clusters.

JSON Representation

{
  "id": "string",
  "folderId": "string",
  "createdAt": "string",
  "name": "string",
  "description": "string",
  "labels": "object",
  "environment": "string",
  "monitoring": [
    {
      "name": "string",
      "description": "string",
      "link": "string"
    }
  ],
  "config": {
    "version": "string",
    "resources": {
      "resourcePresetId": "string",
      "diskSize": "string",
      "diskTypeId": "string"
    },
    "backupWindowStart": {
      "hours": "integer",
      "minutes": "integer",
      "seconds": "integer",
      "nanos": "integer"
    },
    "access": {
      "dataLens": true,
      "webSql": true
    },
    "secondaryConnections": "string",

    // `config` includes only one of the fields `sqlserverConfig_2016Sp2Std`, `sqlserverConfig_2016Sp2Ent`, `sqlserverConfig_2017Std`, `sqlserverConfig_2017Ent`, `sqlserverConfig_2019Std`, `sqlserverConfig_2019Ent`
    "sqlserverConfig_2016Sp2Std": {
      "effectiveConfig": {
        "maxDegreeOfParallelism": "integer",
        "costThresholdForParallelism": "integer",
        "auditLevel": "integer",
        "fillFactorPercent": "integer",
        "optimizeForAdHocWorkloads": true
      },
      "userConfig": {
        "maxDegreeOfParallelism": "integer",
        "costThresholdForParallelism": "integer",
        "auditLevel": "integer",
        "fillFactorPercent": "integer",
        "optimizeForAdHocWorkloads": true
      },
      "defaultConfig": {
        "maxDegreeOfParallelism": "integer",
        "costThresholdForParallelism": "integer",
        "auditLevel": "integer",
        "fillFactorPercent": "integer",
        "optimizeForAdHocWorkloads": true
      }
    },
    "sqlserverConfig_2016Sp2Ent": {
      "effectiveConfig": {
        "maxDegreeOfParallelism": "integer",
        "costThresholdForParallelism": "integer",
        "auditLevel": "integer",
        "fillFactorPercent": "integer",
        "optimizeForAdHocWorkloads": true
      },
      "userConfig": {
        "maxDegreeOfParallelism": "integer",
        "costThresholdForParallelism": "integer",
        "auditLevel": "integer",
        "fillFactorPercent": "integer",
        "optimizeForAdHocWorkloads": true
      },
      "defaultConfig": {
        "maxDegreeOfParallelism": "integer",
        "costThresholdForParallelism": "integer",
        "auditLevel": "integer",
        "fillFactorPercent": "integer",
        "optimizeForAdHocWorkloads": true
      }
    },
    "sqlserverConfig_2017Std": {
      "effectiveConfig": {
        "maxDegreeOfParallelism": "integer",
        "costThresholdForParallelism": "integer",
        "auditLevel": "integer",
        "fillFactorPercent": "integer",
        "optimizeForAdHocWorkloads": true
      },
      "userConfig": {
        "maxDegreeOfParallelism": "integer",
        "costThresholdForParallelism": "integer",
        "auditLevel": "integer",
        "fillFactorPercent": "integer",
        "optimizeForAdHocWorkloads": true
      },
      "defaultConfig": {
        "maxDegreeOfParallelism": "integer",
        "costThresholdForParallelism": "integer",
        "auditLevel": "integer",
        "fillFactorPercent": "integer",
        "optimizeForAdHocWorkloads": true
      }
    },
    "sqlserverConfig_2017Ent": {
      "effectiveConfig": {
        "maxDegreeOfParallelism": "integer",
        "costThresholdForParallelism": "integer",
        "auditLevel": "integer",
        "fillFactorPercent": "integer",
        "optimizeForAdHocWorkloads": true
      },
      "userConfig": {
        "maxDegreeOfParallelism": "integer",
        "costThresholdForParallelism": "integer",
        "auditLevel": "integer",
        "fillFactorPercent": "integer",
        "optimizeForAdHocWorkloads": true
      },
      "defaultConfig": {
        "maxDegreeOfParallelism": "integer",
        "costThresholdForParallelism": "integer",
        "auditLevel": "integer",
        "fillFactorPercent": "integer",
        "optimizeForAdHocWorkloads": true
      }
    },
    "sqlserverConfig_2019Std": {
      "effectiveConfig": {
        "maxDegreeOfParallelism": "integer",
        "costThresholdForParallelism": "integer",
        "auditLevel": "integer",
        "fillFactorPercent": "integer",
        "optimizeForAdHocWorkloads": true
      },
      "userConfig": {
        "maxDegreeOfParallelism": "integer",
        "costThresholdForParallelism": "integer",
        "auditLevel": "integer",
        "fillFactorPercent": "integer",
        "optimizeForAdHocWorkloads": true
      },
      "defaultConfig": {
        "maxDegreeOfParallelism": "integer",
        "costThresholdForParallelism": "integer",
        "auditLevel": "integer",
        "fillFactorPercent": "integer",
        "optimizeForAdHocWorkloads": true
      }
    },
    "sqlserverConfig_2019Ent": {
      "effectiveConfig": {
        "maxDegreeOfParallelism": "integer",
        "costThresholdForParallelism": "integer",
        "auditLevel": "integer",
        "fillFactorPercent": "integer",
        "optimizeForAdHocWorkloads": true
      },
      "userConfig": {
        "maxDegreeOfParallelism": "integer",
        "costThresholdForParallelism": "integer",
        "auditLevel": "integer",
        "fillFactorPercent": "integer",
        "optimizeForAdHocWorkloads": true
      },
      "defaultConfig": {
        "maxDegreeOfParallelism": "integer",
        "costThresholdForParallelism": "integer",
        "auditLevel": "integer",
        "fillFactorPercent": "integer",
        "optimizeForAdHocWorkloads": true
      }
    },
    // end of the list of possible fields`config`

  },
  "networkId": "string",
  "health": "string",
  "status": "string",
  "securityGroupIds": [
    "string"
  ],
  "deletionProtection": true,
  "sqlcollation": "string",
  "hostGroupIds": [
    "string"
  ],
  "serviceAccountId": "string"
}
Field Description
id string

ID of the SQL Server cluster.

This ID is assigned by Managed Service for SQL Server at the moment of creation.
folderId string

ID of the folder the SQL Server cluster belongs to.
createdAt string (date-time)

Time when SQL Server cluster was created.

String in RFC3339 text format.
name string

Name of the SQL Server cluster.

The name must be unique within the folder, comply with RFC 1035 and be 1-63 characters long.
description string

Description of the SQL Server cluster.

Must be 0-256 characters long.
labels object

Custom labels for the SQL Server cluster as key:value pairs.

Maximum 64 per resource.
environment string

Deployment environment of the SQL Server cluster.

  • PRODUCTION: Stable environment with a conservative update policy: only hotfixes are applied during regular maintenance.
  • PRESTABLE: Environment with more aggressive update policy: new versions are rolled out irrespective of backward compatibility.
monitoring[] object

Description of monitoring systems relevant to the SQL Server cluster.
monitoring[].
name		 string

Name of the monitoring system.
monitoring[].
description		 string

Description of the monitoring system.
monitoring[].
link		 string

Link to the monitoring system charts for the SQL Server cluster.
config object

Configuration of the SQL Server cluster.
config.
version		 string

Version of the SQL Server.
config.
resources		 object
config.
resources.
resourcePresetId		 string

ID of the preset for computational resources available to a host (CPU, memory, etc.).

All available presets are listed in the documentation.
config.
resources.
diskSize		 string (int64)

Volume of the storage available to a host.
config.
resources.
diskTypeId		 string

Type of the storage environment for the host.

Possible values:

  • network-hdd - network HDD drive;
  • network-ssd - network SSD drive;
  • local-ssd - local SSD storage.
config.
backupWindowStart		 object

Represents a time of day. The date and time zone are either not significant or are specified elsewhere. An API may choose to allow leap seconds. Related types are google.type.Date and google.protobuf.Timestamp.
config.
backupWindowStart.
hours		 integer (int32)

Hours of day in 24 hour format. Should be from 0 to 23. An API may choose to allow the value "24:00:00" for scenarios like business closing time.
config.
backupWindowStart.
minutes		 integer (int32)

Minutes of hour of day. Must be from 0 to 59.
config.
backupWindowStart.
seconds		 integer (int32)

Seconds of minutes of the time. Must normally be from 0 to 59. An API may allow the value 60 if it allows leap-seconds.
config.
backupWindowStart.
nanos		 integer (int32)

Fractions of seconds in nanoseconds. Must be from 0 to 999,999,999.
config.
access		 object
config.
access.
dataLens		 boolean (boolean)

Allows access for DataLens.
config.
access.
webSql		 boolean (boolean)

Allows access for Web SQL.
config.
secondaryConnections		 string
Secondary replicas connection mode
  • SECONDARY_CONNECTIONS_OFF: Connections to secondary replicas are prohibited
  • SECONDARY_CONNECTIONS_READ_ONLY: Secondary replicas are read-only
config.
sqlserverConfig_2016Sp2Std		 object
config includes only one of the fields sqlserverConfig_2016Sp2Std, sqlserverConfig_2016Sp2Ent, sqlserverConfig_2017Std, sqlserverConfig_2017Ent, sqlserverConfig_2019Std, sqlserverConfig_2019Ent
config.
sqlserverConfig_2016Sp2Std.
effectiveConfig		 object

Effective settings for an SQL Server 2016 SP2 cluster (a combination of settings defined in userConfig and defaultConfig).

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.
config.
sqlserverConfig_2016Sp2Std.
effectiveConfig.
maxDegreeOfParallelism		 integer (int64)

Limits the number of processors to use in parallel plan execution per task.

See in-depth description in SQL Server documentation.

Acceptable values are 1 to 99, inclusive.
config.
sqlserverConfig_2016Sp2Std.
effectiveConfig.
costThresholdForParallelism		 integer (int64)

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.

Acceptable values are 5 to 32767, inclusive.
config.
sqlserverConfig_2016Sp2Std.
effectiveConfig.
auditLevel		 integer (int64)

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.

Acceptable values are 0 to 3, inclusive.
config.
sqlserverConfig_2016Sp2Std.
effectiveConfig.
fillFactorPercent		 integer (int64)

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.

Acceptable values are 0 to 100, inclusive.
config.
sqlserverConfig_2016Sp2Std.
effectiveConfig.
optimizeForAdHocWorkloads		 boolean (boolean)

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.
config.
sqlserverConfig_2016Sp2Std.
userConfig		 object

User-defined settings for an SQL Server 2016 SP2 cluster.

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.
config.
sqlserverConfig_2016Sp2Std.
userConfig.
maxDegreeOfParallelism		 integer (int64)

Limits the number of processors to use in parallel plan execution per task.

See in-depth description in SQL Server documentation.

Acceptable values are 1 to 99, inclusive.
config.
sqlserverConfig_2016Sp2Std.
userConfig.
costThresholdForParallelism		 integer (int64)

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.

Acceptable values are 5 to 32767, inclusive.
config.
sqlserverConfig_2016Sp2Std.
userConfig.
auditLevel		 integer (int64)

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.

Acceptable values are 0 to 3, inclusive.
config.
sqlserverConfig_2016Sp2Std.
userConfig.
fillFactorPercent		 integer (int64)

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.

Acceptable values are 0 to 100, inclusive.
config.
sqlserverConfig_2016Sp2Std.
userConfig.
optimizeForAdHocWorkloads		 boolean (boolean)

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.
config.
sqlserverConfig_2016Sp2Std.
defaultConfig		 object

Default configuration for an SQL Server 2016 SP2 cluster.

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.
config.
sqlserverConfig_2016Sp2Std.
defaultConfig.
maxDegreeOfParallelism		 integer (int64)

Limits the number of processors to use in parallel plan execution per task.

See in-depth description in SQL Server documentation.

Acceptable values are 1 to 99, inclusive.
config.
sqlserverConfig_2016Sp2Std.
defaultConfig.
costThresholdForParallelism		 integer (int64)

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.

Acceptable values are 5 to 32767, inclusive.
config.
sqlserverConfig_2016Sp2Std.
defaultConfig.
auditLevel		 integer (int64)

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.

Acceptable values are 0 to 3, inclusive.
config.
sqlserverConfig_2016Sp2Std.
defaultConfig.
fillFactorPercent		 integer (int64)

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.

Acceptable values are 0 to 100, inclusive.
config.
sqlserverConfig_2016Sp2Std.
defaultConfig.
optimizeForAdHocWorkloads		 boolean (boolean)

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.
config.
sqlserverConfig_2016Sp2Ent		 object
config includes only one of the fields sqlserverConfig_2016Sp2Std, sqlserverConfig_2016Sp2Ent, sqlserverConfig_2017Std, sqlserverConfig_2017Ent, sqlserverConfig_2019Std, sqlserverConfig_2019Ent
config.
sqlserverConfig_2016Sp2Ent.
effectiveConfig		 object

Effective settings for an SQL Server 2016 SP2 cluster (a combination of settings defined in userConfig and defaultConfig).

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.
config.
sqlserverConfig_2016Sp2Ent.
effectiveConfig.
maxDegreeOfParallelism		 integer (int64)

Limits the number of processors to use in parallel plan execution per task.

See in-depth description in SQL Server documentation.

Acceptable values are 1 to 99, inclusive.
config.
sqlserverConfig_2016Sp2Ent.
effectiveConfig.
costThresholdForParallelism		 integer (int64)

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.

Acceptable values are 5 to 32767, inclusive.
config.
sqlserverConfig_2016Sp2Ent.
effectiveConfig.
auditLevel		 integer (int64)

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.

Acceptable values are 0 to 3, inclusive.
config.
sqlserverConfig_2016Sp2Ent.
effectiveConfig.
fillFactorPercent		 integer (int64)

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.

Acceptable values are 0 to 100, inclusive.
config.
sqlserverConfig_2016Sp2Ent.
effectiveConfig.
optimizeForAdHocWorkloads		 boolean (boolean)

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.
config.
sqlserverConfig_2016Sp2Ent.
userConfig		 object

User-defined settings for an SQL Server 2016 SP2 cluster.

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.
config.
sqlserverConfig_2016Sp2Ent.
userConfig.
maxDegreeOfParallelism		 integer (int64)

Limits the number of processors to use in parallel plan execution per task.

See in-depth description in SQL Server documentation.

Acceptable values are 1 to 99, inclusive.
config.
sqlserverConfig_2016Sp2Ent.
userConfig.
costThresholdForParallelism		 integer (int64)

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.

Acceptable values are 5 to 32767, inclusive.
config.
sqlserverConfig_2016Sp2Ent.
userConfig.
auditLevel		 integer (int64)

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.

Acceptable values are 0 to 3, inclusive.
config.
sqlserverConfig_2016Sp2Ent.
userConfig.
fillFactorPercent		 integer (int64)

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.

Acceptable values are 0 to 100, inclusive.
config.
sqlserverConfig_2016Sp2Ent.
userConfig.
optimizeForAdHocWorkloads		 boolean (boolean)

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.
config.
sqlserverConfig_2016Sp2Ent.
defaultConfig		 object

Default configuration for an SQL Server 2016 SP2 cluster.

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.
config.
sqlserverConfig_2016Sp2Ent.
defaultConfig.
maxDegreeOfParallelism		 integer (int64)

Limits the number of processors to use in parallel plan execution per task.

See in-depth description in SQL Server documentation.

Acceptable values are 1 to 99, inclusive.
config.
sqlserverConfig_2016Sp2Ent.
defaultConfig.
costThresholdForParallelism		 integer (int64)

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.

Acceptable values are 5 to 32767, inclusive.
config.
sqlserverConfig_2016Sp2Ent.
defaultConfig.
auditLevel		 integer (int64)

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.

Acceptable values are 0 to 3, inclusive.
config.
sqlserverConfig_2016Sp2Ent.
defaultConfig.
fillFactorPercent		 integer (int64)

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.

Acceptable values are 0 to 100, inclusive.
config.
sqlserverConfig_2016Sp2Ent.
defaultConfig.
optimizeForAdHocWorkloads		 boolean (boolean)

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.
config.
sqlserverConfig_2017Std		 object
config includes only one of the fields sqlserverConfig_2016Sp2Std, sqlserverConfig_2016Sp2Ent, sqlserverConfig_2017Std, sqlserverConfig_2017Ent, sqlserverConfig_2019Std, sqlserverConfig_2019Ent
config.
sqlserverConfig_2017Std.
effectiveConfig		 object

Effective settings for an SQL Server 2017 cluster (a combination of settings defined in userConfig and defaultConfig).

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.
config.
sqlserverConfig_2017Std.
effectiveConfig.
maxDegreeOfParallelism		 integer (int64)

Limits the number of processors to use in parallel plan execution per task.

See in-depth description in SQL Server documentation.

Acceptable values are 1 to 99, inclusive.
config.
sqlserverConfig_2017Std.
effectiveConfig.
costThresholdForParallelism		 integer (int64)

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.

Acceptable values are 5 to 32767, inclusive.
config.
sqlserverConfig_2017Std.
effectiveConfig.
auditLevel		 integer (int64)

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.

Acceptable values are 0 to 3, inclusive.
config.
sqlserverConfig_2017Std.
effectiveConfig.
fillFactorPercent		 integer (int64)

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.

Acceptable values are 0 to 100, inclusive.
config.
sqlserverConfig_2017Std.
effectiveConfig.
optimizeForAdHocWorkloads		 boolean (boolean)

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.
config.
sqlserverConfig_2017Std.
userConfig		 object

User-defined settings for an SQL Server 2017 cluster.

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.
config.
sqlserverConfig_2017Std.
userConfig.
maxDegreeOfParallelism		 integer (int64)

Limits the number of processors to use in parallel plan execution per task.

See in-depth description in SQL Server documentation.

Acceptable values are 1 to 99, inclusive.
config.
sqlserverConfig_2017Std.
userConfig.
costThresholdForParallelism		 integer (int64)

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.

Acceptable values are 5 to 32767, inclusive.
config.
sqlserverConfig_2017Std.
userConfig.
auditLevel		 integer (int64)

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.

Acceptable values are 0 to 3, inclusive.
config.
sqlserverConfig_2017Std.
userConfig.
fillFactorPercent		 integer (int64)

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.

Acceptable values are 0 to 100, inclusive.
config.
sqlserverConfig_2017Std.
userConfig.
optimizeForAdHocWorkloads		 boolean (boolean)

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.
config.
sqlserverConfig_2017Std.
defaultConfig		 object

Default configuration for an SQL Server 2017 cluster.

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.
config.
sqlserverConfig_2017Std.
defaultConfig.
maxDegreeOfParallelism		 integer (int64)

Limits the number of processors to use in parallel plan execution per task.

See in-depth description in SQL Server documentation.

Acceptable values are 1 to 99, inclusive.
config.
sqlserverConfig_2017Std.
defaultConfig.
costThresholdForParallelism		 integer (int64)

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.

Acceptable values are 5 to 32767, inclusive.
config.
sqlserverConfig_2017Std.
defaultConfig.
auditLevel		 integer (int64)

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.

Acceptable values are 0 to 3, inclusive.
config.
sqlserverConfig_2017Std.
defaultConfig.
fillFactorPercent		 integer (int64)

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.

Acceptable values are 0 to 100, inclusive.
config.
sqlserverConfig_2017Std.
defaultConfig.
optimizeForAdHocWorkloads		 boolean (boolean)

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.
config.
sqlserverConfig_2017Ent		 object
config includes only one of the fields sqlserverConfig_2016Sp2Std, sqlserverConfig_2016Sp2Ent, sqlserverConfig_2017Std, sqlserverConfig_2017Ent, sqlserverConfig_2019Std, sqlserverConfig_2019Ent
config.
sqlserverConfig_2017Ent.
effectiveConfig		 object

Effective settings for an SQL Server 2017 cluster (a combination of settings defined in userConfig and defaultConfig).

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.
config.
sqlserverConfig_2017Ent.
effectiveConfig.
maxDegreeOfParallelism		 integer (int64)

Limits the number of processors to use in parallel plan execution per task.

See in-depth description in SQL Server documentation.

Acceptable values are 1 to 99, inclusive.
config.
sqlserverConfig_2017Ent.
effectiveConfig.
costThresholdForParallelism		 integer (int64)

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.

Acceptable values are 5 to 32767, inclusive.
config.
sqlserverConfig_2017Ent.
effectiveConfig.
auditLevel		 integer (int64)

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.

Acceptable values are 0 to 3, inclusive.
config.
sqlserverConfig_2017Ent.
effectiveConfig.
fillFactorPercent		 integer (int64)

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.

Acceptable values are 0 to 100, inclusive.
config.
sqlserverConfig_2017Ent.
effectiveConfig.
optimizeForAdHocWorkloads		 boolean (boolean)

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.
config.
sqlserverConfig_2017Ent.
userConfig		 object

User-defined settings for an SQL Server 2017 cluster.

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.
config.
sqlserverConfig_2017Ent.
userConfig.
maxDegreeOfParallelism		 integer (int64)

Limits the number of processors to use in parallel plan execution per task.

See in-depth description in SQL Server documentation.

Acceptable values are 1 to 99, inclusive.
config.
sqlserverConfig_2017Ent.
userConfig.
costThresholdForParallelism		 integer (int64)

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.

Acceptable values are 5 to 32767, inclusive.
config.
sqlserverConfig_2017Ent.
userConfig.
auditLevel		 integer (int64)

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.

Acceptable values are 0 to 3, inclusive.
config.
sqlserverConfig_2017Ent.
userConfig.
fillFactorPercent		 integer (int64)

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.

Acceptable values are 0 to 100, inclusive.
config.
sqlserverConfig_2017Ent.
userConfig.
optimizeForAdHocWorkloads		 boolean (boolean)

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.
config.
sqlserverConfig_2017Ent.
defaultConfig		 object

Default configuration for an SQL Server 2017 cluster.

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.
config.
sqlserverConfig_2017Ent.
defaultConfig.
maxDegreeOfParallelism		 integer (int64)

Limits the number of processors to use in parallel plan execution per task.

See in-depth description in SQL Server documentation.

Acceptable values are 1 to 99, inclusive.
config.
sqlserverConfig_2017Ent.
defaultConfig.
costThresholdForParallelism		 integer (int64)

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.

Acceptable values are 5 to 32767, inclusive.
config.
sqlserverConfig_2017Ent.
defaultConfig.
auditLevel		 integer (int64)

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.

Acceptable values are 0 to 3, inclusive.
config.
sqlserverConfig_2017Ent.
defaultConfig.
fillFactorPercent		 integer (int64)

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.

Acceptable values are 0 to 100, inclusive.
config.
sqlserverConfig_2017Ent.
defaultConfig.
optimizeForAdHocWorkloads		 boolean (boolean)

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.
config.
sqlserverConfig_2019Std		 object
config includes only one of the fields sqlserverConfig_2016Sp2Std, sqlserverConfig_2016Sp2Ent, sqlserverConfig_2017Std, sqlserverConfig_2017Ent, sqlserverConfig_2019Std, sqlserverConfig_2019Ent
config.
sqlserverConfig_2019Std.
effectiveConfig		 object

Effective settings for an SQL Server 2019 cluster (a combination of settings defined in userConfig and defaultConfig).

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.
config.
sqlserverConfig_2019Std.
effectiveConfig.
maxDegreeOfParallelism		 integer (int64)

Limits the number of processors to use in parallel plan execution per task.

See in-depth description in SQL Server documentation.

Acceptable values are 1 to 99, inclusive.
config.
sqlserverConfig_2019Std.
effectiveConfig.
costThresholdForParallelism		 integer (int64)

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.

Acceptable values are 5 to 32767, inclusive.
config.
sqlserverConfig_2019Std.
effectiveConfig.
auditLevel		 integer (int64)

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.

Acceptable values are 0 to 3, inclusive.
config.
sqlserverConfig_2019Std.
effectiveConfig.
fillFactorPercent		 integer (int64)

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.

Acceptable values are 0 to 100, inclusive.
config.
sqlserverConfig_2019Std.
effectiveConfig.
optimizeForAdHocWorkloads		 boolean (boolean)

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.
config.
sqlserverConfig_2019Std.
userConfig		 object

User-defined settings for an SQL Server 2019 cluster.

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.
config.
sqlserverConfig_2019Std.
userConfig.
maxDegreeOfParallelism		 integer (int64)

Limits the number of processors to use in parallel plan execution per task.

See in-depth description in SQL Server documentation.

Acceptable values are 1 to 99, inclusive.
config.
sqlserverConfig_2019Std.
userConfig.
costThresholdForParallelism		 integer (int64)

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.

Acceptable values are 5 to 32767, inclusive.
config.
sqlserverConfig_2019Std.
userConfig.
auditLevel		 integer (int64)

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.

Acceptable values are 0 to 3, inclusive.
config.
sqlserverConfig_2019Std.
userConfig.
fillFactorPercent		 integer (int64)

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.

Acceptable values are 0 to 100, inclusive.
config.
sqlserverConfig_2019Std.
userConfig.
optimizeForAdHocWorkloads		 boolean (boolean)

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.
config.
sqlserverConfig_2019Std.
defaultConfig		 object

Default configuration for an SQL Server 2019 cluster.

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.
config.
sqlserverConfig_2019Std.
defaultConfig.
maxDegreeOfParallelism		 integer (int64)

Limits the number of processors to use in parallel plan execution per task.

See in-depth description in SQL Server documentation.

Acceptable values are 1 to 99, inclusive.
config.
sqlserverConfig_2019Std.
defaultConfig.
costThresholdForParallelism		 integer (int64)

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.

Acceptable values are 5 to 32767, inclusive.
config.
sqlserverConfig_2019Std.
defaultConfig.
auditLevel		 integer (int64)

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.

Acceptable values are 0 to 3, inclusive.
config.
sqlserverConfig_2019Std.
defaultConfig.
fillFactorPercent		 integer (int64)

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.

Acceptable values are 0 to 100, inclusive.
config.
sqlserverConfig_2019Std.
defaultConfig.
optimizeForAdHocWorkloads		 boolean (boolean)

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.
config.
sqlserverConfig_2019Ent		 object
config includes only one of the fields sqlserverConfig_2016Sp2Std, sqlserverConfig_2016Sp2Ent, sqlserverConfig_2017Std, sqlserverConfig_2017Ent, sqlserverConfig_2019Std, sqlserverConfig_2019Ent
config.
sqlserverConfig_2019Ent.
effectiveConfig		 object

Effective settings for an SQL Server 2019 cluster (a combination of settings defined in userConfig and defaultConfig).

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.
config.
sqlserverConfig_2019Ent.
effectiveConfig.
maxDegreeOfParallelism		 integer (int64)

Limits the number of processors to use in parallel plan execution per task.

See in-depth description in SQL Server documentation.

Acceptable values are 1 to 99, inclusive.
config.
sqlserverConfig_2019Ent.
effectiveConfig.
costThresholdForParallelism		 integer (int64)

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.

Acceptable values are 5 to 32767, inclusive.
config.
sqlserverConfig_2019Ent.
effectiveConfig.
auditLevel		 integer (int64)

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.

Acceptable values are 0 to 3, inclusive.
config.
sqlserverConfig_2019Ent.
effectiveConfig.
fillFactorPercent		 integer (int64)

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.

Acceptable values are 0 to 100, inclusive.
config.
sqlserverConfig_2019Ent.
effectiveConfig.
optimizeForAdHocWorkloads		 boolean (boolean)

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.
config.
sqlserverConfig_2019Ent.
userConfig		 object

User-defined settings for an SQL Server 2019 cluster.

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.
config.
sqlserverConfig_2019Ent.
userConfig.
maxDegreeOfParallelism		 integer (int64)

Limits the number of processors to use in parallel plan execution per task.

See in-depth description in SQL Server documentation.

Acceptable values are 1 to 99, inclusive.
config.
sqlserverConfig_2019Ent.
userConfig.
costThresholdForParallelism		 integer (int64)

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.

Acceptable values are 5 to 32767, inclusive.
config.
sqlserverConfig_2019Ent.
userConfig.
auditLevel		 integer (int64)

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.

Acceptable values are 0 to 3, inclusive.
config.
sqlserverConfig_2019Ent.
userConfig.
fillFactorPercent		 integer (int64)

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.

Acceptable values are 0 to 100, inclusive.
config.
sqlserverConfig_2019Ent.
userConfig.
optimizeForAdHocWorkloads		 boolean (boolean)

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.
config.
sqlserverConfig_2019Ent.
defaultConfig		 object

Default configuration for an SQL Server 2019 cluster.

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.
config.
sqlserverConfig_2019Ent.
defaultConfig.
maxDegreeOfParallelism		 integer (int64)

Limits the number of processors to use in parallel plan execution per task.

See in-depth description in SQL Server documentation.

Acceptable values are 1 to 99, inclusive.
config.
sqlserverConfig_2019Ent.
defaultConfig.
costThresholdForParallelism		 integer (int64)

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.

Acceptable values are 5 to 32767, inclusive.
config.
sqlserverConfig_2019Ent.
defaultConfig.
auditLevel		 integer (int64)

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.

Acceptable values are 0 to 3, inclusive.
config.
sqlserverConfig_2019Ent.
defaultConfig.
fillFactorPercent		 integer (int64)

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.

Acceptable values are 0 to 100, inclusive.
config.
sqlserverConfig_2019Ent.
defaultConfig.
optimizeForAdHocWorkloads		 boolean (boolean)

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.
networkId string

ID of the network that the cluster belongs to.
health string

Aggregated cluster health.

  • HEALTH_UNKNOWN: State of the cluster is unknown (health of all hosts in the cluster is UNKNOWN).
  • ALIVE: Cluster is alive and works well (health of all hosts in the cluster is ALIVE).
  • DEAD: Cluster is inoperable (health of all hosts in the cluster is DEAD).
  • DEGRADED: Cluster is in degraded state (health of at least one of the hosts in the cluster is not ALIVE).
status string

Current state of the cluster.

  • STATUS_UNKNOWN: Cluster state is unknown.
  • CREATING: Cluster is being created.
  • RUNNING: Cluster is running normally.
  • ERROR: Cluster encountered a problem and cannot operate.
  • UPDATING: Cluster is being updated.
  • STOPPING: Cluster is stopping.
  • STOPPED: Cluster stopped.
  • STARTING: Cluster is starting.
securityGroupIds[] string

User security groups.
deletionProtection boolean (boolean)

Determines whether the cluster is protected from being deleted.
sqlcollation string

SQL Server Collation.
hostGroupIds[] string

Host groups hosting VMs of the cluster.
serviceAccountId string

ID of the service account which is used for access to Object Storage.

Methods

Method Description
backup Creates a backup for the specified SQL Server cluster.
create Creates an SQL Server cluster in the specified folder.
delete Deletes the specified SQL Server cluster.
get Returns the specified SQL Server cluster.
list Retrieves the list of SQL Server clusters that belong to the specified folder.
listBackups Retrieves the list of available backups for the specified SQL Server cluster.
listHosts Retrieves the list of hosts for the specified SQL Server cluster.
listLogs Retrieves logs for the specified SQL Server cluster.
listOperations Retrieves the list of operations for the specified SQL Server cluster.
move Moves the specified SQL Server cluster to the specified folder.
restore Creates a new SQL Server cluster using the specified backup.
start Starts the specified SQL Server cluster.
startFailover Starts a manual failover for a cluster.
stop Stops the specified SQL Server cluster.
update Modifies the specified SQL Server cluster.
updateHosts Updates the specified hosts.
В этой статье: