Which of the following actions should you take?

You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com.
You have been informed of several deadlocks on an existing ABC.com database, named
ABCDB1. You have been tasked with devising a strategy to examine the deadlocks in real-time.
The strategy should allow for trouble-free enabling and disabling, and also allow monitored
information to be queried.

Which of the following actions should you take?

You work as a developer at ABC.com. The ABC.com network consists of a single domain named
ABC.com.
You have been informed of several deadlocks on an existing ABC.com database, named
ABCDB1. You have been tasked with devising a strategy to examine the deadlocks in real-time.
The strategy should allow for trouble-free enabling and disabling, and also allow monitored
information to be queried.

Which of the following actions should you take?

A.
You should consider running an Extended Events session.

B.
You should consider making use of a SQL Server Profiler template.

C.
You should consider making use of DDL statements.

D.
You should consider making use of the Data Profile Viewer.

Explanation:



Leave a Reply 1

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