- Print
- PDF
Config Group
- Print
- PDF
Available in VPC
With Config group, you can create, modify, and delete config groups which lets you efficiently manage MSSQL servers 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 page
The basics of using config group are as follows.
Field | 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 of config groups created and their information |
View config group list
You can view the list of config groups created. The following describes how to view the config group list.
- From the VPC environment of the NAVER Cloud Platform console, click the Services > Database > Cloud DB for MSSQL menus, in that order.
- Click the Config group menu.
- When the config group list appears, view the required information.
- Config group name: the config group's name
- Type: the config group's type
- Description: description of the config group
- Creation date: creation date and time for the config group
- Modification date: date and time the config group was modified
- DB service applied: Click to see the list of MSSQL servers that belong to the config group.
Create config group
The following describes how to create a config group.
- From the VPC environment of the NAVER Cloud Platform console, click the Services > Database > Cloud DB for MSSQL menus, in that order.
- Click the Config group menu.
- Click the [Create config group] button.
- When the Create config group pop-up window appears, enter the required information for the 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.
- A duplicated name can't be used.
- Description: Enter the description of the config group to create up to 100 characters.
- sp_configure and trace flag items: the config variable values to apply to the config group to be created
- Enter within the min/max range specified by referring to Config variable list.
- Name: name of the config group to create
- Click the [Yes] button.
Config variable list
The following is the descriptions for config variables.
Config name (settings variable name) | Description |
---|---|
user connections | The maximum number of concurrent user connections allowed for the MSSQL server |
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 a config group created.
- Modified settings apply to all MSSQL servers that use the config group.
- You cannot make changes to the default config group.
- From the VPC environment of the NAVER Cloud Platform console, click the Services > Database > Cloud DB for MSSQL menus, in that order.
- Click the Config group menu.
- Click and select the config group you want to edit the settings for, and then click the [Change config] button.
- When the Change config pop-up window appears, check or enter the required information for editing.
- ID: the unique variable ID
- Name: name of the variable set
- 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.
- Click the [Yes] button.
Delete config group
The following describes how to delete a config group.
- 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.
- From the VPC environment of the NAVER Cloud Platform console, click the Services > Database > Cloud DB for MSSQL menus, in that order.
- Click the Config group menu.
- Click and select the config group to delete, and then click the [Delete] button.
- When the Delete config group pop-up window appears, click the [Yes] button.