FIX: ???? Deadlock ???? ?? ??? ????? ??? ????? ?????? ?? ?????? CXPACKET

?????? ????????? ?????? ?????????
???? ???????: 293232 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???: 352575 352695 (SHILOH)
????? ???? | ?? ????

???????

?? ????? ????????? ?????? ??? ???? ???? ??? ???? ?? ??? ????? ??? ?????? ?????? ????? ???? ??????? (EC) ??? CXPACKET.

?????? ??? ???? ???? ??? ???? ??? ?? ???? ???? ????? spids ?? spid ??? ?? ??? ????? ??????? ??????.

???? ????? sysprocesses ECs ?????? (????? ????? ???? spid) ?? ??? ?????? ????? ???????? ?????? CXPACKET.

????? ???? ???? ?????? EC ??????? ?? ?? spid ????? ?? ???? ???? ??? waiter ????? ??????. ?? ??? waiter ????? ?? ?? ??? ???? ?????? ??? ???? CXPACKET. ????? ??????? ????????? ???? ?? ????? ?? ??????? ???? ?????? syslockinfo ?????? ?? ??? ??????.

?????? ?? ??? ??? ???? SQL ????? ??????? ?????? ??????? ???????:
  1. ????? "SELECT *" ????????? ?? ???? ?????? sysprocesses ?? ?? ?????? "SELECT *" ????????? ?? ???? ?????? syslockinfo.
  2. ??? ???? EC ?????? ?? ????? ??????.
  3. ????? ??????? ??? ???? ???? ???????.
  4. ????? ?????? EC ?????? ??? CXPACKET.
  5. ??? ??????? ?? 1 ??? 4 ???? ECs ????? ??? ????? spids.
??? ?? ???? ????? ????? ???????? ????? ??? ????? ??? CXPACKET.

????

??? ??? ???????? ??? ?????? ??? ???? ???? ???? ?? SQL Server 2000. ?????? ??? ??????? ??????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
290211INF: ????? ?????? ??? ???? ???? ???? ??????? SQL Server 2000

?????????

??? ?? ???? ?????? ?????????? ?? ??? ??????? ???? ??????? ??????? ?? ????:
   File name   Platform
   --------------------
   s80263i.exe INTEL
				
??????: ???? ?????? ?????? ??? ???? ????? ???? ?? ?????? ???? ????? ??? ??????? ??????? ?? ????? ????? ??? ????? ??????.

???? ??????

??? ?????? ???? ???? ??? ?????? ???:
  • ???? ???????.

    - ?? -

  • ??? "?????" SQL ????????.

?????

???? Microsoft ?? ??? ????? ?? SQL Server 2000. ?? ????? ??? ??????? ???? ??? ?? SQL Server 2000 Service Pack 1.

???????

???? ???????: 293232 - ????? ??? ??????: 13/?????/1424 - ??????: 3.1
????? ???
  • Microsoft SQL Server 2000 Standard Edition
????? ??????: 
kbmt kbbug kbfix kbqfe kbsqlserv2000sp1fix KB293232 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????293232

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

 

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