You are developing an application that connects to a database.
The application runs the following jobs:
The READ_COMMITTED_SNAPSHOT database option is set to OFF, and auto-content is set to ON. Within
the stored procedures, no explicit transactions are defined.If JobB starts before JobA, it can finish in seconds. If JobA starts first, JobB takes a long time to complete.
You need to use Microsoft SQL Server Profiler to determine whether the blocking that you observe in JobB is
caused by locks acquired by JobA.
Which trace event class in the Locks event category should you use?
A.
LockAcquired
B.
LockCancel
C.
LockDeadlock
D.
LockEscalation
Explanation:
The Lock:Acquiredevent class indicates that acquisition of a lock on a resource, such asa data page, has been
achieved.
The Lock:Acquired and Lock:Released event classes can be used to monitor when objects are being locked,
the type of locks taken, and for how long the locks were retained. Locks retained for long periods of time may
cause contention issues and should be investigated.
Correct