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.
A. Log errors by using trace flag 1222
B. Log errors by using trace flag 1204
C. A SQL Server Profiler template
D. An Extended Events session

  Discussion forum


Leave an answer