Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
In the following row, select the product name you're interested in, and only that product's information is displayed.
* SQL Server *
Drops an existing user-defined resource governor workload group.
Note
To modify resource governor configuration in Azure SQL Managed Instance, you must be in the context of the master
database on the primary replica.
Transact-SQL syntax conventions.
DROP WORKLOAD GROUP group_name
[;]
The name of an existing user-defined workload group.
The DROP WORKLOAD GROUP
statement is not allowed on the resource governor built-in internal
and default
groups.
If a workload group contains active sessions, deleting the workload group fails when the ALTER RESOURCE GOVERNOR RECONFIGURE
statement is executed to apply the change. To avoid this problem, you can take one of the following actions:
ALTER RESOURCE GOVERNOR RECONFIGURE
statement.ALTER RESOURCE GOVERNOR RECONFIGURE
statement. If you decide that you don't want to explicitly stop sessions, re-create the group by using the original name and settings.For more information, see Resource governor and Resource governor workload group.
Requires the CONTROL SERVER
permission.
The following example drops the workload group named adhoc
.
DROP WORKLOAD GROUP adhoc;
ALTER RESOURCE GOVERNOR RECONFIGURE;
* SQL Managed Instance *
Drops an existing user-defined resource governor workload group.
Note
To modify resource governor configuration in Azure SQL Managed Instance, you must be in the context of the master
database on the primary replica.
Transact-SQL syntax conventions.
DROP WORKLOAD GROUP group_name
[;]
The name of an existing user-defined workload group.
The DROP WORKLOAD GROUP
statement is not allowed on the resource governor built-in internal
and default
groups.
If a workload group contains active sessions, deleting the workload group fails when the ALTER RESOURCE GOVERNOR RECONFIGURE
statement is executed to apply the change. To avoid this problem, you can take one of the following actions:
ALTER RESOURCE GOVERNOR RECONFIGURE
statement.ALTER RESOURCE GOVERNOR RECONFIGURE
statement. If you decide that you don't want to explicitly stop sessions, re-create the group by using the original name and settings.For more information, see Resource governor and Resource governor workload group.
Requires the CONTROL SERVER
permission.
The following example drops the workload group named adhoc
.
DROP WORKLOAD GROUP adhoc;
ALTER RESOURCE GOVERNOR RECONFIGURE;
* Azure Synapse
Analytics *
Drops a workload group. Once the statement completes, the settings are in effect.
Transact-SQL syntax conventions
DROP WORKLOAD GROUP group_name
group_name
Is the name of an existing user-defined workload group.
A workload group cannot be dropped if classifiers exist for the workload group. Drop the classifiers before the workload group is dropped. If there are active requests using resources from the workload group being dropped, the drop workload statement is blocked behind them.
Use the following code example to determine which classifiers need to be dropped before the workload group can be dropped.
SELECT c.name as classifier_name
,'DROP WORKLOAD CLASSIFIER '+c.name as drop_command
FROM sys.workload_management_workload_classifiers c
JOIN sys.workload_management_workload_groups g
ON c.group_name = g.name
WHERE g.name = 'wgXYZ' --change the filter to the workload being dropped
Requires CONTROL DATABASE permission
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register today