Search
  • Filip Holub

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


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!


74 views
  • Grey Twitter Icon
  • Grey Facebook Icon
  • Grey LinkedIn Icon

© 2020 All rights reserved. PigeonSQL.com | Filip Holub

  • Twitter Social Icon
  • Facebook Social Icon
  • LinkedIn Social Icon