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.
Bạn đang xem 3. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P162 PPTX