Technical Article

A simple SysProcess query

,

A quick and simple SysProcess query which will display most of the common parameters of interest. Can be useful for a quick reference. [Not disputing the fact of SP_WHO and SP_WHO2 and SP_WHO3 ... et al]

USE MASTER
--
SELECT SPID,KPID, '[' + CAST(DBID AS VARCHAR(10)) + '] ' + DB_NAME(DBID) DBNAME, PROGRAM_NAME, HOSTNAME, CMD, OPEN_TRAN, LASTWAITTYPE, CPU, PHYSICAL_IO, STATUS, LOGINAME, NT_USERNAME, NT_DOMAIN
FROM MASTER..SYSPROCESSES 
WHERE SPID > 50

Rate

4 (1)

You rated this post out of 5. Change rating

Share

Share

Rate

4 (1)

You rated this post out of 5. Change rating