YOU’VE RECENTLY ENABLED RESOURCE GOVERNOR TO ENSURE THE FINANCE AND...

3. You’ve recently enabled Resource Governor to ensure the Finance and HR

departments each receive a fair share of CPU and memory on a consolidated

SQL Server. Since Resource Governor has been operating, some users have

experienced connection timeouts and you suspect the classifier function may

be the cause. How could you identify the cause?

A. Run SQL Profiler

B. Connect using Dedicated Admin Connection

C. Capture Performance Monitor data

D. Reboot the server and see if problem recurs

The correct answer is B. Connections using Dedicated Admin Connection

(DAC) are now exposed to the session classification so a problem with the

UDF used for classification will not be experienced by a DAC connection.

SQL profiler trace may help, but isn’t the fastest method. There are no

performance monitor counters to help with this situation. Rebooting will

not prove the cause of the problem.