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

MessageBox Class

Posted on

Dim result = MessageBox.Show("Message To Display", "MessageBox Title", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question) If result = DialogResult.Cancel Then MessageBox.Show("Cancel Button Pressed", "MessageBox Title",MessageBoxButtons.OK , MessageBoxIcon.Exclamation) ElseIf result = DialogResult.No Then MessageBox.Show("No Button Pressed", "MessageBox Title", MessageBoxButtons.OK, MessageBoxIcon.Error) ElseIf result = DialogResult.Yes Then MessageBox.Show("Yes Button Pressed", "MessageBox Title", MessageBoxButtons.OK, MessageBoxIcon.Information) End If var result…

Read More

Delete Logs Older Than 6 Months

Posted on

DELETE FROM LogTable WHERE log_datetime < dateAdd(m, -6, getDate()) Originally Posted on February 25, 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 on a production (non-development) system it is suggested you test…

Read More

Unix Change Static IP

Posted on

It is best to do this on the machine itself and not remotely as you will lose connection. sudo cp /etc/network/interfaces /etc/network/interfaces.`date +"%m-%d-%Y_%I-%M-%S"` sudo sed -i ‘s|address 192.168.1.16|address 10.1.1.16|’ /etc/network/interfaces sudo sed -i ‘s|netmask 255.255.255.0|netmask 255.255.0.0|’ /etc/network/interfaces sudo sed -i ‘s|gateway 192.168.1.1|gateway 10.1.1.1|’ /etc/network/interfaces sudo service resolvconf restart sudo /etc/init.d/networking…

Read More