THERE IS BLOCKING OCCURRING ON YOUR PRODUCTION SQL SERVER, YOU’VE...

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.