Config Group

Available in VPC

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:

View Config Group list

You can view the list of config groups you have created. To view the Config Group list:

1. In the VPC environment of the NAVER Cloud Platform console, navigate to Menu > Services > Database > Cloud DB for MSSQL.
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: Type of config group
   • Description: Description of config group
   • Creation date: Date and time when the config group was created
   • Edited date: Date and time when the config group was modified
   • DB Service applied: Click to view the list of MSSQL Servers belonging to the config group
     

Create a config group

To create a config group:

1. In the VPC environment of the NAVER Cloud Platform console, navigate to Menu > Services > Database > Cloud DB for MSSQL.
2. Click the Config Group menu.
3. Click [Create Config Group].
4. When the Create Config Group popup appears, enter the required information for creation.
   
   • Name: Name of the config group to create
     • Enter between 3 and 25 characters using lowercase English letters, numbers, and hyphens (-).
     • It must start with an English letter and end with an English letter or a number.
     • Duplicate names are not allowed.
   • Description: Enter a description of the config group to create that is 100 characters or less
   • sp_configure and trace flag items: Configuration variable values to apply to the config group
     • Enter within the min/max range specified by referring to full variable list and description
5. Click [Yes].

Config variable list

The following are descriptions of config variables:

• For descriptions of trace flags, see SQL Docs.

Modify a config group

To modify a created config group:

1. In the VPC environment of the NAVER Cloud Platform console, navigate to Menu > Services > Database > Cloud DB for MSSQL.
2. Click the Config Group menu.
3. Click and select the config group you want to edit the settings for, and then click [Change Config].
4. When the Change Config popup appears, check or enter the required information for editing.
   
   • ID: Unique identifier of the variable.
   • NAME: Name of config variable to set.
     • Full variable list and descriptions
   • VALUE: Variable value.
   • MIN: Minimum allowable value.
   • MAX: 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.
5. Click [Yes].

Delete a config group

To delete a config group:

1. In the VPC environment of the NAVER Cloud Platform console, navigate to Menu > Services > Database > Cloud DB for MSSQL.
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 a config group popup appears, click [Yes].