Config Group

Prev Next

Available in Classic

In Config Group, you can create, modify, and delete config groups that let you group created MSSQL servers and apply the same configuration values to all servers in the group for efficient management. A created config group can be applied to multiple MSSQL services, and a default config group that includes the MSSQL installation default values is provided.

Config Group interface

The following describes the basic components for using Config Group:

clouddbformssql-configgroup_main_ko

Component Description
① Menu name Show the current menu name.
② Basic features View Cloud DB for MSSQL details and refresh the Config Group interface.
③ Config Group features Create, modify, and delete config groups.
④ Config settings Configure the config group.

Create a config group

To create a config group:

  1. In the Classic environment of the NAVER Cloud Platform console, navigate to i_menu > Services > Database > Cloud DB for MSSQL.
  2. Click the Config Group menu.
  3. Click the Create tab, then enter the required information.
    clouddbformssql-configgroup_create_ko
    • Name: Name of the config group to create
      • Enter 3–25 characters using lowercase letters, numbers, and hyphens (-).
      • The first character must be a letter, and the last character must be a letter or number.
      • Duplicate names are not allowed
    • sp_configure and trace flag items: Configuration variable values to apply to the config group
  4. Click [Yes].

Config variable list

The following describes the config variables:

Config name Description
user connections Maximum number of concurrent user connections allowed on the MSSQL server
remote access Whether to control stored procedure execution on local or remote servers where the MSSQL server is running
max worker threads Number of worker threads available for the MSSQL process
network packet size Packet size used across the network (bytes)
show advanced options Show advanced options.
remote query timeout Time limit for performing remote operations (seconds) A value of 0 allows unlimited time
cost threshold for parallelism Cost threshold used by the optimizer to generate parallel plans
max degree of parallelism Number of processors to use for parallel plan execution
optimize for ad hoc workloads Option that improves cache efficiency when processing multiple ad hoc queries
access check cache bucket count Controls the number of hash buckets used for the access check result cache
backup checksum default Whether to use the default backup checksum during backup and restore
automatic soft-NUMA disabled Whether automatic soft NUMA is disabled
Ad Hoc Distributed Queries Whether ad hoc queries are allowed
  • For descriptions of trace flags, see SQL Docs.

Modify a config group

To modify a created config group:

  1. In the Classic environment of the NAVER Cloud Platform console, navigate to i_menu > Services > Database > Cloud DB for MSSQL.
  2. Click the Config Group menu.
  3. Click the Modify tab.
  4. Select the config group name to modify, then click [Load].
  5. Review or enter the required information for editing.
    clouddbformssql-configgroup_change_ko
    • ID: Unique identifier of the variable
    • NAME: Configuration variable name
    • VALUE: Variable value
    • MIN: Minimum allowable value
    • Maximum allowable value
    • IS_DYNAMIC: Whether the setting can be applied immediately. If not, it is applied after a restart
    • DESC: Distinguish options configurable items via sp_configure from those configurable items via dbcc traceon or traceoff.
  6. Click [Modify].

Delete a config group

To delete a config group:

Caution
  • You cannot delete a config group that is applied to an MSSQL service. Change the config group of the MSSQL service to which the config group to be deleted is applied, and then try again.
  • You cannot delete the config group.
  1. In the Classic environment of the NAVER Cloud Platform console, navigate to i_menu > Services > Database > Cloud DB for MSSQL.
  2. Click the Config Group menu.
  3. Click the Delete tab.
  4. Select the name of the config group to delete, then click [Delete].
  5. When the Delete a config group popup appears, click [Yes].