Class SqlInstanceSettings


  • public final class SqlInstanceSettings
    extends Object
    Set the server/instance-level settings for SQL Server.
    • Constructor Detail

      • SqlInstanceSettings

        public SqlInstanceSettings()
    • Method Detail

      • collation

        public String collation()
        Get the collation property: SQL Server Collation.
        Returns:
        the collation value.
      • withCollation

        public SqlInstanceSettings withCollation​(String collation)
        Set the collation property: SQL Server Collation.
        Parameters:
        collation - the collation value to set.
        Returns:
        the SqlInstanceSettings object itself.
      • maxDop

        public Integer maxDop()
        Get the maxDop property: SQL Server MAXDOP.
        Returns:
        the maxDop value.
      • withMaxDop

        public SqlInstanceSettings withMaxDop​(Integer maxDop)
        Set the maxDop property: SQL Server MAXDOP.
        Parameters:
        maxDop - the maxDop value to set.
        Returns:
        the SqlInstanceSettings object itself.
      • isOptimizeForAdHocWorkloadsEnabled

        public Boolean isOptimizeForAdHocWorkloadsEnabled()
        Get the isOptimizeForAdHocWorkloadsEnabled property: SQL Server Optimize for Adhoc workloads.
        Returns:
        the isOptimizeForAdHocWorkloadsEnabled value.
      • withIsOptimizeForAdHocWorkloadsEnabled

        public SqlInstanceSettings withIsOptimizeForAdHocWorkloadsEnabled​(Boolean isOptimizeForAdHocWorkloadsEnabled)
        Set the isOptimizeForAdHocWorkloadsEnabled property: SQL Server Optimize for Adhoc workloads.
        Parameters:
        isOptimizeForAdHocWorkloadsEnabled - the isOptimizeForAdHocWorkloadsEnabled value to set.
        Returns:
        the SqlInstanceSettings object itself.
      • minServerMemoryMB

        public Integer minServerMemoryMB()
        Get the minServerMemoryMB property: SQL Server minimum memory.
        Returns:
        the minServerMemoryMB value.
      • withMinServerMemoryMB

        public SqlInstanceSettings withMinServerMemoryMB​(Integer minServerMemoryMB)
        Set the minServerMemoryMB property: SQL Server minimum memory.
        Parameters:
        minServerMemoryMB - the minServerMemoryMB value to set.
        Returns:
        the SqlInstanceSettings object itself.
      • maxServerMemoryMB

        public Integer maxServerMemoryMB()
        Get the maxServerMemoryMB property: SQL Server maximum memory.
        Returns:
        the maxServerMemoryMB value.
      • withMaxServerMemoryMB

        public SqlInstanceSettings withMaxServerMemoryMB​(Integer maxServerMemoryMB)
        Set the maxServerMemoryMB property: SQL Server maximum memory.
        Parameters:
        maxServerMemoryMB - the maxServerMemoryMB value to set.
        Returns:
        the SqlInstanceSettings object itself.
      • validate

        public void validate()
        Validates the instance.
        Throws:
        IllegalArgumentException - thrown if the instance is not valid.