Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
3.9k views
in Technique[技术] by (71.8m points)

Sp_who2 function SQL Server

I need to know what is the query that is being executed at that moment

CREATE TABLE #sp_who2 
(
    SPID INT,Status VARCHAR(255),
    Login VARCHAR(255),
    HostName VARCHAR(255), 
    BlkBy VARCHAR(255),
    DBName VARCHAR(255), 
    Command VARCHAR(255),
    CPUTime INT, 
    DiskIO INT,
    LastBatch VARCHAR(255), 
    ProgramName VARCHAR(255),
    SPID2 INT, 
    REQUESTID INT
) 

INSERT INTO #sp_who2 
    EXEC sp_who2

SELECT * 
FROM #sp_who2

-- A?adimos los filtros aqui :
--WHERE       DBName like ' WideWorldImporters'
-- A?adimos el order  by aqui :
ORDER BY DBName ASC
--Importante borrar la table temporal :
DROP TABLE #sp_who2

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

I suggest you download and use sp_whoisactive. By default, it will show the text of the currently executing queries. It also has additional features and options to facilitate capturing activity for forensic analysis.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...