DROP WORKLOAD CLASSIFIER (Transact-SQL)DROP WORKLOAD CLASSIFIER (Transact-SQL)

适用于:Applies to: 是Azure Synapse AnalyticsAzure Synapse AnalyticsyesAzure Synapse AnalyticsAzure Synapse Analytics适用于:Applies to: 是Azure Synapse AnalyticsAzure Synapse AnalyticsyesAzure Synapse AnalyticsAzure Synapse Analytics

删除现有的用户定义的工作负载管理分类器。Drops an existing user-defined workload management classifier. 如果请求正在运行或位于处于挂起状态的请求队列中,它们的分类保持不变,并且我们可以立即删除分类器。If requests are running or in the request queue in suspended state, they will keep their classification and the classifier can be dropped immediately. 删除和重新创建具有不同重要性的分类器不会影响已分类的请求。Dropping and recreating the classifier with different importance will not affect an already classified request.

主题链接图标 Transact-SQL 语法约定Topic link icon Transact-SQL Syntax Conventions.

语法Syntax

DROP WORKLOAD CLASSIFIER classifier_name;

备注

Azure Synapse Analytics 中的无服务器 SQL 池不支持此语法。This syntax is not supported by serverless SQL pool in Azure Synapse Analytics.

参数Arguments

classifier_nameclassifier_name
指定用于标识工作负荷分类器的名称。Specifies the name by which the workload classifier is identified.

权限Permissions

需要 CONTROL DATABASE 权限。Requires CONTROL DATABASE permission.

示例Examples

以下示例删除名为 wgcELTROLE 的工作负荷分类器。The following example drops the workload classifier named wgcELTROLE.

DROP WORKLOAD CLASSIFIER wgcELTRole;

备注

在没有匹配分类器的情况下提交的请求将被分类到默认工作负荷组。A request submitted without a matching classifier, is classified to the default workload group. 默认工作负荷组是 smallrc 资源类。The default workload group is the smallrc resource class.

另请参阅See Also

CREATE WORKLOAD CLASSIFIER (Transact-SQL)CREATE WORKLOAD CLASSIFIER (Transact-SQL)
Azure Synapse AnalyticsAzure Synapse Analytics 工作负载分类Azure Synapse AnalyticsAzure Synapse Analytics Workload Classification