新区阶段性报告附8oa数据库分析

苏州新区管委会SQL 时间：2015年12月本文件中出现的任何文字叙述、文档格式、插图、、方法、 均属苏州恒建有限，受到有关及 建的或 数据库SQLServer:45ms3I/O 数据库Attach2012不可 内存不够，bufferpages有时只有12%可用。 12月17日上午7:59分产生表锁 数据库的Job在12月14、15、16号均执行失败 超长的job时间，10selectMailGuidfrom OwnerUserGuid='2120eaa7-7cf2-49be8053-29e77da88ae5'anddeleteFlag=0andandhaveread=0andNoNeedRemind=0orderby Row_IDdesc每次执行等待时间需要99.55s，而执行次数又比较多（36,573.00类的问题，建议尽量绑定变量，使用过程。列表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