What values in each column should you look for?

HOTSPOT

You have a database named DB1.

A user named User1 reports that a specific query takes a long time to run. You suspect that User1 is blocked by a session from User2. The session ID for User1 is 54. The session ID for User2 is 62.

You need to use Activity Monitor to identify the session that is causing the blocking activity.

What values in each column should you look for? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

View Answer

Answer:

Explanation:

References: https://blog.sqlauthority.com/2014/06/27/sql-server-activity-monitor-to-identify-blocking-find­expensive-queries/