08 2016 档案

python for MSSQLserver
摘要：# -*- coding: utf-8 -*- '''python coded by written in 2016/8/31 Used for get win os log for each windows server''' '''pymssql 帮助文档http://pymssql.org/e 阅读全文
posted @ 2016-08-31 17:39 两年十一时 阅读(196) 评论(0) 推荐(0)
python for mysql
摘要：# -*- coding: utf-8 -*- '''python coded by written in 2016/8/31 Used for get win os log for each windows server''' '''pymssql 帮助文档http://pymssql.org/e 阅读全文
posted @ 2016-08-31 17:38 两年十一时 阅读(263) 评论(0) 推荐(0)
调优SQL思路
摘要：--调优SQL --sqlreview ->logshipping -> ag辅助副本 --查看正确的执行计划 打开实际的执行计划set statistics io on --查看错误的执行计划 打开实际的执行计划set statistics io on --对比 正确和错误 执行计划的差别紧盯最大 阅读全文
posted @ 2016-08-30 15:45 两年十一时 阅读(222) 评论(0) 推荐(0)