• Grey Twitter Icon
  • Grey Facebook Icon
  • Grey LinkedIn Icon
  • Grey Google+ Icon

© 2016 - 2019 All rights reserved. PigeonSQL.com | Filip Holub

Daily use in Management Studio - #3 Query to find running queries via T-SQL

May 13, 2018

I use this script every day for identify all running, runnable and suspended queries on the SQL Server. The script shows you a couple of useful and important information for next investigating your problematic query



The most important information for you:


- session_id

- start_time 

- databasename

- host_name

- login_name

- status

- command

- wait_type

- last_wait_type

- cpu_time

- reads

- logical_reads

- writes

- query_plan


Plus next maybe useful information for you.


Query is here:



I hope that query will help you with performance problem!






Please reload

Please reload

  • Facebook Social Icon
  • Google+ Social Icon
  • LinkedIn Social Icon
  • Twitter Social Icon