SQLInstanceSettings interface
Set the server/instance-level settings for SQL Server.
Properties
| collation | SQL Server Collation. |
| is |
SQL Server IFI. |
| is |
SQL Server LPIM. |
| is |
SQL Server Optimize for Adhoc workloads. |
| max |
SQL Server MAXDOP. |
| max |
SQL Server maximum memory. |
| min |
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