Explanation:The classifier function is run for new connections so that their workloads can be assigned to workload groups. 5. Point out the wrong statement :
A. Two workload groups (internal and default) are created and mapped to their corresponding resource pools when SQL Server is installed
B. A resource group serves as a container for session requests that have similar classification criteria
C. Resource Governor also supports user-defined workload groups
D. Resource Governor does not impose any controls on a dedicated administrator connection (DAC)
Answer:A
Explanation:The classifier function is run for new connections so that their workloads can be assigned to workload groups. 5. Point out the wrong statement :
A. Two workload groups (internal and default) are created and mapped to their corresponding resource pools when SQL Server is installed B. A resource group serves as a container for session requests that have similar classification criteria C. Resource Governor also supports user-defined workload groups D. Resource Governor does not impose any controls on a dedicated administrator connection (DAC)
Explanation:A workload allows for aggregate monitoring of the sessions, and defines policies for the sessions. 6. Which of the following query enables the Resource Governor ?