Config Group

Prev Next

Available in VPC

With Config group, you can create, modify, and delete Config Groups which lets you efficiently manage MSSQL Server created by grouping them and specifying the same settings for the servers in the group. Config Groups created can be applied to multiple MSSQL Services, and a Config Group with MSSQL installation default values is provided by default.

Config Group screen

The basics of using Config Group are as follows:

clouddbformssql-configgroup_main_vpc_ko

Area Description
① Menu name Name of the menu currently being viewed
② Basic features Check details for Cloud DB for MSSQL, refresh the Config Group page
③ Config Group features Create, modify, and delete Config Groups
④ Config Group list View the list and information of the created Config Groups

View Config Group list

You can view the list of Config Groups you have created. The following describes how to view the Config Group list:

  1. In VPC of the NAVER Cloud Platform console, click Services > Database > Cloud DB for MSSQL, in order.
  2. Click the Config Group menu.
  3. When the Config Group list appears, check the required information.
    • Config Group name: name of Config Group
    • Type: the Config Group's type
    • Description: description of Config Group
    • Creation date: date and time when the Config Group was created
    • Edited date: date and time the Config Group was modified
    • DB service applied: clouddbformssql_ico-02_vpc_ko see the list of MSSQL Server that belong to the Config Group
      clouddbformssql-configgroup_list_vpc_ko

Create Config Group

The following describes how to create a Config Group:

  1. In VPC of the NAVER Cloud Platform console, click Services > Database > Cloud DB for MSSQL, in order.
  2. Click the Config Group menu.
  3. Click [Create Config Group].
  4. When the create Config Group popup window appears, enter the required information for the creation.
    clouddbformssql-configgroup_create_vpc_ko
    • Name: name of Config Group to create
      • The name must be 3-25 characters long and can only include lower case English letters, numbers, and the hyphen (-)
      • It must start with an English letter and end with an English letter or a number
      • A duplicated name can't be used
    • Description: enter a description of Config Group to create with 100 characters or less
    • sp_configure and trace flag items: the config variable values to apply to the Config Group to be created
  5. Click [Yes].

Config variable list

The following are descriptions of Config variables:

Config Name (name of the config variable) Description
remote access Whether SP execution is controlled on the local/remote server where the MSSQL server is running
max worker threads The number of worker threads that can be used for the MSSQL process
network packet size The size of packets used in the overall network (byte)
show advanced options View options
remote query timeout The time limited in which remote work can be carried out (second) It is allowed indefinitely if this value is 0
cost threshold for parallelism Cost threshold value for creating parallel plans used in the optimizer
max degree of parallelism The number of processors to be used for running a parallel plan
optimize for ad hoc workloads The option that increases cache efficiency for jobs that process multiple ad hoc queries
access check cache bucket count It controls the number of hash buckets used in access check result cache
backup checksum default Whether backup checksum at the default value is used during backup and recovery
automatic soft-NUMA disabled Whether automatic Soft NUMA is not used
Ad Hoc Distributed Queries Whether ad hoc queries are allowed
  • Refer to SQL Docs for details about trace flag.

Change Config Group

The following describes how to change settings of Config Group created:

Caution
  • Modified settings apply to all MSSQL Server that use the Config Group.
  • You cannot make changes to the default Config Group.
  1. In VPC of the NAVER Cloud Platform console, click Services > Database > Cloud DB for MSSQL, in order.
  2. Click the Config Group menu.
  3. Click and select the Config Group you want to edit the settings for, and then click the [Change Config] button.
  4. When the Change Config popup window appears, check or enter the required information for editing.
    clouddbformssql-configgroup_change_vpc_ko
    • ID: the unique variable ID
    • NAME: name of the config variable
    • VALUE: variable value
    • MIN: the minimum value that can be entered in the variable
    • MAX: the maximal value that can be entered in the variable
    • IS_DYNAMIC: whether instant configuration is available. If not, it'll be applied after restart
    • DESC: it separates items that can be set with sp_configure and items dbcc traceon/traceoff among database options
  5. Click [Yes].

Delete Config Group

The following describes how to delete Config Group:

Caution
  • You can't delete a Config Group if a configured MSSQL service exists in the Config Group. Change the Config Group of the MSSQL service with the Config Group to be deleted, and try again.
  • You cannot delete the default Config Group.
  1. In VPC of the NAVER Cloud Platform console, click Services > Database > Cloud DB for MSSQL, in order.
  2. Click the Config Group menu.
  3. Click to select the Config Group you want to delete and then click [Delete].
  4. When the Delete Config Group popup window appears, click the [Yes] button.