Config Group
- Print
- PDF
Config Group
- Print
- PDF
Article Summary
Share feedback
Thanks for sharing your feedback!
Available in Classic
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 settings | Set configs for a config group. |
Create config group
The following describes how to create a config group.
- From the Classic 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 tab, and then 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.
- A duplicated name can't be used.
- 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.
- From the Classic 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 Change tab.
- Select the config group name you want to change config settings, and then click the [Load] button.
- Check or enter any necessary 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
- 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 [Change] button.
Delete config group
The following describes how to delete a 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.
- From the Classic 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 [Change] tab.
- Select the config group name you want to delete, and then click the [Delete] button.
- When the Delete config group pop-up window appears, click the [Yes] button.
Was this article helpful?