| title | azdata bdc sql settings reference |
|---|---|
| titleSuffix | SQL Server big data clusters |
| description | Reference article for azdata bdc sql settings commands. |
| ms.prod | sql |
| ms.technology | big-data-cluster |
Applies to [!INCLUDE azure-data-cli-azdata]
The following article provides reference for the sql settings commands in the azdata tool. For more information about other azdata commands, see azdata reference
| Command | Description |
|---|---|
| azdata bdc sql settings set | Set sql service-scope settings. |
| azdata bdc sql settings show | Show sql service-scope settings and optionally sql settings for specified resources. |
Provides the ability to set a service-scoped or resource-scoped setting. Specify the full name of the setting and the value. Does not apply the setting to the running BDC. Run upgrade to do so.
azdata bdc sql settings set --settings -s
Enable SQL agent in the SQL Server Master instance.
azdata bdc sql settings set --settings mssql.sqlagent.enabled=true --resources master Set the number of CPUs for SQL Server in the Data Pool.
azdata bdc sql settings set --settings mssql.numberOfCpus=10 –resources data-0 Sets the configured value for the provided settings. Multiple settings can be set using a comma separated list.
Sets the given setting(s) for the provided resource(s). Resources can be listed as a comma separated list.
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Output format. Allowed values: json, jsonc, table, tsv. Default: json.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Increase logging verbosity. Use --debug for full debug logs.
Shows the BDC's sql service-scope (optionally resource-scope) settings. By default, this command shows user-configured service-scope settings. Filters are available to show all settings (system-managed & configurable), configurable settings, or pending settings. To see a specific service-scope or resource-scope setting, you can provide the setting name. Use “recursive” to show settings for all resources as part of the service.
azdata bdc sql settings show
[--settings -s]
[--filter-option -f]
[--recursive -rec]
[--include-details -i]
[--description -d]Show the user configured SQL service-scope settings
azdata bdc sql settings showShow the max server memory SQL configuration in the Data Pool.
azdata bdc sql settings show --settings mssql.maxServerMemory --resources data-0 Show the pending settings changes for the SQL service-scope and resource-scope settings.
azdata bdc sql settings show --filter-options=pending --recursive --include-detailsOptions to filter which service-level or resource-scope settings are shown, rather than only user configured settings. Filters are available to show all settings (system-managed & user-configurable), all configurable settings, or pending settings. Options: userConfigured, all, pending, configurable.
Shows information for the specified setting name(s)
Includes additional details for the settings chosen to be shown
Include the description of the setting. Must be used with --include-details
Shows the setting(s) information for the given resource(s). Resources can be listed as a comma separated list.
Shows the setting information for the given scope (service or service-resource) as well as all lower-scoped components (resources).
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Output format. Allowed values: json, jsonc, table, tsv. Default: json.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Increase logging verbosity. Use --debug for full debug logs.
For more information about other azdata commands, see azdata reference.
For more information about how to install the azdata tool, see Install azdata to manage SQL Server 2019 big data clusters.