What should you do?

You are troubleshooting an application that runs a query.

The application frequently causes deadlocks. You need to identify the isolation level used by the query when a deadlock occurs.

What should you do? More than one answer choice may achieve the goal. Select the BEST answer.
A . Query the sys.dm_exec_requests dynamic management view.
B . Create a trace in SQL Server Profiler that contains the Deadlock graph event.
C . Query the sys.dm_exec_sessions dynamic management view.
D . Enable trace flag 1222, and then view the SQL Server error log.

View Answer

Answer: C

Explanation:

– sys.dm_exec_sessions

Returns one row per authenticated session on SQL Server. sys.dm_exec_sessions is a serverscope view that shows information about all active user connections and internal tasks. Include the column:

Transaction_isolation_level smallint

Transaction isolation level of the session.

0 = Unspecified

1 = ReadUncomitted

2 = ReadCommitted

3 = Repeatable

4 = Serializable

5 = Snapshot Is not nullable.