top of page

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!


bottom of page