FIX: ?? ????? ???? latency ??????? ?? ??? Microsoft SQL Server 2005, Microsoft SQL Server 2008 ?? Microsoft SQL Server 2008 R2 ????-??-???? ????? ?? ???

???? ID: 980849 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
???? ?????? ???????????? ?????? ???????? KB ?? ???????? ????? ?? ??? ???? ????? ????
Microsoft Microsoft SQL Server 2005, Microsoft SQL Server 2008, ?????? ???? ?? ?? ?? downloadable ???? ?? ??? ??? Microsoft SQL Server 2008 R2 ?? ???? ??? ??????? ????? ???? ???, ??????? ?? ?? ?????? ??? ??? ?????????? ?? ?? ??? ??????? ??????? ????? Microsoft SQL Server 2005, Microsoft SQL Server 2008 ?? Microsoft SQL Server 2008 R2 ?? ??? ????? ?? ?? ??? ???? ???
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

?????

?? ???????? ?? ????? ????.:
  • Microsoft SQL Server 2005, Microsoft SQL Server 2008 ?? Microsoft SQL Server 2008 R2, ??? ?? ???????? ???? ????-??-???? transactional ????????? ?? ?? ???? ??????? ??? ?????? ????????? ??? ????? ????
  • ?? ??? ???????? ?? ?? ????????? ??? ????????? ?? ???? ???????? ?????
In this scenario, the latency is high for all the peer-to-peer distribution agents.
????? ?? ???? ???? | ??????????? ???

????

A lock is obtained in thesys.sp_MSgetpeerlsnsstored procedure. This stored procedure explicitly requests an exclusive ROWLOCK table hint on a table. Although a row lock is requested, all the other distribution agents are still blocked because they are requesting the same keylock ID.

???:Thesp_lockstored procedure can be used to show that all agents are waiting for the same keylock.
????? ?? ???? ???? | ??????????? ???

????????

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

SQL ????? 2005

?? ?????? ?? ????? SQL Server 2005 ?????? ??? 3 ?? ??? ????? ?????? 9 ??? ???? ?????? ???? ??? ??? ?? ????? ?????? ?????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
980176
(http://support.microsoft.com/kb/980176/LN/ )
SQL ????? 2005 ?????? ??? 3 ?? ??? ????? ?????? ?????? 9
???:Builds ????? ???? ???, ??????? ?? ?? ????? ?????? ??? ??? ?????????? ?? ?? ??? ??????? ??????? ????? SQL Server 2005 ?? ??? ????? ?? ?? ??? ???? ??? ?? ??????? ???? ??? ?? ?? ????? ?????? ????? ?????? ?????? ?? ???????? ?? ???? ???? ?? ??? ??? ???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
960598
(http://support.microsoft.com/kb/960598/LN/ )
SQL ????? 2005 SQL Server 2005 ?????? ??? 3 ?? ?????? ???? ??? ?? ?? ??? ?????? ??? ?? ?? ????? ??
Microsoft SQL Server 2005 ?????????? ??????? SQL Server ?????? ??? ?? ??? ???? ???? ???? ?? SQL Server 2005 ?????? ??? 3 ?? ??????? ???? ?? ??? ??? SQL Server 2005 ?????? ??? 3 ???????? ?? ???? ???? ?????? ??? ???????? ??? ??, ???? ?? ???????? ???? SQL Server ?????? ??? ??? ?????? ???? ???? ?? ?? ???? SQL Server ?????? ??? ??? ????? ???

SQL Server 2008 ?????? ??? 1

?? ?????? ?? ????? SQL Server 2008 ?????? ??? 1 ?? ??? ????? ?????? 9 ??? ???? ?????? ???? ??? ??? ?? ????? ?????? ?????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
2083921
(http://support.microsoft.com/kb/2083921/LN/ )
SQL Server 2008 ?????? ??? 1 ?? ??? ????? ?????? 9
???:Builds ????? ???? ???, ??????? ?? ?? ????? ?????? ??? ??? ?????????? ?? ?? ??? ??????? ??????? ????? SQL Server 2008 ?? ??? ????? ?? ?? ??? ???? ??? Microsoft ??????? ???? ?? ?? ?? ????? ?????? ????? ?????? ?????? ?? ???????? ?? ???? ???? ?? ??? ??? ???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
970365
(http://support.microsoft.com/kb/970365/LN/ )
SQL Server 2008 SQL Server 2008 ?????? ??? 1 ?? ?????? ???? ??? ?? ?? ??? ?????? ??? ?? ?? ????? ??
Microsoft SQL Server 2008 ?????????? ??????? SQL Server ?????? ??? ?? ??? ???? ???? ???? ?? SQL Server 2008 ?????? ??? 1 ?? ??????? ???? ?? ??? ??? SQL Server 2008 ?????? ??? 1 ???????? ?? ???? ???? ?????? ??? ???????? ??? ??, ???? ?? ???????? ???? SQL Server ?????? ??? ??? ?????? ???? ???? ?? ?? ???? SQL Server ?????? ??? ??? ????? ???

SQL Server 2008 ?????? ??? 2

?? ?????? ?? ????? ???? ?????? ???? ??? ?? ????? ?????? 1 ??? SQL Server 2008 ?????? ??? 2 ?? ???? ?? ????? ?????? ?????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
2289254
(http://support.microsoft.com/kb/2289254/ )
SQL Server 2008 ?????? ??? 2 ?? ??? ????? ?????? 1
???:Builds ????? ???? ???, ??????? ?? ?? ????? ?????? ??? ??? ?????????? ?? ?? ??? ??????? ??????? ????? SQL Server 2008 ?? ??? ????? ?? ?? ??? ???? ??? ?? ??????? ???? ??? ?? ?? ????? ?????? ????? ?????? ?????? ?? ???????? ?? ???? ???? ?? ??? ??? ???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
2402659
(http://support.microsoft.com/kb/2402659]/ )
SQL Server 2008 SQL Server 2008 ?????? ??? 2 ?? ?????? ???? ??? ?? ?? ??? ?????? ??? ?? ?? ????? ??

SQL Server 2008 R2

?? ?????? ?? ????? ????? ?????? 4 ??? ???? ?????? ???? ??? ??? SQL Server 2008 R2 ?? ??? ?? ????? ?????? ?????? ?? ??????? ???? ?? ??? ???? ???? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
2345451
(http://support.microsoft.com/kb/2345451/ )
????? ?????? ?????? 4 SQL Server 2008 R2 ?? ???
???:Builds ????? ???? ???, ??????? ?? ?? ????? ?????? ??? ??? ?????????? ?? ?? ??? ??????? ??????? ????? SQL Server 2008 R2 ?? ??? ????? ?? ?? ??? ???? ??? ?? ??????? ???? ??? ?? ?? ????? ?????? ????? ?????? ?????? ?? ???????? ?? ???? ???? ?? ??? ??? ???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
981356
(http://support.microsoft.com/kb/981356/ )
SQL Server 2008 R2 SQL Server 2008 R2 ?????? ???? ?? ??? ?????? ??? ?? ?? ????? ??
????? ?? ???? ???? | ??????????? ???

??????

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

??????

For more information about Peer-to-Peer transactional replication, please visit the following Microsoft Web site:
Peer-to-Peer transactional replication
(http://msdn.microsoft.com/en-us/library/ms151196(sql.90).aspx)
??????? ?? ??? ????????? Servicing ???? SQL ????? ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
935897
(http://support.microsoft.com/kb/935897/ )
?? ????????? Servicing ???? ?? SQL Server ??? ?? ??????? ?? ?? ???????? ?? ??? ?? ???????? ?? ?????? ???? ?? ??? ?????? ??
SQL ????? 2005 ?????? ??? 3 ?? ??????? ???? ?? ??? ???? ???? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
913089
(http://support.microsoft.com/kb/913089/ )
SQL ????? 2005 ?? ??? ?????? ?????? ??? ?? ??????? ???? ?? ??? ???? ????
?? ???????? ?? SQL Server 2005 ?????? ??? 3 ??? ????? ?? ???? ??? ???? ??????? ?? ??? ????? Microsoft ??? ???? ?? ????:
HTTP://go.Microsoft.com/fwlink/?LinkId=131442
(http://go.microsoft.com/fwlink/?LinkId=131442)
SQL ????? ?????? ?? ??? ?????? ?????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
822499
(http://support.microsoft.com/kb/822499/ )
Microsoft SQL Server ?????????? ?????? ???????? ?? ??? ??? ?????? ??????
?????????? ?????? ???????? ?? ???? ??? ???? ??????? ?? ???, Microsoft ?????? ??? ??? ???? ????? ?? ??? ????? ???? ?????? ????? ????::
824684
(http://support.microsoft.com/kb/824684/ )
Microsoft ?????????? ???????? ?? ????? ???? ?? ??? ????? ?? ???? ???? ???? ???????? ?? ?????
????? ?? ???? ???? | ??????????? ???

???

???? ID: 980849 - ????? ???????: 15 ?????? 2010 - ??????: 4.0
???? ???? ???? ??:
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Workgroup
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Workgroup
??????: 
kbexpertiseadvanced kbsurveynew kbfix kbqfe kbmt KB980849 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:980849
(http://support.microsoft.com/kb/980849/en-us/ )
????? ?? ???? ???? | ??????????? ???

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

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