___________ enables the DBA for managing the work load of SQL Server and critical system resource consumption

Options
- SQL manager
- SQL profiler
- Resource Governor
- Resource manager


CORRECT ANSWER : Resource Governor

Discussion Board
SQL Server Resource Governor

The SQL Server Resource Governor is a feature than you can use to manage SQL Server workload and system resource consumption. Resource Governor enables you to specify limits on the amount of CPU, physical IO, and memory that incoming application requests can use. Resource Governor enables you to manage SQL Server workloads and resources by specifying limits on resource consumption by incoming requests.

Prajakta Pandit 03-7-2017 11:24 PM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement