SQLInstanceSettings interface

Package:

@azure/arm-sqlvirtualmachine

Set the server/instance-level settings for SQL Server.

Properties

collation	SQL Server Collation.
isIfiEnabled	SQL Server IFI.
isLpimEnabled	SQL Server LPIM.
isOptimizeForAdHocWorkloadsEnabled	SQL Server Optimize for Adhoc workloads.
maxDop	SQL Server MAXDOP.
maxServerMemoryMB	SQL Server maximum memory.
minServerMemoryMB	SQL Server minimum memory.

Property Details

collation

SQL Server Collation.

collation?: string

Property Value

string

isIfiEnabled

SQL Server IFI.

isIfiEnabled?: boolean

Property Value

boolean

isLpimEnabled

SQL Server LPIM.

isLpimEnabled?: boolean

Property Value

boolean

isOptimizeForAdHocWorkloadsEnabled

SQL Server Optimize for Adhoc workloads.

isOptimizeForAdHocWorkloadsEnabled?: boolean

Property Value

boolean

maxDop

SQL Server MAXDOP.

maxDop?: number

Property Value

number

maxServerMemoryMB

SQL Server maximum memory.

maxServerMemoryMB?: number

Property Value

number

minServerMemoryMB

SQL Server minimum memory.

minServerMemoryMB?: number

Property Value

number