SELECT session_id,num_writes,st.text AS statement_text FROM sys.dm_exec_connections AS ec CROSS APPLY sys.dm_exec_sql_text(ec.most_recent_sql_handle) AS st ORDER BY num_writes DESC
与跟踪不同,在生产服务器上运行应该是完全安全的.