![Query to Find and Kill Long Running Transactions in SQL Server 2008 R2 or 2012 | Chaya - Digital Zen Query to Find and Kill Long Running Transactions in SQL Server 2008 R2 or 2012 | Chaya - Digital Zen](https://chayadigital.files.wordpress.com/2014/09/image2.png)
Query to Find and Kill Long Running Transactions in SQL Server 2008 R2 or 2012 | Chaya - Digital Zen
![Microsoft Sql Server Tutorials: Find out Long Running query using sp_who2 with Dynamic Management Views (DMV) Microsoft Sql Server Tutorials: Find out Long Running query using sp_who2 with Dynamic Management Views (DMV)](http://lh5.ggpht.com/-cyAUoM12i1g/T07U9PxWBvI/AAAAAAAAASs/kKAXBk1l-4o/long_run1%25255B12%25255D.jpg?imgmax=800)
Microsoft Sql Server Tutorials: Find out Long Running query using sp_who2 with Dynamic Management Views (DMV)
![SQL SERVER - Query to Find the Longest Running Function - Function Elapsed Time - SQL Authority with Pinal Dave SQL SERVER - Query to Find the Longest Running Function - Function Elapsed Time - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/wp-content/uploads/2018/09/longrunning-fn.png)
SQL SERVER - Query to Find the Longest Running Function - Function Elapsed Time - SQL Authority with Pinal Dave
![SQL SERVER - Get Query Plan Along with Query Text and Execution Count - SQL Authority with Pinal Dave SQL SERVER - Get Query Plan Along with Query Text and Execution Count - SQL Authority with Pinal Dave](https://blog.sqlauthority.com/i/b/explan1.jpg)