?????: ???????? SQL Server 2008 R2 ???? ?? "???-yielding ????????" ?????? ??? ??

???? ?????? ???? ??????
???? ID: 2699013
Microsoft Microsoft SQL Server 2008 R2 ?????? ??? 1 (SP1) ?????? ???? ?? ?? ?? ????? ????? ?? ??? ??? Microsoft SQL Server 2008 R2 ??? ???? ??? ???????? ????? ???? ???, ??????? ??? ?????????? ?? ?? ???? ?? ?? ?? ????? SQL Server 2008 R2 ?????? ??? (SP1) ?? Microsoft SQL Server 2008 R2 ?? ??? ????? ??? ?? ??? ??????? ???????? ?????? ????
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

?????

?? Microsoft SQL Server 2008 R2 ?? ????? ???? ???, ?? ?? "???-yielding ????????" ?????? ??????? ?? ???? ??, ?? SQL ????? ??????????? ???? ??? ?? ???? ??? ?? ?? ?????? ???? ??, ?? ?? ?? ????? ?????????? ?????? ????? ????????? ??? ??? ??? ????

?????? ????? 1

?????? ???MSSQLSERVER ??????? ????? 846 ???? ???? PM ServerName ???? latch ?? ??? - ?????? 4, bp 0000000098FC1F00, ????? 1:7158252, stat 0xc00009, ??????? id ????????? ???? ??? ??? ????-??? ???: 13, ????? ???? Id: 72057594050969600, ????? 0x0000000005C31948: 0, waittime 300, ???? owning ????? 0x0000000000000000 0x1018. ????????? ???? ?? ??? ???? ?????

?????? ????? 2

?????? ???MSSQLSERVER ??????? ????? 17883 ???? ???? ???ServerName ????????? 0: 0: 0 (0xb6c) ????? 0x0000000008F641A0 ???-???????? 1 ?? yielding ???? ?? ??? ????? ???? ??? ??????? ??? ?????: 12971505305687? Approx ????? CPU Used: ?????? 31 ms ?????????? 38240375 ms. ????????? ????? 7%? ?????? ????????? 92%? ??????: 38243440 ms.


??? ??, ?? ?? ????? ????? ?????? ??????? ??? ?? SQL ????? ?????? ??? ??? ??? ????

?????? ????? 3

?????? ??? ????? ??????? 'dbghelp.dll' '4.0.5' ?? ?????
?????? ??? ????? *** ????? ?????? spid 0 ?? ??? ??????? ???? ??? ??????
?????? ??? Server * *******************************************************************************
?????? ??? ????? *
?????? ??? ????? * ???? ????? ???:
?????? ??? ????? * ?????? ??? spid ID
?????? ??? ????? *
?????? ??? ????? * ???-yielding ????????
?????? ??? ????? *
?????? ??? Server * *******************************************************************************
?????? ??? ????? ??? ?? ??? ????? ????????? 0x0000000000000069 ??
?????? ??? ????? ???? ????????? ????? ??? 0x20000001 ???? ??????
????? ???? ????????? ??? ????????? ???? ???? ?????

?????? ????? 4

?????? ??? ????? ????????? 0: 0: 0 (0xb6c) ????? 0x0000000008F641A0 ???-???????? 1 ?? yielding ???? ?? ??? ????? ???? ??? ??????? ??? ?????: 12971505305687? Approx ????? CPU Used: ?????? 0 ms ?????????? 70062 ms. ????????? ????? 30%? ?????? ????????? 69%? ??????: 70078 ms.

???? ????????, ?? mini-dump ????? ????????? ??? ??? ???? ???? ??? ?? ?????? ?? ???????????? ???? ?? ???, ???? SQL ?????? ???????? ???? ??? ???? ???

????

?? ?????? ????? ???? ?? ??????? profiling ???? ??? ?? ??? ???? ??? Profiling ???? ????? ???? ?? ???? ?? ???, ???? ???????? ?? ???? ?? ???? ???? ?? ??? ????? ???? ???? ??, ?? ?????? ????? ?? CPU ????? ?? ?????? ???

????????

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

SQL ????? 2008 R2 SP1

?? ?????? ?? ??? ????? ????? ?????? 7 ??? ???? ?????? ???? ??? ??? SQL Server 2008 R2 ?????? ??? 1 ?? ??? ????? ?????? ????? ??????? ???? ?? ??? ???? ???? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
2703282 SQL Server 2008 R2 SP1 ?? ??? ????? ?????? ?????? 7
??? Builds ????? ???? ???, ??????? ??? ?????????? ?? ?? ????? ???? ?? ?? ?? ????? SQL ????? 2008 R2 ?????? ??? 1 ?? ??? ????? ??? ?? ??? ??????? ???????? ?????? ???? ?? ???? ???? ?????? ?? ???????? ????? ?????? ????? ?????? ????? ?? ????? ??? ???? ??????? ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
2567616 SQL Server 2008 R2 ?? ?????? ??? ?? SQL Server 2008 R2 SP1 ?? ?????? ???? ??? ?? ?? ??? ??

SQL ????? 2008 R2

?? ?????? ?? ??? ????? ???? ????? ?????? 14 ??? SQL Server 2008 R2 ?? ??? ???? ???? ??? ??? ?? ????? ?????? ?????? ?? SQL ????? ?? ??? ??????? ???? ?? ???? ??? ???? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
2703280 SQL Server 2008 R2 ?? ??? ????? ?????? ?????? 14
??? Builds ????? ???? ???, ??????? ??? ?????????? ?? ?? ????? ???? ?? ?? ?? ????? SQL ????? ?? ??? ????? ??? ?? ??? ??????? ???????? ?????? ???? ?? ???? ???? ?????? ?? ???????? ????? ?????? ????? ?????? ????? ?? ????? ??? ???? ??????? ?? ???, Microsoft ???????? ??? ???? ????? ?? ??? ?????????? ???? ?????? ????? ????:
981356 SQL Server 2008 R2 ?? ?????? ??? ?? SQL Server 2008 R2 ?????? ???? ??? ?? ?? ??? ??

??????

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

???

???? ID: 2699013 - ????? ???????: 18 ??? 2012 - ??????: 1.0
??????: 
kbqfe kbfix kbsurveynew kbexpertiseadvanced kbmt KB2699013 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:2699013

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

 

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