如何快速而準確獲取數(shù)據(jù)庫信息

DBA總前背 就是 Monitor 磁盤空間的使用狀況，當(dāng)達到某一個設(shè)定的閥值時，會發(fā) 郵件，空間緊張的空間緊張的Driver (4.34 USEUSESETNOCOUNT--===================public8.9. = --NULL:all = --NULL:all13.--================endpublicvariables--===================private@sql,@exec_sql,@database_name pages@sql=select pages=fromsys.partitionspinnerjoinsys.allocation_unitsaonp.partition_id=,@database_name=,@exec_sql= pages=32.--================endprivatevariables pages pagesidintidentity(1,1)notnullPRIMARY,database_idint,database_name pagesint@tb_dbSizeidintidentity(1,1)notnullPRIMARY,sizeint,name ,database_idint,typebit,on_drivechar(1),f_name --size=INSERTINTO,F.nameASFROMsys.master_filesASFWITHINNERJOINsys.databasesASDBWITHONF.database_id=DB.database_idpagesdeclarecur_databasecursorlocalstaticforward_onlyselectfromsys.databases--==============youcanfilterthesystemdatabaseor--wherenamenotopenfetchnextfromcur_databaseinto@database_namewhile(@@FETCH_STATUS=@exec_sql=N'USE'+QUOTENAME(@database_name)+ +execsys.sp_executesql int pages pagesinsertinto selectdb_id(@database_name),@database_name,@ fetchnextfromcur_databaseintoclosedeallocate--select*from --============================================endallpages--====================alldatabasesize;WITHdbSize--type=(database_name=fileSize=sum(size)--FROMWHEREtype=GROUPBY),logSize--type=(database_name=fileSize=sum(size)--FROMWHEREtype=GROUPBY)(database_name=dbSize=sum(size)--FROMGROUPBYserver_name=,[dbSize(MB)]=S.dbSize*,[dataSize(MB)]=A.fileSize*,[unallocatedSize(MB)]=ltrim(str((casewhenA.fileSize/*@dbsize*/ (convert(15,2),A.fileSize/*@dbsize*/)-convert(dec *8192/elseend),15,2)+',data_Drive=,[logSize(MB)]=B.fileSize*,log_Drive=FROMdbSizeASINNERJOINlogSizeASONA.database_id=INNERJOINSizeASONA.database_id=INNERJOIN pagesASONA.database_id=WHEREA.database_name=AND(A.on_drive=ORB.on_drive=)ORDERBYS.dbSize--=================endalldatabasesizestatistics;WITHSize=cast(sum(size)*8./1024./1024.ASFROMGROUPBY)server_name=,[0]+[1]AS,[0]AS,[1]ASFROMSELECTFROM)ASFORtype193.)B195.195.--=================endinstance說說參數(shù)@d