SQLInstanceSettings interface

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