Which four Transact-SQL statements should you use?

DRAG DROP
You administer a Microsoft SQL Server 2008 database for an order-processing application.
The following Transact-SQL statements have been run against the database: You need to
ensure that members of the reporting group can use only up to 35 percent of the CPU and
up to 45 percent of the available RAM.

Which four Transact-SQL statements should you use? (To answer, move the appropriate
SQL statements from the list of statements to the answer area and arrange them in the
correct order.)

DRAG DROP
You administer a Microsoft SQL Server 2008 database for an order-processing application.
The following Transact-SQL statements have been run against the database: You need to
ensure that members of the reporting group can use only up to 35 percent of the CPU and
up to 45 percent of the available RAM.

Which four Transact-SQL statements should you use? (To answer, move the appropriate
SQL statements from the list of statements to the answer area and arrange them in the
correct order.)

Answer:

Explanation:
Note:

CREATE RESOURCE POOL Creates a Resource Governor resource pool. CREATE
RESOURCE POOL pool_name [ WITH ( [ MIN_CPU_PERCENT = value ] [ [ , ]
MAX_CPU_PERCENT = value ] [ [ , ] CAP_CPU_PERCENT = value ] [ [ , ] AFFINITY
{SCHEDULER = AUTO | (Scheduler_range_spec) | NUMANODE =
(NUMA_node_range_spec)} ] [ [ , ] MIN_MEMORY_PERCENT = value ] [ [ , ]
MAX_MEMORY_PERCENT = value ]) ] [;]
CREATE WORKLOAD GROUP Creates a Resource Governor workload group and
associates the workload group with a Resource Governor resource pool.
ALTER RESOURCE GOVERNOR This command is used to perform the following actions:
ALTER RESOURCE GOVERNOR RECONFIGURE must be issued in order for any
configuration changes to take effect.
When Resource Governor is running, RECONFIGURE applies any configuration changes
requested when the CREATE|ALTER|DROP WORKLOAD GROUP or
CREATE|ALTER|DROP RESOURCE POOL statements are executed.
When the Resource Governor is not enabled, RECONFIGURE enables the Resource
Governor. Enabling Resource Governor has the following results:
Assigning new sessions to the default group The following example assigns all new sessions
to the default workload group by removing any existing classifier function from the Resource
Governor configuration. When no function is designated as a classifier function, all new
sessions are assigned to the default workload group. This change applies to new sessions
only. Existing sessions are not affected. ALTER RESOURCE GOVERNOR WITH
(CLASSIFIER_FUNCTION = NULL); GO ALTER RESOURCE GOVERNOR
RECONFIGURE;



Leave a Reply 0

Your email address will not be published. Required fields are marked *