新區(qū)階段性報(bào)告附8oa數(shù)據(jù)庫(kù)分析

蘇州新區(qū)管委會(huì)SQL 時(shí)間：2015年12月本文件中出現(xiàn)的任何文字?jǐn)⑹?、文檔格式、插圖、、方法、 均屬蘇州恒建有限，受到有關(guān)及 建的或 數(shù)據(jù)庫(kù)SQLServer:45ms3I/O 數(shù)據(jù)庫(kù)Attach2012不可 內(nèi)存不夠，bufferpages有時(shí)只有12%可用。 12月17日上午7:59分產(chǎn)生表鎖 數(shù)據(jù)庫(kù)的Job在12月14、15、16號(hào)均執(zhí)行失敗 超長(zhǎng)的job時(shí)間，10selectMailGuidfrom OwnerUserGuid='2120eaa7-7cf2-49be8053-29e77da88ae5'anddeleteFlag=0andandhaveread=0andNoNeedRemind=0orderby Row_IDdesc每次執(zhí)行等待時(shí)間需要99.55s，而執(zhí)行次數(shù)又比較多（36,573.00類的問題，建議盡量綁定變量，使用過(guò)程。列表SQLCPU BelongUserGuid=@BelongUserGuidAND0MailGuid,Subject,FromDispName,Row_ID,SendTime,NeedTaskMo...000'andhaveread=0andNoNeedRemind=0orderbyRow_IDdescSelectTop5*Fromwd_24whereisnull(FileType,'')<>''and(De...rDelFlagisnull)andFileType='dzb'orderby OrderNumber=@OrderNumberWHERESelectcount(*)fromwd_24whereisnull(FileType,'')<>''(DelFlag=0orDelFlagisnull)and0 deleteFlag=0andhaveread= SELECTCategoryGuidFROMWebInfo_CategoryUserRightUserGuid=@UserGuidand0 selectHandleUrl,MessageItemGuid,Title,GenerateDate,ArchiveNofr...5b47'andMessageTypeinorderbyselect*fromMessages_CenterwhereSendMode=4andDoneDaten...6cab6e8198bf'))andMessageType='閱讀'orderbyRow_IDselect1fromMessages_CenterwhereSendMode=4andDoneDaten...8186'andMessageTypeinorderbyRow_IDselect1fromMessages_CenterwhereSendMode=4andDoneDateisn...'')andMessageTypeinorderbyselectHandleUrl,MessageItemGuid,Title,GenerateDate,ArchiveNofr...'')andMessageTypeinorderbySELECTcount(*)FROMFrame_OnlineUserWHERE0 isConvert_CEB2CEBXisselecttop50*fromFrame_AttachInfowhere=...FileNamelike'%.ceb'and orderbyrow_idselectItemValue,ItemTextfromVIEW_CodeMain_CodeItemsCodeName='wd_25'orderbyorderNo0selectItemValue,ItemText,Bak1fromwhereCodeName='orderbyorderNo0updateFrame_AttachStoragesetCliengGuid=@newCliengGuidSelectTop5*FromWD_25where(LanMuCategoryisnotnullL...orDelFlagisnull)orderbytxtShouWenDatedesc,Row_IDSelectcount(*)FromVIEW_WebInfo_URwhereInfoStatusCode=9and...9:59')and(InfoEndDateisnullorInfoEndDate>='2015-SelectTop1@DBID=B.[dbid],@ObjectID=B.[objectid], SelectTop15*FromMessages_Center_Histroywherean...432-4f64-a5c4-ed0c