?????: ???????? ???? ??? ???????? ???? ??????? ?? ????? ???? ??, ?? ?? ????????? concurrently SQL Server 2008 R2 ??? ??????? ?????? ?? "?? ????-??? ??? ???? latch ?? ??? ????????? ???" ??????

???? ?????? ???? ??????
???? ID: 2545989 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
Microsoft ?? ??? ??? ?? ??????? ????? Microsoft SQL Server 2008 R2 ?????? ?????? ???? ??? ??????? ????? ???? ???, ??????? ??? ?????????? ?? ?? ???? ?? ?? ?? ????? SQL Server 2008 R2 ?? ??? ????? ??? ?? ??? ??????? ???????? ?????? ????
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

?????

?? ???????? ?? ????? ????:
  • ??? ?? SQL Server 2008 R2 ??? ??????? ?? ?????? ?????? ?????? ?? ????? ?????
  • ??? ?? ??????? ???????? ???? ??? ???????? ???? ?? ????? ???? ?? ??? ????????? ?????
  • ?? ?? ????????? concurrently ??????? ?????? ????? ????
?? ???????? ???, SQL Server Errorlog ????? ??? ?????????? ???? ??? ?????? ????? ??? ???? ????

?????? ????? 1
<date> <spid>???? latch ?? ??? - ?????? 2, bp 0000003DDEFCBC80, ????? 3:58642854, stat 0xc0000b, ??????? id ????????? ???? ??? ??? ????-??? ???: 6, ????? ???? Id: 72057594048806912, ????? 0x000000717CC2A748: 0, waittime 300, ???? owning ????? 0x00000062F0A6CE08 0x3a. ????????? ?? ??? ???? ?????</spid></date>

?????? ????? 2
<date> <spid>??????? latch ?? ??? ????????? ?? ??? ?? ???: 'APPEND_ONLY_STORAGE_FIRST_ALLOC', id 0000006196214E30 ???? ???? 4, ????? 0x000000002CA45948: ???? owning ????? 0x00000062F0533288 0x1a, 0, waittime 300,? ????????? ?? ??? ??? ??????</spid></date>

????????

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

SQL ????? 2008 R2

?? ?????? ?? ??? ????? ????? ?????? 8 ??? ???? ?????? ???? ??? ??? ?? ????? ?????? ?????? ?? SQL Server 2008 R2 ?? ??? ??????? ???? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
2534352 SQL Server 2008 R2 ?? ??? ????? ?????? ?????? 8
??? Builds ????? ???? ???, ??????? ??? ?????????? ?? ?? ????? ???? ?? ?? ?? ????? SQL Server 2008 R2 ?? ??? ????? ??? ?? ??? ??????? ???????? ?????? ???? ?? ??????? ???? ??? ?? ?? ?????? ?? ???????? ????? ?????? ????? ???? ???? ?????? ???? ??????? ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
981356 SQL Server 2008 R2 ?? SQL ????? 2008 R2 ?????? ???? ??? ?? ?? ??? ?????? ???? ??? ?? ??

??????

Microsoft ?? ?????? ?? ?? ?? ?? "?? ?? ????" ???? ??? ???????? Microsoft ???????? ??? ?? ?????? ???

???? ???????

?? ????? ????????? ?????? ?? ??? Tempdb ??????? ?? ??? ???? ??????? ?? ?????? ?? ???? ?? ?????? ?? ???? ?? ????? ???? ??????? ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
2154845 SQL Server ??????? tempdb ????? contention ?? ?? ???? ?? ??? ?????????


??????

?????? ???? ??? ???????? ??????-?????? ???? ?? ???? ??? ???? ??????? ?? ???, ????? MSDN ??? ???? ?? ????:
?????? ???? ??? ???????? ??????-?????? ???? ?? ???? ??? ??????? ???????

???? ??????? ?? ??? ????????? ????? ???? SQL ????? ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
935897?? ????????? ????? ???? ?????????? ??????? ?? ?? ???????? ?? ??? ?????? ???? ?? ??? SQL Server ??? ?? ?????? ???? ??
SQL ????? ???????? ?? ??? ?????? ?????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
822499Microsoft SQL ????? ?????????? ?????? ???????? ?? ??? ??? ?????? ??????
?????????? ?????? ?????? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
824684 Microsoft ?????????? ???????? ?? ????? ???? ??? ???????? ???? ???? ???? ?????? ?? ?????

???

???? ID: 2545989 - ????? ???????: 20 ??? 2011 - ??????: 1.0
???? ???? ???? ??:
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Parallel Data Warehouse
??????: 
kbqfe kbfix kbsurveynew kbexpertiseadvanced kbmt KB2545989 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:2545989

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

 

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