MSSQL|How Identify long running queries and clear session
Here's a quick summary:
Identifying Long-Running Queries: The video explains how to use a query to find sessions that are holding up resources (1:14).
Simulating a Problem: It simulates a developer accidentally running an infinite loop query that hogs resources (0:17-1:44).
Killing the Session: The video demonstrates how to kill the specific session using the KILL command and session ID (2:11).
Filtering by Elapsed Time: It suggests adding a filter to find queries that have been running for a specified duration (2:36). The elapsed time is in milliseconds (2:48).