Multiple choice technology databases

How can a blocking process be killed?

  1. Find the process in System Monitor and select Kill Process.

  2. Find the process in Activity Monitor and select Kill Process.

  3. Find the process in SQL Profiler and select Kill Process.

  4. Find the process in SSRS and select Kill Process.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In SQL Server, blocking processes can be identified and killed using Activity Monitor. This tool provides a real-time view of process activity and allows terminating blocking processes. System Monitor is for performance counters, SQL Profiler traces events, and SSRS is for reporting.

Keep practicing — related questions