15. There is blocking occurring on your production SQL Server, you’ve found the
session at the head of the blocking chain, and retrieved the SQL_HANDLE.
Now you need to find the query executed by the user. Which DMV can help?
A. Sys.dm_exec_requests
B. sys.dm_exec_sql_text
C. sys.dm_db_query_plans
D. sys.dm_stored_proc_text
The correct answer is B; passing the SQL handle to this DMV will return the
text of the actual query executed by the user causing blocking. Answer A can
be useful to find the user causing blocking, but not the query text. Neither
options C or D are valid DMVs.
Bạn đang xem 15. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P163 DOC