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
You have a database named database1. Database developers report that there are many deadlocks. You need to implement a s
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
You have a database named database1. Database developers report that there are many deadlocks. You need to implement a s
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!