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

Activity Monitor is the SQL Server tool that provides real-time monitoring of running processes and includes the ability to kill blocking processes. System Monitor (perfmon) is for performance counters, SQL Profiler traces queries, and SSRS is for reporting. Activity Monitor is the correct tool for process management.

Keep practicing — related questions