June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Find Currently Running Query – T-SQL

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL Server Security
This is the script which I always had in my archive. Following script find out which are the queries running currently on your server. SELECT sqltext.TEXT, req.session_id, req.status, req.command, req.cpu_time, req.total_elapsed_time FROM sys.dm_exec_requests req CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext While running above query if you find any query which is running for…
Read More

SQL SERVER – 2008 – Change Color of Status Bar of SSMS Query Editor

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Best Practices, SQL Server Management Studio, SQL Server Security, SQL Utility
This is one very interesting issue which I have started to follow recently. Just like any other organization my company has many servers. Some are production and some are development. It is very much necessary that query which are written for developer environment does not run for production environment accidentally.…
Read More

SQL SERVER – 2008 – 2005 – Find Longest Running Query – TSQL

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server DBCC, SQL Stored Procedure

UPDATE : Updated this query with bug fixed with one more enhancement SERVER – 2008 – 2005 – Find Longest Running Query – TSQL – Part 2.
Recently my company owner asked me to find which query is running longest. It was very interesting that I was not able to find any T-SQL script online which can give me this data directly. Finally, I wrote down very quick script which gives me T-SQL which has ran on server along with average time and maximum time of that T-SQL execution. As I keep on writing I needed to know when exactly logging was started for the same T-SQL so I had added Logging start time in the query as well.

Read More