Microsoft
70-459 · Question #27
You have a database named database1. Database developers report that there are many deadlocks. You need to implement a solution to monitor the deadlocks. The solution must meet the following…
The correct answer is B. an Extended Events session. how_2d00_to_2d00_monitor_2d00_deadlocks_2d00_in_2d00_sql_2d00_server.aspx
Maintain a database
Question
You have a database named database1. Database developers report that there are many deadlocks. You need to implement a solution to monitor the deadlocks. The solution must meet the following requirements: - Support real-time monitoring. - Be enabled and disabled easily. - Support querying of the monitored data. What should you implement? More than one answer choice may achieve the goal. Select the BEST answer.
Options
- Aa SQL Server Profiler template
- Ban Extended Events session
- Clog errors by using trace flag 1204
- Dlog errors by using trace flag 1222
How the community answered
(20 responses)- A5% (1)
- B70% (14)
- C10% (2)
- D15% (3)
Explanation
how_2d00_to_2d00_monitor_2d00_deadlocks_2d00_in_2d00_sql_2d00_server.aspx
Topics
#deadlock monitoring#Extended Events#trace flags#real-time monitoring
Community Discussion
No community discussion yet for this question.