摘要： 数据库优化1. 查看活动监视器。2. 查看慢Sql.3. 查看Resources Waits里面等等类型Lock的多不多。4. 逻辑读太多，cpu就会高。select * from syserrorlog where friendlymsg like '%列“%”不属于表 Table%'select errorpage a,createdate aa,friendlymsg c1,* from syserrorlog where friendlymsg like '%was deadlocked on lock | communication buffer resour 阅读全文