Class WorkloadGroupProperties


  • public final class WorkloadGroupProperties
    extends Object
    Workload group definition. For more information look at sys.workload_management_workload_groups (DMV).
    • Constructor Detail

      • WorkloadGroupProperties

        public WorkloadGroupProperties()
    • Method Detail

      • minResourcePercent

        public int minResourcePercent()
        Get the minResourcePercent property: The workload group minimum percentage resource.
        Returns:
        the minResourcePercent value.
      • withMinResourcePercent

        public WorkloadGroupProperties withMinResourcePercent​(int minResourcePercent)
        Set the minResourcePercent property: The workload group minimum percentage resource.
        Parameters:
        minResourcePercent - the minResourcePercent value to set.
        Returns:
        the WorkloadGroupProperties object itself.
      • maxResourcePercent

        public int maxResourcePercent()
        Get the maxResourcePercent property: The workload group cap percentage resource.
        Returns:
        the maxResourcePercent value.
      • withMaxResourcePercent

        public WorkloadGroupProperties withMaxResourcePercent​(int maxResourcePercent)
        Set the maxResourcePercent property: The workload group cap percentage resource.
        Parameters:
        maxResourcePercent - the maxResourcePercent value to set.
        Returns:
        the WorkloadGroupProperties object itself.
      • minResourcePercentPerRequest

        public double minResourcePercentPerRequest()
        Get the minResourcePercentPerRequest property: The workload group request minimum grant percentage.
        Returns:
        the minResourcePercentPerRequest value.
      • withMinResourcePercentPerRequest

        public WorkloadGroupProperties withMinResourcePercentPerRequest​(double minResourcePercentPerRequest)
        Set the minResourcePercentPerRequest property: The workload group request minimum grant percentage.
        Parameters:
        minResourcePercentPerRequest - the minResourcePercentPerRequest value to set.
        Returns:
        the WorkloadGroupProperties object itself.
      • maxResourcePercentPerRequest

        public Double maxResourcePercentPerRequest()
        Get the maxResourcePercentPerRequest property: The workload group request maximum grant percentage.
        Returns:
        the maxResourcePercentPerRequest value.
      • withMaxResourcePercentPerRequest

        public WorkloadGroupProperties withMaxResourcePercentPerRequest​(Double maxResourcePercentPerRequest)
        Set the maxResourcePercentPerRequest property: The workload group request maximum grant percentage.
        Parameters:
        maxResourcePercentPerRequest - the maxResourcePercentPerRequest value to set.
        Returns:
        the WorkloadGroupProperties object itself.
      • importance

        public String importance()
        Get the importance property: The workload group importance level.
        Returns:
        the importance value.
      • withImportance

        public WorkloadGroupProperties withImportance​(String importance)
        Set the importance property: The workload group importance level.
        Parameters:
        importance - the importance value to set.
        Returns:
        the WorkloadGroupProperties object itself.
      • queryExecutionTimeout

        public Integer queryExecutionTimeout()
        Get the queryExecutionTimeout property: The workload group query execution timeout.
        Returns:
        the queryExecutionTimeout value.
      • withQueryExecutionTimeout

        public WorkloadGroupProperties withQueryExecutionTimeout​(Integer queryExecutionTimeout)
        Set the queryExecutionTimeout property: The workload group query execution timeout.
        Parameters:
        queryExecutionTimeout - the queryExecutionTimeout value to set.
        Returns:
        the WorkloadGroupProperties object itself.
      • validate

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