FIX: ?? ?? ?? NOLOCK ????? ?? ??? ?? ???? ?????? ??? SQL ????? ??? ??? ?????? ?? ??????? ????? ??? Nonclustered ??????????? ????? ?? ???? ??

???? ?????? ???? ??????
???? ID: 2878968 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
??? ?? ??????? ???? | ??? ?? ??????? ????

?? ????? ??

?????

?? ?? ???? ?????? ??? Microsoft SQL Server 2008, SQL Server 2012, SQL Server 2008 R2 ?? SQL Server 2014 ?? ??????? NOLOCK ????? ?? ??? ?? ???? ?????? ??? ????? ???, nonclustered ??????????? ????? ?? ???? ??? ??? ??, SQL ????? ?????? ??? ??? ????? ?????? ????? ??? ?? ???? ???:

??????>???> spid # ??????: 8646, ???????: 21, ??????: 1?
??????>???> spid # ID 3, 2102402659, ??????? ??? ?????? ?? ??????????? ??? ??????????? ????????? ?????? ??? ?????? 'DatabaseName>'? ????? ?? ?? ??????????? ????? ?? ?? ??????? ?????? ????? ?? ??? ?? ?????? ??? ????? DBCC CHECKDB ?? DBCC CHECKTABLE. ??? ?????? ??? ???? ??, ?? ?????? ?????? ?? ?????? ?????
??????>???> spid # ?? ????? ???? 'dbghelp.dll' ??????? '4.0.5'
??????>???> spid # * * ????? - spid ??? = 0, EC = 0x0000000BD70624C0
??????>???> spid # *** ????? ???? ???? Y:\MSSQL\MSSQL10 ???? ?? ??? ???? ?? ??? ???MSSQLSERVER\MSSQL\LOG\SQLDump0003.txt
Date>Time> spid # * *******************************************************************************
??????>???> spid # *
??????>???> spid # * ???? ????? ???? ????:
??????>???> spid # * ??????>???> spid #
??????>???> spid # *
??????>???> spid # * CPerIndexMetaQS::ErrorAbort - ??????????? ????
??????>???> spid # *

???
???? ????? ?????? ??? ?? ??? ?? ??? NOLOCK ????? ???? ?? ???? ???? ???????, ?? ?? NOLOCK ????? ?????? ?????? ??? ???? ??? ?? ??? ???? ???? ?? ?????

????

?? ?????? ???? ?? ??????? ?????? ?????? ?? ?? ???? ??? ?? ??? ????? ??, ?? ??? ?????? ??? ???? ??? ?? ????? ?? ??? NOLOCK ????? ???? ???

????????

?????? ???? ???? SQL Server ?? ????? ????? ?????? ??? ??? ???? ??? ???

2014 SQL ????? ?? ??? ????? ?????? 1

SQL Server 2012 ?? ??? ????? ?????? 11

SQL Server 2012 SP1 ?? ??? ????? ?????? 7

SQL Server 2008 SP3 ?? ??? ????? ?????? 13

SQL Server 2008 R2 SP2 ?? ??? ????? ?????? 9

SQL ????? ?? ??? ????? ?????? ?? ???? ???

?? ??? ?? ??????? ?????? ??? ?? ??????? ????
assets folding start collapsed
???????? ??? ????? ?????? SQL ????? ?? ??? ??? ?????????? ?? ?? ??? ??????? ?? ?? ???? ????? ????? ?????? ?? ??? ????? ??? SQL ????? ?? ??? ?????? ????? ?????? ?? ???? ????:
?? ??? ?? ??????? ?????? ??? ?? ??????? ????
assets folding end collapsed

??????

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

???

???? ID: 2878968 - ????? ???????: 22 ?????? 2014 - ??????: 5.0
???? ???? ???? ??:
  • Microsoft SQL Server 2008 Service Pack 3, ?? ???? ??? ?????? ???? ???:
    • Microsoft SQL Server 2008 Enterprise
    • Microsoft SQL Server 2008 Developer
    • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 R2 Datacenter
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Web
  • Microsoft SQL Server 2008 R2 Workgroup
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Web
  • Microsoft SQL Server 2014 Developer
  • Microsoft SQL Server 2014 Enterprise
  • Microsoft SQL Server 2014 Standard
??????: 
kbqfe kbfix kbsurveynew kbexpertiseadvanced kbmt KB2878968 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:2878968

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

 

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