푸팟퐁쿼리

drop table if exists dbo.Event_Data go select n.value('(@timestamp)[1]', 'datetime2') AS [utc_timestamp], n.value('(action[@name="sql_text"]/value)[1]', 'nvarchar(2000)') as sql_text, ISNULL(n.value('(action[@name="batch_text"]/value)[1]', 'nvarchar(100)'),'') as batch_text, n.value('(action[@name="client_app_name"]/value)[1]', 'nvarchar(100)') as client_app_name, n.value('(action[@name="client_..

SELECT sqltext.TEXT, req.session_id, req.status, req.command, req.cpu_time, req.total_elapsed_time, DB_NAME(database_id) AS dbName FROM sys.dm_exec_requests req CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext