FIX: ?? BizTalk ????? 2006 ?? ???????? ???????? ?? ????? ?? ????????? ????? ???????? ??? ????? ??? ??? ?? ???

???? ?????? ???? ??????
???? ID: 936536 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

?????

?? ???? ????? ???????? ???????? BizTalk ????? 2006 ?? ????? ????? ?????? ?? ???, ???? ?? ????-?? (SSO) ????-??? ?????? ????? ??????? ???? ??? ??? ??, BizTalk 2006 ?????????? ????? ?? ????? ????? ???????? ?? ??? ??? ??? ?? ???? ????????? ???? ?? ??? ?? ????? SQL ??? ?? ?????<biztalkhostname></biztalkhostname>Q_Suspended ??????, ?? ??? ?? ?????? ??? ?? ?????????:
Select count (*) from <BizTalkHostName>Q_Suspended
???: <biztalkhostname></biztalkhostname>is a placeholder for a customer host name.

Additionally, some throttling messages for the database size are logged in the performance log file.

????

This issue occurs because zombie messages are created for the cache service instance. Thebts_UpdateMsgbox_BizTalkHostNamestored procedure calls theInsertstatement to move these zombie messages into the suspended queue. Then, the slow execution time of the stored procedure blocks many other BizTalk Server-related SQL scripts.

Based on the BizTalk Server 2006 mechanism, the large suspended messages for the cache service instances in the database create a throttling problem. ?? ?????? ?? ???? ??, ?? ???????? ??????????? ??? ??????? ??? ?? ??????? ???? ?? ??? ????????? ?? ???? ???

???:???????, ?????? ???????????? ???? ??????? ?? BizTalk MMC ??? ?? ?????? ????? ??? ?????

????????

???????? ???????

?? Microsoft ?? ?? ??????? ???????? ?????? ??.. ??? ?? ???????, ???? ?????? ?? ?????? ?? ?? ???? ??? ????? ???? ??? ??? ???? ????? ???????? ?? ???? ???? ?? ?? ??????? ?????? ?? ????? ?? ??? ???.. ?? ???????? ?? ??? ???????? ??????? ??? ?? ???? ???.. ?????, ??? ?? ?? ?????? ?? ???? ??? ???????? ???? ???, ?? ?? ????? ????? ?? ?? ???? BizTalk ????? 2006 ?????? ?? ???????? ????? ???? ?? ??? ????????? ???

?? ?????? ?? ????? ?? ????, ?? ???????? ??????? ???? ?? ??? Microsoft ?????? ?????? ???? ?? ?????? ????? Microsoft ?????? ?????? ???? ?? ??? ?????? ?? ?????? ????? ?? ???? ??? ??????? ?? ???? ????, ?? ??? ????? Microsoft ??? ???? ?? ????:
http://support.microsoft.com/contactus/?ws=support
???:????? ?????? ???, ?? ????? ?? ?????????? ?????? ???????? ?? ???? ???? ??? ???? ??? ?? ???? ???, ??? ??? Microsoft ?????? ????????? ????????? ???? ?? ?? ??? ??????? ?????? ???? ?????? ?? ?????? ?? ???? ??.. ???????? ?????? ???????? ?? ?? ???????? ?? ??? ??????? ?????? ????? ???? ????? ?? ?? ??????? ?????? ?? ??????? ???? ????..

??????????????

????? 2006 BizTalk ?? ???????? ?? ???? ???? ?? ??? ??????? ???? ?????? ???

???? ??????? ????????

?? ???????? ?? ???? ???? ?? ??? ???? ????? ??? ?? ???????? ???? ?????? ??:
  • SQL ????? ?? ??????? ??? BizTalk ????? 2006 ??? ??????
  • ??? BizTalk ????? ?????????? BizTalk ????? 2006 ????
  • ??????? ?????????? ???????? (IIS) ?????

????????? ???????????? ???????

?? ???????? ???? ?? ???????? ?? ???????????? ???? ????..

????? ???????

?? ????????? ?? ????????? ??????? ??? ?? ????? ????????? (?? ??? ?? ????? ?????????) ??? ?? ????? ?????? ??? ???????? ???.. ?? ??????? ?? ??? ?????? ?? ???, ??????? ????????? ??? (UTC) ??? ???????? ??.. ?? ?? ????? ??????? ????? ???, ?? ?? ??????? ??? ??? ?????? ???? ???? ??.. "UTC ?? ??????? ??? ??? ???? ????? ?? ???, ???????? ??? ??? ""?????? ?? ??? ???"" ??? """"??? ???????"" "??? ????????? ?? ??????? ??? ???????? ?????
?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????
????? ???????? ?? ???????????? ?????????????:??????????
2453.SQL???? ????23208-??-200713: 37???? ????
Biztalkcustomactiondata.XML???? ????79008-??-200713: 47???? ????
Msgbox_application_logic.SQL???? ????505,56208-??-200721: 39???? ????
Msgboxschema.SQL???? ????97,63808-??-200721: 39???? ????
???????? ?? ??????? ???? ?? ??? 2453.sql ????????? ?? Msgbox_application_logic.sql ????????? zombie ????? ????? ??? ???? ???????? ?? ????

??????

Microsoft ?? ?????? ?? ?? ?? ?? ?? Microsoft ???????? ??? ?? ?????? ?? ?? "???? ???? ???? ???" ?????? ???????? ???..

???

???? ID: 936536 - ????? ???????: 10 ??????? 2010 - ??????: 1.0
???? ???? ???? ??:
  • Microsoft BizTalk Server 2006 Developer Edition
  • Microsoft BizTalk Server 2006 Enterprise Edition
  • Microsoft BizTalk Server 2006 Standard Edition
??????: 
kbbtsmessaging kbbiztalk2006presp1fix kbexpertiseinter kbhotfixserver kbqfe kbmt KB936536 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:936536

??????????? ???

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com