Answer E is correct. SQL Profiler is the only tool that will provide you with sufficient information to trace what is in use when the deadlocks occur. The correct objects to be monitoring are the deadlock chain events. For more information, see the following sources:
|