Explanation:SQL Server Resource Governor is a feature than you can use to manage SQL Server workload and system resource consumption. 2. Point out the correct statement :
A. You can set IO thresholds on the internal resource pool
B. There is workload monitoring or workload management between SQL Server instances
C. A resource group, represents the physical resources of the server
D. Resource management is limited to the SQL Server Database Engine
Answer:A
Explanation:SQL Server Resource Governor is a feature than you can use to manage SQL Server workload and system resource consumption. 2. Point out the correct statement :
A. You can set IO thresholds on the internal resource pool B. There is workload monitoring or workload management between SQL Server instances C. A resource group, represents the physical resources of the server D. Resource management is limited to the SQL Server Database Engine
Explanation:Resource Governor can not be used for Analysis Services, Integration Services, and Reporting Services. 3. You cannot use the ____________ statement to enable Resource Governor when in a user transaction.