数据库事务查看
时间:2010-08-27 来源:无为之大道---无道
SELECT RS.wait_time,RS.cpu_time,RS.status,text
,A.name
FROM sys.dm_exec_requests AS RS
CROSS APPLY sys.dm_exec_sql_text(RS.sql_handle)
LEFT JOIN sys.databases AS A ON RS.database_id=A.database_id
,A.name
FROM sys.dm_exec_requests AS RS
CROSS APPLY sys.dm_exec_sql_text(RS.sql_handle)
LEFT JOIN sys.databases AS A ON RS.database_id=A.database_id
相关阅读 更多 +