???????????????飺

DBCC SQLPERF(LOGSPACE)
GO
SELECT name??recovery_model_desc??log_reuse_wait??log_reuse_wait_desc
FROM sys.databases
GO

???????Log Space Used(%)??????????λ?????????????????????LOG_BACKUP????ζ??????????????лkalagooooo????????????????????????SQLServer????ζ??SQLServer?????????????????????????????????

????????2????????????

??????????????????????????????????ACTIVE_TRANSACTION??????????????????????????

DBCC OPENTRAN
GO
SELECT  *
FROM    sys.dm_exec_sessions AS t2 ??
        sys.dm_exec_connections AS t1
        CROSS APPLY sys.dm_exec_sql_text(t1.most_recent_sql_handle) AS st
WHERE   t1.session_id = t2.session_id
        AND t1.session_id > 50

??????к????

?????????????????????????????????????????????????ò????????????????????????У??????KILL SPID?????????