Skip to content

Commit b0804f8

Browse files
author
Ron Ortloff
committed
mi-classifier-wlm-01242022 1030
1 parent 74e57d9 commit b0804f8

1 file changed

Lines changed: 1 addition & 1 deletion

File tree

docs/t-sql/statements/create-workload-classifier-transact-sql.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -29,7 +29,7 @@ monikerRange: "=azure-sqldw-latest"
2929
Creates a classifier object for use in workload management. The classifier assigns incoming requests to a workload group based on the parameters specified in the classifier statement definition. Classifiers are evaluated with every request submitted. If a request is not matched to a classifier, it is assigned to the default workload group. The default workload group is the smallrc resource class.
3030

3131
> [!NOTE]
32-
> Classifying managed identities (MI) behavior differs between the dedicated SQL pool in Azure Synapse workspaces and the standalone dedicated SQL pool (formerly SQL DW). While the standalone dedicated SQL pool MI maintains the assigned identity, Azure Synapse workspaces adds MI to the dbo role. This cannot be changed. The dbo role, by default, is classified to smallrc. Creating a classifier for the dbo role will allows for assigning a workload group other than smallrc. If dbo is too generic of a role, consider using label, session or time-based classification in conjunction with the dbo role classification.
32+
> Classifying managed identities (MI) behavior differs between the dedicated SQL pool in Azure Synapse workspaces and the standalone dedicated SQL pool (formerly SQL DW). While the standalone dedicated SQL pool MI maintains the assigned identity, Azure Synapse workspaces adds MI to the **dbo** role. This cannot be changed. The dbo role, by default, is classified to smallrc. Creating a classifier for the dbo role allows for assigning requests to a workload group other than smallrc. If dbo alone is too generic for classification and has broader impacts, consider using label, session or time-based classification in conjunction with the dbo role classification.
3333
3434
![Topic link icon](../../database-engine/configure-windows/media/topic-link.gif "Topic link icon") [Transact-SQL Syntax Conventions](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md).
3535

0 commit comments

Comments
 (0)