{"id":617,"date":"2012-07-25T00:00:47","date_gmt":"2012-07-24T22:00:47","guid":{"rendered":"http:\/\/www.sqlserver.fr\/blog\/?p=617"},"modified":"2026-05-02T14:31:06","modified_gmt":"2026-05-02T12:31:06","slug":"liste-des-processus-actifs","status":"publish","type":"post","link":"https:\/\/www.sqlserver.fr\/blog\/liste-des-processus-actifs\/","title":{"rendered":"Liste des processus actifs"},"content":{"rendered":"

Voici un petit script tr\u00e8s utile pour d\u00e9terminer les requ\u00eates qui sont en train de tourner sur un serveur SQL Server.<\/p>\n

En effet, les outils tels que le g\u00e9n\u00e9rateur de profils ou bien les \u00e9v\u00e8nements \u00e9tendus permettent de capter le d\u00e9but ou la fin d’un traitement, mais ne permettent pas de lister les traitements en cours d’ex\u00e9cution.<\/p>\n

Voici donc un petit script, tr\u00e8s utile, pr\u00e9sentant notamment le co\u00fbt actuel de chaque traitement (consommation CPU, consommation I\/O, …)<\/p>\n

-- Liste des processus actifs\r\n-- Auteur : Jean-Nicolas BERGER (www.sqlserver.fr)\r\n\r\nselect r.session_id,\r\n\t\tstatus,\r\n\t\tqt.text,\r\n\t\tsubstring(qt.text,r.statement_start_offset\/2+1,\r\n\t\t(case when r.statement_end_offset <= r.statement_start_offset\r\n\t\t\tthen len(convert(nvarchar(max),qt.text))*2\r\n\t\t\telse r.statement_end_offset\r\n\t\t\tEND - r.statement_start_offset)\/2+1)\r\n\t\t\tAS query_text,\r\n\t\tqt.dbid,\r\n\t\tqt.objectid,\r\n\t\tr.cpu_time,\r\n\t\tr.total_elapsed_time,\r\n\t\tr.reads,\r\n\t\tr.writes,\r\n\t\tr.logical_reads,\r\n\t\tr.scheduler_id\r\nfrom sys.dm_exec_requests r\r\n\tcross apply sys.dm_exec_sql_text(sql_handle) as qt\r\nWHERE r.session_id>50\r\norder by r.scheduler_id,r.status,r.session_id<\/pre>\n
Ce script permet notamment, pour certains blocs de code comme par exemple les proc\u00e9dures stock\u00e9es, d’identifier au coeur du module l’instruction T-SQL exacte en cours d’ex\u00e9cution.<\/p>\n
Sans aller chercher les gros outils tels que les rapports SSMS, on a d\u00e9j\u00e0 un aper\u00e7u tr\u00e8s rapide de ce qui tourne…<\/p>\n","protected":false},"excerpt":{"rendered":"
Voici un petit script tr\u00e8s utile pour d\u00e9terminer les requ\u00eates qui sont en train de tourner sur un serveur SQL Server. En effet, les outils tels que le g\u00e9n\u00e9rateur de profils ou bien les \u00e9v\u00e8nements \u00e9tendus permettent de capter le … Continuer la lecture →<\/span><\/a><\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-617","post","type-post","status-publish","format-standard","hentry","category-outils"],"_links":{"self":[{"href":"https:\/\/www.sqlserver.fr\/blog\/wp-json\/wp\/v2\/posts\/617","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlserver.fr\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlserver.fr\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlserver.fr\/blog\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlserver.fr\/blog\/wp-json\/wp\/v2\/comments?post=617"}],"version-history":[{"count":8,"href":"https:\/\/www.sqlserver.fr\/blog\/wp-json\/wp\/v2\/posts\/617\/revisions"}],"predecessor-version":[{"id":1945,"href":"https:\/\/www.sqlserver.fr\/blog\/wp-json\/wp\/v2\/posts\/617\/revisions\/1945"}],"wp:attachment":[{"href":"https:\/\/www.sqlserver.fr\/blog\/wp-json\/wp\/v2\/media?parent=617"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlserver.fr\/blog\/wp-json\/wp\/v2\/categories?post=617"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlserver.fr\/blog\/wp-json\/wp\/v2\/tags?post=617"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}