FIX: Deadlocks ?? ???? ??? ????? ???? ?????? ???? ?????? ??? ????? ????? ??????? ??? ????? ?? SQL Server 2008

?????? ????????? ?????? ?????????
???? ???????: 978250 - ??? ???????? ???? ????? ????? ??? ???????.
???? Microsoft SQL Server 2008 ????????? ???? ???? ???? ???????. ??? ????????? ???????? ????? ?? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2008 ??????? ???????.
????? ???? | ?? ????

???????

???? ??? ????????? ??????:
  • ?? Microsoft SQL Server 2008 ????? ???? ?????? ???? ??????.
  • ????? ?????? ?????? ALTER INDEX ?????? ???? ????? ??? ???? ??? ??? ??????? ??? ????? ??????. ????? ????? ??????? ??? ?????? ?????? ALTER INDEX ???? ?????? ONLINE ????? OFF.
  • ????? ?? ?? ??? ??????? ??????? ??????? ?? ???? ?? ??????? ??????.
?? ??? ?????????? ?? ???? deadlocks ??? ?????? ??????? ???? ???? ?????? ??????. ???????? ??? ???? ??? ????? ????? ????? ??????? ?? ??? ??? ??????? SQL Server 2008:
???? ???? ??? ??????.... ????? ??????? ???? ???? ???
???????? - ??????? ??? ????? ???????
???? ?????
??????: 1
CleanCnt:2 10:101575400:0 ??????: ???: Sch - M ??????: 0x1
????? ??? 0:
??? ??????: 0x00000000915E3980: Sch-M Flg:0x40 ECID:0 SPID:68 ????: 02000000 Ref: 1 XactLockInfo: 0x0000000091D90ED0
SPID: ECID 68: ??? ???? 0: INDEX ALTER # ????: 1
??? Buf ???????: ?????: < ???? INDEX ALTER >
????? ?? ?????:
Stype ResType:LockOwner: ??? Xdes:0x00000000905E2E90 'OR': BatchID:0 SPID:66 Sch-M ecid:0 TaskProxy:(0x000000008FF40538)
????: 0x801443c0 Cost:(0/1500)
???? ?????
??????: 2
CleanCnt:2 10:149575571:0 ??????: ???: Sch - M ??????: 0x1
????? ??? 1:
??? ??????: 0x00000000915E16C0: Sch-M Flg:0x40 ECID:0 SPID:66 ????: 02000000 Ref: 1 XactLockInfo: 0x00000000905E2ED0
SPID: ECID 66: ??? ???? 0: INDEX ALTER # ????: 1
??? Buf ???????: ?????: < ???? INDEX ALTER >
????? ?? ?????:
Stype ResType:LockOwner: ??? Xdes:0x0000000091D90E90 'OR': BatchID:0 SPID:68 Sch-M ecid:0 TaskProxy:(0x000000008FADE538)
????: 0x80141040 Cost:(0/1700)
???? ?????
????? ?????? ???????:
Stype ResType:LockOwner: ??? Xdes:0x00000000905E2E90 'OR': BatchID:0 SPID:66 Sch-M ecid:0 TaskProxy:(0x000000008FF40538)
????: 0x801443c0 Cost:(0/1500)

???????? ???? ??? ??????? ?? Microsoft SQL Server 2005.

?????

???? deadlocks ??? ?????? ???? ????? ?????? ??? ??????? ????? ???? ??? ??????? ????? ???? ??? ???????.

????

?? ????? ??????? ????? ???? ??????? ???? ??? ?? ??????? ???????? 6 ????? SQL Server 2008 ?????? ????? ?????? Service Pack 1. ????? ?? ????????? ??? ???? ??????? ???????? ??? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft" (????? ?? ??? ???????? ??? ???? ?? ???? ??????? ??? ?? ??? ??? ?????? ??????????):
977443???? ??????? ???????? 6 SQL Server 2008 ?????? ????? ?????? Service Pack 1
?????? ??? ????????? ???????? ????? ?? ????? ????? ???? ???? ????????? ??????? ????? ???? ??????? ?????? ???? ?? ??????? ?? SQL Server 2008 ??????? ???????. ???? ???? ???????? ????? ???? ????? ??????? ???? ????? ??? ??? ??????? ??????. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft" (????? ?? ??? ???????? ??? ???? ?? ???? ??????? ??? ?? ??? ??? ?????? ??????????):
970365???? SQL Server 2008 ???? ?? ??????? ??? ????? SQL Server 2008 ?????? ????? ?????? Service Pack 1
SQL Server 2008 ???? ????? ????????? ??????? ??? ???? SQL Server ?????. ??? ????? ??????? ???? SQL Server 2008 ?????? ????? ?????? Service Pack 1 ??? ????? SQL Server 2008 ?????? ????? ?????? Service Pack 1. ???? ???????? ??? ????? ????????? ??????? ???????? ?? ???? ???? ?? SQL Server ?? ???? ???? ?? SQL Server ???????.

?????

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

?????

?????? ??? ??????? ??? "????? ????? ??????" ?? SQL Server ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft" (????? ?? ??? ???????? ??? ???? ?? ???? ??????? ??? ?? ??? ??? ?????? ??????????):
935897????? "????? ????? ??????" ?? ???? SQL Server ?????? ????????? ??????? ??????? ?? ??????? ????


????? ?? ????????? ??? ???? ??????? ???????? SQL Server "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft "(????? ?? ??? ???????? ??? ???? ?? ???? ??????? ??? ?? ??? ??? ?????? ??????????):
822499???? ????? ????? ??? ??????? ????? Microsoft SQL Server


????? ?? ????????? ??? ??????? ????? ??????? "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft "(????? ?? ??? ???????? ??? ???? ?? ???? ??????? ??? ?? ??? ??? ?????? ??????????):
824684??? ????????? ???????? ????????? ???? ??????? ????? Microsoft

???????

???? ???????: 978250 - ????? ??? ??????: 03/???/1431 - ??????: 1.0
????? ???
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Workgroup
????? ??????: 
kbmt kbexpertiseadvanced kbsurveynew kbqfe kbfix KB978250 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????978250

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

 

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