Workload classification

Question

Workload classification

Maitra-v, Anirban 141

Say we have 2 AD groups.
ADG1
ADG2

In the workload management, under the classification , let say we have 2 classifier.
CREATE WORKLOAD CLASSIFIER class1 WITH
( WORKLOAD_GROUP = 'wg1'
,MEMBERNAME = 'ADG1'
,IMPORTANCE = ABOVE_NORMAL
);

CREATE WORKLOAD CLASSIFIER class2 WITH
( WORKLOAD_GROUP = 'wg2'
,MEMBERNAME = 'ADG2'
,IMPORTANCE = NORMAL
);

Some users are part of both AD groups. In that case how the classification will work.
What kind of Importance/Isolation the common users will get.

PRADEEPCHEEKATLA 90,651 Reputation points Moderator

2022-03-11T09:18:33.353+00:00
Hello @Maitra-v, Anirban ,

Following up to see if the below suggestion was helpful. And, if you have any further query do let us know.

------------------------------

Please don't forget to click on or upvote button whenever the information provided helps you.

1 answer

Your answer

PRADEEPCHEEKATLA 90,651 Reputation points Moderator

2022-03-11T09:18:33.353+00:00

Hello @Maitra-v, Anirban ,

Following up to see if the below suggestion was helpful. And, if you have any further query do let us know.

------------------------------

Please don't forget to click on or upvote button whenever the information provided helps you.

Answer 1

Hello @Maitra-v, Anirban ,

Thanks for the question and using MS Q&A platform.

If you have multiple of these classifiers exist for the same user a weighting exercise is performed. The following table represents how the weighting happens.

Dedicated SQL pool workload management in Azure Synapse consists of three high-level concepts: Workload Classification, Workload Importance, and Workload Isolation. These capabilities give you more control over how your workload utilizes system resources.

Workload classification is the concept of assigning a request to a workload group and setting importance levels. Historically, this assignment was done via role membership using sp_addrolemember. This action can now be done via the CREATE WORKLOAD CLASSIFER. The classification capability provides a richer set of options such as label, session, and time to classify requests.

Workload importance influences the order in which a request gets access to resources. On a busy system, a request with higher importance has first access to resources. Importance can also ensure ordered access to locks.

Workload isolation reserves resources for a workload group. Resources reserved in a workload group are held exclusively for that workload group to ensure execution. Workload groups also allow you to define the amount of resources that are assigned per request, much like resource classes do. Workload groups give you the ability to reserve or cap the amount of resources a set of requests can consume. Finally, workload groups are a mechanism to apply rules, such as query timeout, to requests.

For more information, refer to What is workload management? And also check out the detailed video on Workload Management Concepts.

This article explains a bit more on Workload Management in Dedicated SQL Pools with examples of multiple users and groups.

Hope this will help. Please let us know if any further queries.

------------------------------

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
Want a reminder to come back and check responses? Here is how to subscribe to a notification
If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

Maitra-v, Anirban 141 Reputation points

2022-03-07T14:09:20.513+00:00

Thank You so much for the response.

For my case it is the same...Only importance level is different for both the classifier. Does it take "class1" for all the common users..

CREATE WORKLOAD CLASSIFIER class1 WITH
( WORKLOAD_GROUP = 'wg1'
,MEMBERNAME = 'ADG1'
,IMPORTANCE = ABOVE_NORMAL
);

CREATE WORKLOAD CLASSIFIER class2 WITH
( WORKLOAD_GROUP = 'wg2'
,MEMBERNAME = 'ADG2'
,IMPORTANCE = NORMAL
);
PRADEEPCHEEKATLA 90,651 Reputation points Moderator

2022-03-08T05:13:05.27+00:00

Hello @Maitra-v, Anirban ,

Yes, it would take class1 with Importance ABOVE_NORMAL for the common users.
PRADEEPCHEEKATLA 90,651 Reputation points Moderator

2022-03-09T10:01:22.083+00:00

Hello @Maitra-v, Anirban ,

Just checking in to see if the above answer helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

Share via

Workload classification

1 answer

Your answer