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