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:
Plus next maybe useful information for you.
Query is here:
I hope that query will help you with performance problem!