1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
|
create proc sp__cpu as
/*
* Auteur : Fabien Celaia
* Date : 11/01/2002
* Desc : Affiche les processus utilisateurs en cours de traitement
* Parm : -
*/
SELECT
convert(char(4), spid) Spid,
convert(char(4), blocked) Blk,
convert(char(4), cpu) CPU,
left(loginame,15) 'Users',
left(hostname, 15) 'Host',
left(db_name(dbid),15) DB,
convert(char(20), cmd) Command,
convert(char(12), program_name) Program ,
convert(char(10), status) Status
FROM master..sysprocesses
WHERE spid <> @@spid
AND status not in ( 'BACKGROUND', 'sleeping')
ORDER BY cpu DESC
GO
GRANT execute on sp__cpu to public
GO |
Partager