Log--检查各数据库日志的使用情况
-- Recovery model, log reuse wait description, log file size,
-- log usage
size and compatibility level for all databases on
instance
SELECT
db.[name] AS [Database Name] ,
db.recovery_model_desc
AS [Recovery Model] ,
db.log_reuse_wait_desc AS [Log Reuse Wait Description]
,
ls.cntr_value AS [Log Size (KB)] ,
lu.cntr_value AS [Log Used (KB)]
,
CAST(CAST(lu.cntr_value AS FLOAT)
/ CAST(ls.cntr_value+1 AS
FLOAT) AS DECIMAL(18,2))
* 100 AS [Log Used %]
,
db.[compatibility_level] AS [DB Compatibility Level]
,
db.page_verify_option_desc AS [Page Verify Option]
FROM sys.databases AS
db
INNER JOIN sys.dm_os_performance_counters AS lu
ON db.name =
lu.instance_name
INNER JOIN sys.dm_os_performance_counters AS ls
ON
db.name = ls.instance_name
WHERE lu.counter_name LIKE ‘Log File(s) Used Size
(KB)%‘
AND ls.counter_name LIKE ‘Log File(s) Size (KB)%‘ ;
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
