Skip to content

mssqlHostConfiguration

Get the configuration for a specific host Supported in v6.0+ Returns the configuration for the specified SQL Server host.

Arguments

Argument Type Description
input (required) MssqlHostConfigInput! Input for retrieving MSSQL host-level configuration flags.

Returns

MssqlHostConfiguration!

Sample

query MssqlHostConfiguration($input: MssqlHostConfigInput!) {
  mssqlHostConfiguration(input: $input) {
    af2MinimumFileCount
    cbtMaxMemoryUsageInMb
    cmdPipeBufferSizeInKb
    copyLogsToHostDuringLiveMount
    disableStrictSyncForMssqlLiveMount
    enableDatabaseBatchSnapshots
    enableGroupFetch
    enableMssqlMultiNodeBackup
    enableMssqlMultiNodeRestore
    enableVdi
    enableVdiDb
    fileRestoreReadParallelism
    fileRestoreWriteParallelism
    fileTransferParallelism
    maxDbLoadSizeInBytes
    maxNodesForMultiNodeBackup
    maxNodesForMultiNodeRestore
    mssqlAllowDirtyReadForAgQuery
    mssqlAllowDirtyReadForDbSizeQuery
    mssqlDatabaseQueryTimeout
    mssqlDefaultMaxDataStreamsPerDatabase
    mssqlEnableCleanupOnRestoreFailure
    mssqlUseDmFileSpaceUsage
    multiNodeRestoreMaxDataStreamsPerNode
    physicalHostDatabaseRestoreThrottleMaxRefCount
    physicalHostLogBackupThrottleMaxRefCount
    throttlePhysicalHostMaxRefCount
    useAf2ForHighDataFileCount
    useDefaultBackupLocation
    vdiRestoreMaxTimeoutInMinutes
    vdiRestoreTimeoutInSecondsPerGb
  }
}

{
  "input": {
    "hostId": "example-string"
  }
}

{
  "data": {
    "mssqlHostConfiguration": {
      "af2MinimumFileCount": 0,
      "cbtMaxMemoryUsageInMb": 0,
      "cmdPipeBufferSizeInKb": 0,
      "copyLogsToHostDuringLiveMount": "HOST_CONFIGURATION_PROPERTY_ENABLED_DEFAULT",
      "disableStrictSyncForMssqlLiveMount": "HOST_CONFIGURATION_PROPERTY_ENABLED_DEFAULT",
      "enableDatabaseBatchSnapshots": "HOST_CONFIGURATION_PROPERTY_ENABLED_DEFAULT"
    }
  }
}