通过python pymssql直接访问SQLserver数据库,查找其数据库mode,这个脚本具有很强的抛砖引玉特性:
1.可以巡检多台多数据库服务器
2.query内容可以多样化,譬如查询死锁、连接数等
当然还有更多需要优化的地方:
1.输出内容未优化
2.未捕获异常
3.未多线程化
#!/usr/bin/python3
#coding=utf-8
import pymssql
odbj=[("10.1.10.67","sa","r2hat","master"),("10.1.10.9","s3y3zh","r232hat","master")]#相关信息有做处理
for (h,u,p,d) in odbj:
conn = pymssql.connect(host=h,user=u,password=p, database=d)
cur = conn.cursor()
query="select name, database_id, recovery_model_desc from sys.databases"
query1="SELECT database_name,type,MAX(backup_finish_date) AS backup_finish_date FROM msdb.dbo.backupset GROUP BY database_name,type ORDER BY database_name,type"
cur.execute(query1)
conn.commit