Which four actions should you perform in sequence?

DRAG DROP

You have a consolidated SQL Server instance that contains databases for several applications.

You need to limit the maximum degree of parallelism for an application named App1.

Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

View Answer

Answer:

Explanation:

Step 1: Enable Resource Governor

The Resource Governor is turned off by default. You can enable the Resource Governor by using either SQL Server Management Studio or Transact-SQL.

Step 2: Create a resource pool.

In the SQL Server Resource Governor, a resource pool represents a subset of the physical resources of an instance of the Database Engine.

Step 3: Create a workload group

In the SQL Server Resource Governor, a workload group serves as a container for session requests that have similar classification criteria. A workload allows for aggregate monitoring of the sessions, and defines policies for the sessions. Each workload group is in a resource pool, which represents a subset of the physical resources of an instance of the Database Engine. When a session is started, the Resource Governor classifier assigns the session to a specific workload group, and the session must run using the policies assigned to the workload group and the resources defined for the resource pool.

Step 4: Write a classifier function.

The SQL Server resource governor classification process assigns incoming sessions to a workload group based on the characteristics of the session. You can tailor the classification logic by writing a user-defined function, called a classifier function.