/*查询哪些日志记录会导致如此的急剧变化。*/
select @@SPID,Operation,dblog.[Transaction Name],[Transaction ID],AllocUnitName,[Server UID],dblog.SPID,dblog.[Begin Time],
dblog.[AllocUnitName]
,dblog.[RowLog Contents 1]
from fn_dblog(null, null) dblog
WHERE dblog.Begin Time >= '2020/01/01'
/*根据某个SPID，session_id查询对应的执行sql语句*/
select er.session_id,CAST(csql.text AS varchar(255)) AS CallingSQL
from master.sys.dm_exec_requests er WITH (NOLOCK)
CROSS APPLY MASTER.sys.fn_get_sql (er.sql_handle) csql
where er.session_id =SPID
免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@yisu.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。
