I created a custom Workload Group called "ConcurrentWorkloadGroup". I then attempt to create a policy request classification with the following KQL command:
.alter cluster policy request_classification '{"IsEnabled":true}' <|
iff(
request_properties.request_type == "Query"
and request_properties.current_database == "<db_name>"
and request_properties.request_description == "concurrent",
"ConcurrentWorkloadGroup",
"default"
)
I attempt to query using the new Workload Group:
set request_description = "concurrent";
<db_name>
| take 10
When I run .show queries
to check the Workload Group, it shows the query uses the default group. When I remove the request_description
line, the query uses the new Workload Group.
Ultimately, I want to be able to choose which Workload Group is being used from a subset of my queries, so I welcome other ways to achieve this so long is it doesn't affect the group of other queries.