Find Currently Running Query – T-SQL

Posted on By David Kittell 
SELECT sqltext.TEXT,
req.session_id,
req.status,
req.command,
req.cpu_time,
req.total_elapsed_time
FROM sys.dm_exec_requests req
CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext

KILL [session_id]

Reference: http://blog.sqlauthority.com/2009/01/07/sql-server-find-currently-running-query-t-sql/

Originally Posted on April 29, 2013
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code MSSQL - Audit

Related Posts

Export To Excel

Posted on

Add GridView, Datasource, and Button <%@ Page Language="C#" AutoEventWireup="true" CodeFile="exporttest.aspx.cs" EnableEventValidation="false" Inherits="ExportTest" %> <form id="form1" runat="server"> <asp:gridview runat="server" id="gvExport" allowpaging="True" autogeneratecolumns="False" datakeynames="id" datasourceid="dsExport"> </asp:gridview> <asp:sqldatasource id="dsExport" runat="server" conflictdetection="CompareAllValues" connectionstring="<%$ ConnectionStrings:DbConnection %>" selectcommand="SELECT top 100 * FROM Users"> </asp:sqldatasource> <asp:button id="btnExport" runat="server" onclick="Button1_Click" text="Export To Excel" /> </form> using System; using…

Read More

Escape Characters

Posted on

‘ for a single quote " for a double quote for a backslash \0 for a null character a for an alert character b for a backspace f for a form feed n for a new line r for a carriage return t for a horizontal tab v for a…

Read More

Prevent Spaces In Textbox

Posted on

<script type="text/javascript"> function stripspaces(input) { input.value = input.value.replace(/s/gi, ""); return true; } </script> <input type="text" ID="txtUserID" MaxLength="20" onkeyup="javascript:stripspaces(this)" onkeydown="javascript:stripspaces(this)"> Originally Posted on November 7, 2013Last Updated on October 26, 2015 All information on this site is shared with the intention to help. Before any source code or program is ran…

Read More