What should you implement?

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

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.