摘要:
--查看系统等待的sql:SELECT ss.host_name, req.session_id ,req.status ,req.blocking_session_id,req.wait_type ,req.wait_time ,req.wait_resource,req.transaction_id ,st.textFROM sys.dm_exec_requests reqCROSS APPLY sys.dm_exec_sql_text(req.sql_handle) as STcross apply sys.dm_exec_sessions sswhere req.status = N& 阅读全文