Deniz SQL Process Viewer displays information about client applications and processes that are currently running on an instance of SQL Server Database Engine.
In addition, Deniz SQL Process Viewer provides the functionality to view the T-SQL statements each process last executed and any locks the statement is holding.
Deniz SQL Process Viewer also allows a system administrator to view blocked processes and optionally terminate or "kill" the blocking process (or any problematic process).