pulumi-azure-kotlin/com.pulumi.azure.mssql.kotlin.outputs/VirtualMachineSqlInstance

VirtualMachineSqlInstance

data class VirtualMachineSqlInstance(val adhocWorkloadsOptimizationEnabled: Boolean? = null, val collation: String? = null, val instantFileInitializationEnabled: Boolean? = null, val lockPagesInMemoryEnabled: Boolean? = null, val maxDop: Int? = null, val maxServerMemoryMb: Int? = null, val minServerMemoryMb: Int? = null)

Constructors

constructor(adhocWorkloadsOptimizationEnabled: Boolean? = null, collation: String? = null, instantFileInitializationEnabled: Boolean? = null, lockPagesInMemoryEnabled: Boolean? = null, maxDop: Int? = null, maxServerMemoryMb: Int? = null, minServerMemoryMb: Int? = null)

Types

Companion

object Companion

Properties

adhocWorkloadsOptimizationEnabled

val adhocWorkloadsOptimizationEnabled: Boolean? = null

Specifies if the SQL Server is optimized for adhoc workloads. Possible values are true and false. Defaults to false.

collation

val collation: String? = null

Collation of the SQL Server. Defaults to SQL_Latin1_General_CP1_CI_AS. Changing this forces a new resource to be created.

instantFileInitializationEnabled

val instantFileInitializationEnabled: Boolean? = null

Specifies if Instant File Initialization is enabled for the SQL Server. Possible values are true and false. Defaults to false. Changing this forces a new resource to be created.

lockPagesInMemoryEnabled

val lockPagesInMemoryEnabled: Boolean? = null

Specifies if Lock Pages in Memory is enabled for the SQL Server. Possible values are true and false. Defaults to false. Changing this forces a new resource to be created.

maxDop

val maxDop: Int? = null

Maximum Degree of Parallelism of the SQL Server. Possible values are between 0 and 32767. Defaults to 0.

maxServerMemoryMb

val maxServerMemoryMb: Int? = null

Maximum amount memory that SQL Server Memory Manager can allocate to the SQL Server process. Possible values are between 128 and 2147483647 Defaults to 2147483647.

minServerMemoryMb

val minServerMemoryMb: Int? = null

Minimum amount memory that SQL Server Memory Manager can allocate to the SQL Server process. Possible values are between 0 and 2147483647 Defaults to 0.