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

?????? ????????? ?????? ?????????
???? ???????: 323630 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

????? ????? ????? ????? ?????? ?? ?????? ??????? ??????? (??? ????? ???? ?? ??????) ??? ????? ??????. Microsoft SQL Server ???? ???? ???? ??? ????? ??????? ???????. ??? ????? ??? ?????? ? ???? SQL Server ?? ???? ???? ?????? ??????? ??? ?????? ??? ??? ????? ??? ????????? ???? ?? ??????? ?? ??? ???????? ??????? ?? ??????? ??? ????????? ????????? ?? ?????? ???. ????? ?? ???? ?????? ????????? SQL Server ??????? ????? ???? ???? ??? ??? ??? ?????? ???? ????? ?????? ?? ????? ??? ????? ????? ????? ?????? ????? ??? ????? ???? ??????. ??? ???? ?? ???? ????? ??????? ??? ????????? ?? ????????? ??????? ????? ?? ??? ??? ??????? ????? ? ????? ?????? escalated ?? ???? ?????????? ???????. ?????? ??? ??????? ????? ????? ?? ??? ??? ??????? ????? ???? ??? ?????? ??????? ?? ??????? ????? ??? ????? ????.

??????? ????

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

?? ???? ????? ??????? ????? ??????? ???. ?????? ?? ??? ??? ??????? ????? ???? ??? ????? ????? ????? ?????? ??? ??? ???? ???? ????? ??????? SQL ????? ????? ?????: ?????. ??? ?? ????? ??? ????? ?????: ????? ?? ??? ???? ????? ??????? ??? ?????? ????? ?? ?? ??? ????? ????????? ???????? ?? ??? ??????? ??? ?????? ?? ?????? ???? ??????.

?? ???? ???? ????? ????? ? ???? ?? ??? ????? ?????? escalated ?????????? ???????.

?????? ??? ???? ?? ????????? ??? ????? ????? ??? ???????? ????? ?????? ????? ???? ????? ??????? ????? ??? ???????? ???? ?????? ????? ?????? ?????? (SPID) ? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
224453??? ??? ????? ??? 2000 ?? SQL Server 7.0
?? ???? ??????? ???? ?????????? ??????? ?? ??? ??? ??? ????? (????? ????) TAB ?? ??? ????? S (???????) ?? X (????) ? ??????? ????? ??? ???????. ???? ???? ?? ???? ????? TAB ????? ??? (??? ??? ????? IS ?? IU IX) ? ??? ??? ?? ????? ????? ???????. ??? ??? ?? ????? ??? ??? ???? ????? ????? ? ???? ?????? Q224453 ?????? ??? ????? ???????? ??????? ????????.

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

?? ????? ???? ? ?????? ????? ???? ????? ??????? ???????? ????????? ????? ?????? ??? ????? ????????? ????? ???? ?? ??? ????? ????? ??????? ???????. ???? ??? ??? ?????? ??? ??? ????? ?????? ?? ??? ??? ???:
  • ??? ?? ?????? ????? ??????? ??? ??? ?????? ????. ??? ???? ??????? ????? ?? ??? ?????? ????????? ?????? ?????? ??????? ??????? ??? ???? ?????? ?? ???? ????? ??? ?? ?? ?????? ???? ?? ??? ???? ????? ????? ??? ???????? ?????:
    DELETE FROM LogMessages WHERE LogDate < '2/1/2002'						
    ??? ????? ??? ??????? ??? hundred ?? ??? ? ????? ???? ???? ????? ??? ????????? ???? ?????? ??? ?????? ???? ??????? ???????. ??? ???? ??????: delete_more
    SET ROWCOUNT 500
    delete_more:
         DELETE FROM LogMessages WHERE LogDate < '2/1/2002'
    IF @@ROWCOUNT > 0 GOTO delete_more
    SET ROWCOUNT 0
  • ????? ??? ????? ????????? ?? ???? ????? ????????? ??????? ??? ?? ????. ?????? ?????? ???? ?? ??? ???? ?? ??????? Bookmark ?? ???? ??? ????? ???? ??????? ?????; ???????? ??? ???? ???? ??? ????? ???? deadlocks ????? ???? ??? ???? ??????? ???????. ??? ?????? ??? ????????? ???? ???? ????? ????? ? seeks ???? ?? ??? ????? ??????? ??????? ?? ?????? ????? ??? ???? ????? ?????? ?????? ?????? ?????? ?? ?????? ?? ?????? ??????? ??????. ?? ???? ???????? ??? ????????? ?? ???? ??????? "???? ???????" ?????? ????? ???? ?????? ????. ?????? ????? ?? ??????? ??????? ???? ??? ????? ??? ?????? ?? SQL Server 2000 ?? ???? ??? ????? ????? ?????? ?? SQL Server 7.0.

    ??? ???? ????? ?????? ??? ?? ???? ???? seeks ?????? ???? ??? ??? ???? ?????? ????? ??????? Bookmark (????? selectivity ?????? ?? ??? ??????? ????). ??? ????? SQL Server ?? ????? ???? ?????? (???? ????? ????? ??? Bookmark) ?????? ???? ?????, ???? ?? ?????? ??????? ?????? ?????? ????? ??????? ????????. ??? ??????? SQL Server ??????? ?????? ??? ??????? ??????, ??? ????? ????? ??? ???????? ?? ??? ?? ????????? repeatable ????? ??? ?? ?????????. ???? ???? ?? ?? ?? ?????? ????? SELECT ????? ??? ???????? ??????? ?? ?????? ??? ?????? ?? ???? ????? ????? (?? ?? ???? ?????? ???????? ???? nonclustered ????) ? ???? ???? ?? ???? ??????? ????? ????? ??????? ?????. ??? ??? ???? ??? ??? ???? ?? ????? escalated ????? ???? ?????? ???? ??? ????? ?? ???? ??? ??? ???? ?????? ????? ????? ???????? ??????? ?????????. ??? ???? ????? "??????? Bookmark ??? WITH ??????" ?? ??????? ? ???? ???????? ????? ????? ?????? ??? ???? nonclustered ???? ???? ?? ?????? ?? "????? ??" ?? ?????? ??????? "?????? ??????" ????? ???? ??????? ??????? "??? ????? ??????" ?? ??? ?????????. ?? ?????? ????? ???? covering (???? ????? ???? ??????? ?? ???? ????????? ?? ?????????) ?? ????? ???? ???? ???? ??????? ???? ?? ????????? ?????? ???? ?? ?? ???? WHERE ??? ??? ?? ??? ?? ?? ?? ??????? ????? ????? ??????.

    ???? ????? ??????? ??? "???????? ????" ??????? ?????? ? ???? ??? ?????? ???????.

    ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
    260652??? ???? ????????? ?????? "LOOKUP ??????? ????????.. .WITH ??????? ??????" ?? ???? ????? ????
  • ?? ???? ??????? ????? ?????? ????? SPID ?????? ??? ????? ???? ??? ???????. escalates ??????? ????? ??? ????? ???? ???? ??? ????? ??????. ???????? ??? ???? ?? ???? ??? ?????? ????? ????? ??? SPID ??? ????? ??? ????? TAB ??? ?????? ????????? ???? ???? ??????? ?? ???? ????? ?????? ????? TAB. ????? ?? ???? ????? ?? ?????? ??? ????? ????? ?? ??????, ?????? ???? (???? ?? ????? ?? ??????) ? ???? ????? ??????? ?????? ???? ????. ????? ????? ???? ???? ??????? ????? ??? ???? ???? ?? ?????? ??? ???????? ????? ??? ????? ??? ??? ?????? ?? ??? ????? escalated. ?? ????? ????? IX (??? ???) ????? ?????? ??? ???? ?? ????? ???? ??? ?? ???? ??? ?????? ?? S escalated (???????) ?? X ????? TAB (???). ??? ???? ??????? ????? ??? ??? ????? ???? ???? ?????? ??? ???? ?? ?????? ?? ???? mytable ? ???? ???? ??? ???? ???? ???? ????? ???????. ?? ???? ?????? ??? ?????? ????? ?? ??? ?? ???? ???? ?? ?????? ???? SQL ???????? ???? ????? ??? ???????? ???????? ??????? ?? ????? ???? ????? ???? ??? ????? ??? ??? ????? ???? ??????:
    BEGIN TRAN
    SELECT * FROM mytable (UPDLOCK, HOLDLOCK) WHERE 1=0
    WAITFOR DELAY '1:00:00'
    COMMIT TRAN				
    ??? ????????? ????? ? ????? ??? ????? IX ??? mytable ???? ???? ????? ??? ???? ????? ??????? ??? ?????? ????? ??? ?????. ?? ???? ??? ?????? ??? ????? ?? ?????? ?? ??? ?????? ??????????? (??? ??? ??? ????????? ?????? ????? ???? ?? ????? TABLOCK ?? ??? ??? ????? ?????? ????? ?????? ?? ?? ???????? sp_indexoption ??????? ??????).
???????? ??? ???? ????? ????? ??????? ??????? ?????? ???? ??????? 1211. ??? ???? ????? ??? ??????? ???? ???? ??????? ????? ???? ????? ?? ???? SQL Server. ???? ??????? ????? ??? ????? ???? ?? SQL Server ?????? ????? ??????? ????????? ???? ??? ????? ?????? ????? ????? ?????? ? ????? ?????? ?????? ?? ?????? ???????. ????? ??????? ????? ????? ?????? ??????? ???????? ??????? ???? ?????? ???????. ??????? ???? ???? ????? ???? SQL ???? ???? ????? ????? ????, ??? ??? ??? ?????? ??????? ????? ???????? ????? ????? ??? ???? ??? ??? ??????? ?? ???? ??????? ?????? ????? ?????? ?? ?? ??????? ? ???? ????? ??????:

1204 ???: ???????: ???? 19 ?: 1
?? ???? ?????? ??? SQL Server ???? LOCK ?? ??? ?????. ??? ????? ??????? ?????? ?? ??? ???? ??? ??? ?? ?????????? ?????? ?? ???? ?? ????? ?????? ?????? ?? ????? SQL Server ????? ????????.
?????? ??? ???? ??? "1204" ????? ?????? ??????? ??????? ????? ????????? ?? ????????? ??????. ????????? ????? ?? ??? ?????????? ?? ???? ??? ??? ??????? ????? ?????? ????? ??? ???? ????? ???? SQL Server.

??????? ????? ????? ??? ROWLOCK ??? ????? ??? ????? ?????? ???. ?? ???? ??????? ????? ??????? ???????.

????? ?????? ?? ??? ??????? ????? ???? ??? ???????? ?? ??? ??????? ?? ???? ???????? ?? ????? ??????? ??????. ???????? ??? ???? ?????? ???? ???? ??? ???? ???? ???? ????????? ?? ????? ??????? ????? ?????? ???????. ???? Microsoft ????? ??? ??????? ?????? ?????? ??? ??????? ???? ???? ???? ????? ????? ????? ???????? ?????? ??? ??? discussed ?????? ?? ??? ??????? ??? ???? ??????. ?????? ????? ???? ???? ??? ?????? ????? SQL Server ????? ? ?????? ??? ??? ????? ??? ????? ????.

?????? ????? ??? ????? ???? ???? ??? ?????? ?????? ??? ?????? ?? SQL Enterprise Manager ? ???? ??? ????? ? ?? ?? ??????? ???? ???? ??? ?????? ??? ??????? ?? ?? ?????? ??????? ??????? (?????? ??? ?? ????):
-T1211
??? ?? ?????? ???? SQL Server ??????? ??? ????? ????? ????? ???????. ?? ???? ????? ????????? ?????? ?? "??????? ????" ????? ???? ???? ??????? ?????:
DBCC TRACEON (1211, -1)				
????, ??? ?? ??? ?????? -T1211 ??????? ??? ??????? ????? ????? traceon ??? ????? ??? cycled ???? SQL Server. ????? ????? ???? ???? ?? escalations ????? ?????????? ???? ?? ????? ?? escalations ????? ???? ???? ?????? ?? ???? ??????? ????.

???????

???? ???????: 323630 - ????? ??? ??????: 04/???/1428 - ??????: 10.3
????? ???
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Workgroup Edition
????? ??????: 
kbmt kbinfo KB323630 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????323630

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

 

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