ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-462 All Questions

View all questions & answers for the 70-462 exam
Go to Exam

Exam 70-462 topic 2 question 196 discussion

Actual exam question from Microsoft's 70-462
Question #: 196
Topic #: 2
[All 70-462 Questions]

You administer a Microsoft SQL Server database named Orders.
Users report that during peak usage periods, certain operations are taking more time than expected. Your initial analysis suggests that blocking is the cause.
You need to gather more data to be able to determine which processes are being blocked and to identify the root cause.
What should you do?

  • A. Schedule a SQL Agent job to run every 60 seconds and insert the results of executing the sys.dm_os_wait_stats DMV into a table.
  • B. Use System Monitor to catch the Lock Waits/sec event
  • C. Use sp_configure to set the blocked process threshold. Start a trace using SQL Server Profiler to catch the Blocked Process Report event.
  • D. Start a Trace using SQL Server Profiler to catch the Lock: Deadlock event
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
The Lock:Deadlock event class is produced when an attempt to acquire a lock is canceled because the attempt was part of a deadlock and was chosen as the deadlock victim.
Use the Lock:Deadlock event class to monitor when deadlocks occur and which objects are involved. You can use this information to determine if deadlocks are significantly affecting the performance of your application. You can then examine the application code to determine if you can make changes to minimize deadlocks.
References:
https://docs.microsoft.com/en-us/sql/relational-databases/event-classes/lock-deadlock-event-class
by Varad at Oct. 1, 2019, 7:56 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Varad
Highly Voted 5 years, 7 months ago
C. Use sp_configure to set the blocked process threshold. Start a trace using SQL Server Profiler to catch the Blocked Process Report event.
upvoted 7 times
...
MIKU8735_0968
Most Recent 4 years, 4 months ago
Question #50, It's the same question but the answer is C
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago