FIX: ????? ?????? ?? ??? ????? ??? ???? suspect ??? ????? ???? ????? ??? ???? nonclustered ?? SQL Server 2005

?????? ????????? ?????? ?????????
???? ???????: 934734 - ??? ???????? ???? ????? ????? ??? ???????.
???: # 50001024 (??????? ?????? SQL)
??????
Microsoft ?????? ????????? Microsoft SQL Server 2005 ???? ???? ??????? ???????. ??? ????????? ???????? ????? ?? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2005 ??????? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ??????? ??? ??? ??????? ??? ??????? ??????:
  • ???????? ???? ??? ??????? ?? ???? ???? ????????? ???????
  • ????????? ??????? ?????? ???? ????????? ???????
  • ?? ??? ??? ??? ????? ????? ????????? ??? ????? ???? ????????? ???????
  • ?? ??? ??? ??? ??????? ???? ????????? ??????? ?????? ???? ????????? ??????? ??????
  • ?? ??? ??? ??? ????? ??? ??????? ???????
  • ??????? ??????? ?? ???? ????????? ???????

???????

??? ????? ???? ????? ??? ???? nonclustered ?? ????? ?????? Microsoft SQL Server 2005 ??? ????? ???????? ??? suspect. ???????? ??? ???? ??? ????? ????? ??? ?????? ??? ??? ?? ??? SQL Server 2005 Errorlog:
Date Time SPID ????? ???? SQL: ???: <page.cpp> ? ??? = "??????? ???" 3436 = IsValidSlot (????? ?????? (sid)). ?? ???? ??? ????? ????? ??? ?????. ??? ?????? ????? ??? rerunning ??????? ? ?????? CHECKDB DBCC ?????? ?? ????? ???? ????? ???????? ?? ????? ????? ?????? ?????? ?? ??? ??? ????? ???????? ?? ???????.
Date Time SPID 3624 ???: ???????: ???? 20 ?: 1.
Date Time SPID ??? ???? ??????? ????. ???? ?? ??? ??????? SQL Server ?????? ??? ????????. ???? ???? ???? ???? ??? ??????? ??? ??? ?????? ????? ?? ????????. ?????? ?? ???? ??? ????? ???????? ?? ???? ???????? ????? CHECKDB DBCC. ?? ???? ???????? ????? ????? ?????? ????? ??? Microsoft ????? ???????? ???? ????? ????? ???? ??? Microsoft. ?? ???? ??? ????????? ???????? ?? Microsoft ?? ???? "???? ????" ?? ?? QFE ?? ??? "????? ??????".
Date Time SPID 3314 ???: ???????: ???? 21 ?: 1.
Date Time SPID ??? ??? ????? ??????? ?? ??????? ??????? ?? ????? ???????? 'odstjm' ?? ???? ??? "?????" (82:641734:321). ???? ???? ??? ????? ????? ?????? ?????? ?? ??? ?? ???? "??? ????? Windows. ??????? ????? ?????? ?? ??? ?? ???? ???????? ?? ????? ????? ????????.
???? ??? ??????? ?? ???? ????? ?????? allow_page_locks ???? ????? ??? ???? ????.

????

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

??? ??? ???????? ??? ?????? ??? ???? ??????? ???????? 2 ?? SQL Server 2005 ?????? ????? ?????? SP2 (???? 3175). ?????? ??? ???? ?? ????????? ??? ????? ?????? ??? ??????? ???????? ???? 2 (????? 3175) ? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft":
936305????? ???? ??????? ???????? 2 SQL Server 2005 ?????? ????? ?????? SP2

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

????? ????? ???? ????? ?? Microsoft. ???? ????? ??? ?? ?? ??????? ??????? ?? ??? ???????. ????? ??? ??????? ?????? ??? ??? ??????? ???? ????? ??? ??????? ????????. ?? ??? ????? ???????? ?????? ??? ??? ??????? ??????. ?????? ??? ?? ??? ????? ??? ??????? ??????? ???? ????????? ??? ??????? ?????? ?? ????? ???????? ???? ????? ??? ??? ??????? ??????.

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

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

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

??? ?? ???? ???? SQL Server 2005 ?????? ????? ?????? SP2 ????? ?????? ??? ??????? ??????.

?????? ??? ???? ?? ????????? ??? ????? ?????? ??? SQL Server 2005 ?????? ????? ?????? SP2 ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
913089????? ?????? ??? ???? ???? ???? ?? SQL Server 2005

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

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

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

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

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

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

????? ????? ????? ?????????? ?? ??? ??????? ?????? ???? ????? (?? ???? ????) ??????? ?? ?????? ??????. ??? ??? ???????? ???????? ?????? ???? ??????? ?? "??? ??????? ???????" (UTC). ????? ???? ???? ??????? ?????? ??? ??????? ??? ??????? ??????. ?????? ????? ??? ??????? ??????? (UTC) ???????? ??????? ?????? ????? ??????? ??????? ??????? ?? ???? ??????? ?????? ?? "???? ??????".
SQL Server 2005 32-?? ???????
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Microsoft.sqlserver.maintenanceplantasks.dll9.0.3166.0296,30428 ????? ??????: 53x 86
Msmdlocal.dll9.0.3166.015,943,53628 ????? ??????: 53x 86
Mssqlsystemresource.ldf??? ???? ???????524,288?? ????? ??????: ????? ???? ???????
Mssqlsystemresource.mdf??? ???? ???????40,173,568?? ????? ??????: ????? ???? ???????
Rdistcom.dll2005.90.3166.0644,46428 ????? ??????: 53x 86
Sqlaccess.dll2005.90.3166.0350,57628 ????? ??????: 53x 86
Sqlservr.exe2005.90.3166.029,190,51228 ????? ??????: 53x 86
Sysdbupg.sql??? ???? ???????510,622?? ????? ????10: 04??? ???? ???????
????? SQL Server 2005 x 64-based
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Microsoft.sqlserver.maintenanceplantasks.dll9.0.3166.0296,30428 ????? ??????: 53x 86
Msmdlocal.dll9.0.3166.015,943,53628 ????? ??????: 53x 86
Mssqlsystemresource.ldf??? ???? ???????524,288?? ????? ??????: ????? ???? ???????
Mssqlsystemresource.mdf??? ???? ???????40,173,568?? ????? ??????: ????? ???? ???????
Rdistcom.dll2005.90.3166.0828,27228 ????? ????16: 12x 64
Sqlaccess.dll2005.90.3166.0357,74428 ????? ????16: 12x 86
Sqlservr.exe2005.90.3166.038,509,93628 ????? ????16: 12x 64
Sysdbupg.sql??? ???? ???????510,622?? ????? ????10: 04??? ???? ???????
????? ????? SQL Server 2005 Itanium
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????
Microsoft.sqlserver.maintenanceplantasks.dll9.0.3166.0296,30428 ????? ??????: 53x 86
Msmdlocal.dll9.0.3166.049,887,08828 ????? ????10: 09IA-64
Mssqlsystemresource.ldf??? ???? ???????524,288?? ????? ??????: ????? ???? ???????
Mssqlsystemresource.mdf??? ???? ???????40,173,568?? ????? ??????: ????? ???? ???????
Rdistcom.dll2005.90.3166.01,885,04028 ????? ????10: 09IA-64
Sqlaccess.dll2005.90.3166.0352,11228 ????? ????10: 09x 86
Sqlservr.exe2005.90.3166.072,626,03228 ????? ????10: 09IA-64
Sysdbupg.sql??? ???? ???????510,622?? ????? ????10: 04??? ???? ???????

???? ??????

??????? ?????? ??? ??? ??????? ?? ?????? ?????? allow_page_locks ????? nonclustered.

?????

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

??????? ????

????? ????? ??????? ??????? ?? ????? ?????? ?????? ?? ??? ??? ?? ???? ?? ????? ?? ????? ???????? ??? ???????:
select * from sys.indexes where index_id = 0 and allow_page_locks = 0 
????? ?? ????????? ??? ???? ??????? ???????? SQL Server "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
822499???? ????? ????? ??? ??????? ????? Microsoft SQL Server
????? ?? ????????? ??? ??????? ????? ??????? "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
824684??? ????????? ???????? ????????? ?? ??? ??????? ????? Microsoft

???????

???? ???????: 934734 - ????? ??? ??????: 10/?? ??????/1428 - ??????: 2.4
????? ???
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Standard 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
????? ??????: 
kbmt kbautohotfix kbsql2005engine kbexpertiseadvanced kbfix kbpubtypekc kbqfe kbhotfixserver KB934734 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????934734

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

 

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