1 SELECT '进程ID' = Str(A.Spid, 4),
 2        '进程ID状态' = CONVERT(VARCHAR(100), A.Status),
 3        '阻塞进程的进程ID' = Str(A.Blocked, 2),
 4        '工作站名称' = CONVERT(VARCHAR(100), A.Hostname),
 5        '执行命令的用户' = CONVERT(VARCHAR(100), A.loginame),
 6        '数据库名' = CONVERT(VARCHAR(100), Db_name(A.Dbid)),
 7        '应用程序名' = CONVERT(VARCHAR(100), A.Program_Name),
 8        '正在执行的命令' = CONVERT(VARCHAR(100), A.Cmd),
 9        '累计CPU时间' = Str(A.Cpu, 7),
10        'IO' = Str(A.Physical_Io, 7),
11        '登录名' = A.Loginame,
12        '登录时间' = A.login_time,
13        '执行语句'=B.Text
14 FROM   Master..Sysprocesses A
15        CROSS Apply Sys.Dm_exec_sql_text(A.Sql_Handle) B
16 WHERE  Spid IN (SELECT TOP 10 spid
17                 FROM   Master..Sysprocesses
18                 ORDER  BY physical_io DESC)
19 ORDER  BY login_time 

 

TRANSLATE with x English

Arabic	Hebrew	Polish
Bulgarian	Hindi	Portuguese
Catalan	Hmong Daw	Romanian
Chinese Simplified	Hungarian	Russian
Chinese Traditional	Indonesian	Slovak
Czech	Italian	Slovenian
Danish	Japanese	Spanish
Dutch	Klingon	Swedish
English	Korean	Thai
Estonian	Latvian	Turkish
Finnish	Lithuanian	Ukrainian
French	Malay	Urdu
German	Maltese	Vietnamese
Greek	Norwegian	Welsh
Haitian Creole	Persian

  TRANSLATE with COPY THE URL BELOW Back EMBED THE SNIPPET BELOW IN YOUR SITE Enable collaborative features and customize widget: Bing Webmaster Portal Back