Thursday, June 30, 2011

Find Currently Executing SQL Statements With IP Address

Below script to find out the currently executing sql statements, of course you can use the ‘sp_who2’ 

Here is the script to find currently running Queries:

use master 
GO 
Select C.client_tcp_port, T.text
from sys.dm_exec_connections  C 
CROSS APPLY sys.dm_exec_sql_text(most_recent_sql_handle) T 
where client_net_address = 'myComputerIpHere' 
GO 

Just replace your server IP address with 'myComputerIpHere'.
Show All Running Processes. Manage a Running Process. List of currently running process. What SQL Statements Are Currently Executing. Monitoring running processes in SQL Server 2008 R2. Find Currently running query process in MS SQL Server 2005. List all processes running on SQL Server. SQL Server statements currently running with. Kill SQL Server Process Ids. Display SQL Server Currently Running Processes. Display SQL Server Currently Running queries. Find blocking processes in sql server 2012. Find blocking processes in sql server 2008. SQL Server:Check for all running process and Kill. Finding currently running queries. How to View Currently Executing Queries in SQL Server. List the queries running on SQL Server. Query to list currently running queries on the sql server. Identifying currently running SQL queries. List All Currently Running Queries.

2 comments:

Post a Comment