查询数据库碎片数量:
select COUNT(0) FROM SYS.DM_DB_INDEX_PHYSICAL_STATS(DB_ID(), NULL, NULL , NULL, 'LIMITED')
WHERE AVG_FRAGMENTATION_IN_PERCENT > 10.0 AND INDEX_ID > 0
查询数据库状态:
SELECT DATABASEPROPERTYEX('" + dbName + "','Status')
查询数据库文件&日志文件大小
select distinct name, round(convert(float,size) * (8192.0/1024.0)/1024, 2) size from dbName.dbo.sysfiles