Which event should you select?

You administer a Microsoft SQL Server 2012 database.

Users report that a billing application becomes unresponsive during busy times of the day.

While investigating, you notice large number of processes taking or waiting for table locks.

You suspect that SQL Server is assigning stronger locks to queries.

You start a SQL Profiler trace.

Which event should you select?
A . Deadlock graph
B . Lock: Escalation
C . Lock: Timeout
D . Lock: Deadlock

Answer: B

Latest 70-462 Dumps Valid Version with 301 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments