新增 **資料表值函數 (TVF)**,接受兩個參數:
@session_id (SPID)@request_id (請求 ID,通常為 0)回傳欄位:event_type (Language/RPC)、parameters、event_info (實際 T-SQL 文字)。
-- 查看 SPID 55 目前輸入緩衝區 SELECT * FROM sys.dm_exec_input_buffer(55, 0);
SELECT
r.session_id,
s.login_name,
s.host_name,
r.status,
r.command,
r.start_time,
ib.event_info AS CurrentBatchText
FROM sys.dm_exec_requests r
JOIN sys.dm_exec_sessions s ON s.session_id = r.session_id
CROSS APPLY sys.dm_exec_input_buffer(r.session_id, r.request_id) ib
WHERE s.is_user_process = 1
AND r.session_id <> @@SPID; -- 排除自己
-- 必須建立暫存表 + INSERT EXEC + 游標迴圈
CREATE TABLE #ib (EventType NVARCHAR(30), Parameters INT, EventInfo NVARCHAR(MAX));
DECLARE @spid INT, @sql NVARCHAR(MAX);
DECLARE cur CURSOR FOR SELECT session_id FROM sys.dm_exec_sessions WHERE is_user_process=1;
OPEN cur;
FETCH NEXT FROM cur INTO @spid;
WHILE @@FETCH_STATUS=0 BEGIN
SET @sql = 'DBCC INPUTBUFFER(' + CAST(@spid AS VARCHAR) + ') WITH NO_INFOMSGS';
INSERT #ib EXEC (@sql);
FETCH NEXT FROM cur INTO @spid;
END
CLOSE cur; DEALLOCATE cur;
SELECT * FROM #ib;
sys.dm_exec_session_wait_stats:會話級等待統計。sys.dm_exec_query_statistics_xml:即時取得執行中查詢的實際執行計畫 XML。TRUNCATE TABLE ... WITH (PARTITIONS(...)):分割表截斷特定分割區。