MS-SQL - voir les process sql-server
/SQL/MS-SQL - voir les process sql-server.sql
DECLARE @Table TABLE(
SPID INT,
Status VARCHAR(MAX),
LOGIN VARCHAR(MAX),
HostName VARCHAR(MAX),
BlkBy VARCHAR(MAX),
DBName VARCHAR(MAX),
Command VARCHAR(MAX),
CPUTime INT,
DiskIO INT,
LastBatch VARCHAR(MAX),
ProgramName VARCHAR(MAX),
SPID_1 INT,
REQUESTID INT
)
INSERT INTO @Table EXEC sp_who2
SELECT *
FROM @Table
WHERE 1=1
AND DBName = 'siroccov2'
AND Status <> 'sleeping'
--AND HostName NOT LIKE 'OD%'
--AND ProgramName <> 'Microsoft SQL Server Management Studio - Requête'
ORDER BY CPUTime DESC
--DBCC INPUTBUFFER(149)
--KILL 149