Microsoft
70-459 · Question #105
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…
The correct answer is C. Query the sys.dm_exec_sessions dynamic management view. sys.dm_exec_sessions Returns one row per authenticated session on SQL Server. sys.dm_exec_sessions is a server- scope view that shows information about all active user connections and internal tasks. Include the column: - transaction_isolation_level - Transaction isolation…
Administer SQL Server
Question
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.
Options
- AQuery the sys.dm_exec_requests dynamic management view.
- BCreate a trace in SQL Server Profiler that contains the Deadlock graph event.
- CQuery the sys.dm_exec_sessions dynamic management view.
- DEnable trace flag 1222, and then view the SQL Server error log.
How the community answered
(29 responses)- A10% (3)
- B7% (2)
- C79% (23)
- D3% (1)
Explanation
- sys.dm_exec_sessions Returns one row per authenticated session on SQL Server. sys.dm_exec_sessions is a server- scope view that shows information about all active user connections and internal tasks. Include the column: - transaction_isolation_level - Transaction isolation level of the session. - 0 = Unspecified - 1 = ReadUncomitted - 2 = ReadCommitted - 3 = Repeatable - 4 = Serializable - Is not nullable. - sys.dm_exec_sessions (Transact-SQL)
Topics
#deadlock troubleshooting#isolation levels#sys.dm_exec_sessions#DMVs
Community Discussion
No community discussion yet for this question.