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)%' ;
最新文章
- java JFileChooser选择文件和保存文件
- assign,copy,strong,weak,nonatomic的理解
- for循环相关
- minhash
- 51nod 1092 回文字符串 (dp)
- iOS开发:UINavigationController常用操作
- 【杭州(含嘉兴,绍兴,金华,湖州,义乌)】Uber优步司机奖励政策(2月1日~2月7日)
- 使用xdebug+eclipse远程调试centOS7上的PHP代码
- JAVA HashMap与HashTable 区别
- wget www.baidu.com执行流程分析
- 解决Flex4 发布后访问 初始化极其缓慢的问题
- DLL编写教程(绝对经典之作)
- Python 3 学习笔记
- cocos2dx进阶学习之CCLayer
- Java线程池使用
- 使用Myeclipse10.0自动生成搭建SSH框架(数据库表自动反向转换成Hibernate实体)实现用户登陆
- Vue生命周期详解
- sql中的不常见查询
- vim查找格式
- [skill] ctags支持函数声明