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!


Comentários