Monday 22 April 2019

How to find the process id for all running instance in the Sql Server.

From this post you can learn how to find the process id for all running instance in the sql server.

--Running connections
DECLARE @SPWHO2 TABLE
(
SPID VARCHAR(1000),
[Status] VARCHAR(1000) NULL,
[Login] VARCHAR(1000) NULL,
HostName VARCHAR(1000) NULL,
BlkBy VARCHAR(1000) NULL,
DBName VARCHAR(1000) NULL,
Command VARCHAR(1000) NULL,
CPUTime VARCHAR(1000) NULL,
DiskIO VARCHAR(1000) NULL,
LastBatch VARCHAR(1000) NULL,
ProgramName VARCHAR(1000) NULL,
SPID2 VARCHAR(1000) NULL,
Request VARCHAR(1000) NULL
)

INSERT INTO @SPWHO2
EXEC sp_who2


SELECT * FROM @SPWHO2


when you run the above query you will get the process id for all running instance. we are using here sp_who2 and collect that data in a dynamic table. 

In this post you can learn how to find the process id for all running instance in the sql server.