• 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

RECENT POST
Please reload

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