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

?????? ????????? ?????? ?????????
???? ???????: 319892 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???: 102179 (sqlbug_70)
????? ???: 356317 (sqlbug_80)
????? ???? | ?? ????

?? ??? ??????

??????

???? ??????? ???? SQL Server ????? ??? ?????? ?? ???????? ???????? ????? ?????????. ?? ???? ????? ????? ???? ????? ????????? ?????? ?? ?? ??????? ???? ???? ???.

SQL Server 7.0 ?????? ????? ?????? Service Pack 4 (SP4) ? SQL Server 2000 Service Pack 3 (SP3) ????? ????? ????? ?????? ???????. ???? ??????? ?????? ????? ???????? ???? ?? ??????? ???????:
  • ???
  • ????? ?? ??????
  • ???????/??????? (IO)
  • ???????
  • cpu
?????? ????? SQL Server ??? ????? ????? ????? ????? ?? ????? ????? ????? ??? ???????? ?? ??? ????? SQL Server. ?????? ??? ?????? ??? ??? ?????? ????? ??? ?? "???? ?? ?????????" ???? ????? ?? ??? ???????.

SQL Server 7.0

??? 1223: ????? ??????? % d: % d ????? ?????? ????? "% s" ??? ???? %s ???? ???? ???? ???? ??? ?????? ??? ????? %d ??????. ????? ??????? % d: % d ???? ????? "% h" ??? ??? ??????.

SQL Server 2000

??? 1229: ????? ??????? % d: % d ???? ??????? ???? ??? ??? ?????? ??? ????? % d.
????? ????? ??? ???? ????? ???????.

????? ????? ?????: 1223 ? 1229
????? ???? ?????: 17881 ? 17883
???? Schedulers ???? ?????: 17882 ? 17884
????? ???? ?? ????? ????? ????? ?????? ????? ????? ???? ?? ???? ??????. ??? ?? ?????? ??? ????? SQL Server ? ????? ????? ?????? ?????? ?????? ????? ??????.

??? ???? ??????? ?? ???? ????? ??? 17883 ??? ???? ????? ?? ?????? ?????. ??? ???? ?? ????? ??? ??? ??????? ????? ???? ??? ???? ??? ????? SQL Server ?? ???? ????? ?? ??????? ??? ??? ??? ?????.
?????? ????? Microsoft ?????? ???? ????????? ??????? ????? 17883 ????. ??? ???? ????? ????? 17883 ?? ????? ????? ?? ????? ????? ?????? ?????. ?? ?? ????? ??? ?????? ?????? ???? ?? ?????? ??????? SQL Server Microsoft ???? ????? ???? ??? 17883 ?? ?????? ?? ??????? ???? ??? ????? ?????? SQL Server. ??? ???? ??????? ??? ??? ????? ?? ????? ????? CPU ??????? ? ??? ???????. ??? ???? ????? ????? ????? ????? 17883 ??? ??? ???? ???? ??????? ??? ??????? ???? ?????.

??????? ????

???? ??? ????? ??????? ????? ?????? ????? ???????? ???? ????? ??? ????? SQL Server.

ums

???? ??? ?????? ??????? ????? ?????? ???? ????? ???? ????? ??? ??? ?????? SQL Server ??? ????? Ums.dll ????? ??? ?????? (UMS).

?? ?? SQL Server 7.0 ? Microsoft SQL Server 2000 ??????? schedulers ????????. ????? ??? schedulers ?????? ?? ?? SQL Server ????? ??????? ????? ???? ??????? ??????? ??? ?????? ??????? ????? ???????? ????????. ???? UMS ??????? ?? ?? ?????? ???? SQL ???? ???? ??????? Win32 ?????? ????? ?? ???? ????? ? ????? ????? (?? ??????) ????? ???? ??? ???? ???????. ?????? ?????? ????? ?????? ??????? ?? fibers ???? ????? ? ????? ????? SQL Server ??????? CPU ????? ????? ???????? ????? ???????? ??? ???????.

??? ???? ??????? ???????? ????? waiters ????? ???????? ??? ??? ?????? (WaitForSingleObject ??? ??? Win32) ??? ???? ????? ????????? "?????" ? "???????? (SetEvent) ??? ?????.

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

?? ????? ????? ????? ????? ??????? ??? ????? ???? (???? ????? ????). ??? ??? SPID ???? ???? ??? ?????? ?????? ???????? ????? ??? ?????? ????? ? ???? ??? ????? ???? ?????? ????? worker ??????? ? ???? ?????? ????? worker ??????? ?? ???? ?????? un-resolvable, ??? ????? ????? ????? ??????? ??? ??? ??? SQL Server:

SQL Server 7.0

??? 1223: ????? ??????? % d: % d ????? ?????? ????? "% s" ??? ???? %s ???? ???? ???? ???? ??? ?????? ??? ????? %d ??????. ????? ????? ???? % d: % d ????? "% h" ??? ??? ??????.
??? ???????:
  1. ?????? SPID
  2. ?????? ECID (???? ????? ????? ?????)
  3. ??? ??? ???????
  4. ??? ??????
  5. ???? ????? UMS ????????
  6. ???? SPID
  7. ???? ECID
  8. ??? ?????? ??????

SQL Server 2000

??? 1229: ????? ??????? % d: % d ???? ??????? ???? ??? ??? ?????? ??? ????? % d.
??????? ?????:
  1. ???? SPID
  2. ???? ECID (???? ????? ????? ?????)
  3. ???? ???? ????? UMS ????????

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

????? SQL Server ????? ???? ????? ??????? ?? ??????? ???.

?????? ???? ???????? ?????? ???? ????? ???????:
  • ????? ????? ??? ????? (-T ###)
  • ??????? traceon DBCC (###)
SQL Server 7.0:-T1216

SQL Server 2000:-T1261

?????? ??? ??? ??? ????????. -??? ?????? ??????? T1216 ??? SQL Server 2000 ??? ??? ????? ???? ??????? ?? ????? ???? ???? ???. ????? ??? ??????? 1261 ????? ?? ???.

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

???? ?? ???? 1 SQL Server.

?????? 1 ??? ????? ??? SQL ???????? ???? ???? ?????? ?? ???? ?????? ????? ????????.

??? ???? ??????:
begin tran
update authors set au_lname = 'test'
???? 1 ???? IDLE ?????? ????? ???? ? ????? ??? ?? ?????? ?????? ?? ???? ?????? sysprocesses.

????? 2 ??? 255: 254 ??????? ???? ?? ??????? ????? ?????? ??? SQL Server ? ????? SELECT ?? ???? ???????. ??? ??????? ??????? ??? ???? ???? ??? ??? ??????? ??????.

????? ?????? 1 ????? ???????? ???? ???? ?????? ???????? ???? ?? ?????? ???? ?????? ??????? ??????? ?????? ????? 2 ??? 255.

???

???? ????? ????? ??? ????? ??? ???? ??? ?????. ?? ??? ??? ???? ????? ???? ????? ??????? (??????? ?? 5 ?????) ? ???? ????? ????? ??? ??? ??? SQL Server.

?????? ??? ????? ????? ??? SPID/ECID ???? ????? ??????? ??????. ????? ???? ?? ??? ????? ??? ????? ????? ??????? ????? ??? ??? ???? ?????.

?? ??? SQL Server ?? ?? ??? ?????? ????????. ??? ???? ???? ????? ??????? ?????? ??? (1223 ?? 1229) ????? ????. ??? ???? ??? ???????? ????? ?? ?? ??? ?? ?????.

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

??????? ??????????? ????? ?? ???? ??????? ? ?????? ???? ????? ?? ???? ??? ???? ???????. ??? ???? warrants ?????? ????????? ????? ???? ??? ????? ??????? induced ?? ???????.

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

?? ???? ?????? ??? ????????? ?? ???? ?????? sysprocesses ??????? ?????? ??????? ????? SQL ???????? "?????" ?????? SPID ??????? ?? ????? SPIDS ??? ???????? ?????? ?????? ????? worker ?? ????? ?????? ??? ???? ?????.
251004????? ?????? ??? SQL Server 7.0
271509????? ?????? ??? SQL Server 2000
263889????? ??? SQL ????? [[???????]]

?????? ?????

??? ?? ????? ?? ?????? ??? ??????? ?????? ?????? sysprocesses ?????? ??? ????? ????? ?? ??????? (Sqlservr.exe) ?? ???? ???? Microsoft SQL Server ?????? ??? ???? ?? ?????????.

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

?? ??????? ???????, ???? ?? ???? ????? ????? ??? ????? ????? ??? ??????? ?????? ?????. ??? ??? ????????? ?????? ????? ??????? ??? ???? ?? ???????? ???????? SQL Server ?????? ?????? ????????? ? ???? ?????? ???? ???? SQL Server. ????? ?????? ?????? sysprocesses ??? ???? ECID ??????? ??? ??? ???????? ???????? ????????? ???????? ?? SPID ???????. ??? ???? ???? ECID ????? ?? ??????? ??? ????? ???????? ???????? (CPUs ???????) ???????? ??? ????????? ??? ???? ??? ?? ????? ??? ??????? tuned ???? ???. ?????? ??? ????????? ???? ????????? ???? ???? parallelism (MAXDOP) ????? ???? ????????? ??????? ???? ????.

??? schedulers

??? ?????? schedulers ????????. ??? ??? ????? "SQL Server" ? ??? ????? ????? ???? ?????? ????? ???? ????? ??? schedulers ????????. ??? ???? ??? ????? ??? ????? ???????? ???????? (CPU) ???????? ???? SQL ??? ????? ????? ?????? ?????? ????. ???? ????? ??? ?????? ???? ???????? ??? ????? ???? ?????? ?????????? ??? ??????? ???? ???? ????? ??? ????? ???? ?? ????? ???????? ???????? (CPU). ???? ????? ?? ????????? ??? ????? ???? ???????? ????????? ?????.

???? ?????? ?????? ????????? ???? ?????? ???????? ??? ??? ????? ???????? ???????? (CPU) ??? sp_configure ????? ??????? ????? ???? ?????? ?????? ????? worker ????? 255.
?? ??? ??????????? ??? ??????
??? ????? ???????? ???????? (CPU)??? ???????
1255
2128
464
832
1616
???? ????????? ???????? ???? ????? ?????? ?????? ?? ????????? 255. ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
319942????? ????? ??????? ????? SQL Server ????????

????? UMS

??? ????? ????? ????? ???? ?????? ?? ????? ????? ????? ?? 60 ?????. ??? ?? ?????? ????? ??? ????? ?? ??? ???? ?? ?????????, ??? ????? ????? ????? ???????? ??? ??? ??? SQL Server. ??? ????? ??? ?? 60 ????? ??? ??? ?? ???????.

???? ?????? ??? ??????? ?????? ??????? ??? ????? ??????. ?????? ???? SQL Server ??? ??? ???????? ????? ??????? ???????? ??? ????? ????? ???????.

?????? ??? ??? ???? ?? 60 ?????. ????? ???? ?? ???? 120 ????? ??? ?? ??? ????? ????? ?? ?????.

SQL Server 7.0

???: 17881 - ?????? ????? %1! ld! ???? ?? ????. PSS 0 x % 2! p! ? EC 0 x % 3! p! ? ???? UMS 0 x % 4! p!
???: ?? ???? deadlocks ???????? 17882 - ??? ???? schedulers

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

????? ????? ??? ????????? ????? ??? ??? ?????? SQL Server 7.0 ?? -T1217 ??????? ??? ???????.

SQL Server 2000 SP3

8.00.760 (?????? ????? ?????? SP3)
???: 17883 - ?????? ????? %1! ld! ???? ?? ????. SPID %2! ld! ? ECID % 3! ld! ? ???? UMS 0 x % 4! p!

8.00.765

??? ????? ?? 8.00.765 ??????? ?????? ????? ? ?? ????? ??????? ?? ??????? ???? ???? ???????.
???: ??????? 17883 - %1! ld!: % 2! ld! (%3! lx!) ???? UMS 0 x % 4! p! ???? ?? ?????? - ??? ????? %5! ld!

??? ???? ??????:
21 ???? 2003 08:22:20.27 ?????? ???: 17883 ? ???????: ???? 1 ?: 0
???? 08:22:20.27 21 ???? 2003 51:0 ?????? (dbc) ???? UMS 0x018DA930 ???? ?????? - ??? ????? 0.
21 ???? 2003 ?? ???? 08:22:22.45 "????? ??????" ??????? 0x00000000
???: ?? ???? deadlocks ???????? 17884 - ??? ???? schedulers

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

????? ????? ??? ????????? ????? ??? ??? ?????? SQL Server ???????? - T1260 ??? ???????.

??? ????? ????? ?? SQL Server 2000

????? ?? SQL Server 2000 SP3 ?? ?????? ?????? ??? ?????? ????? ????? ?????. ??? ??????? ?????? ????? 8.00.765, ??? ????? ??? ????? ????? ??? SQL Server ?????? ?????? ????? ???????? ?????.

???? ????? ??????? ????? ????? ????? ?? ??? ????? ????? ??? (17883 and17884) ?????? ????????? ?????? ??? ????? ????? ???? ???? ????? SQL Server. ?????? ??? ????? ????? ?? ?? ????? ??????? ?????? ????? ???? - T1262.

??? ????? ??? ????? ????? ?? ??? ?????? ?? SQLDmpr ### .mdmp. ???? ????? ??? ????? ????? ????? ?????? ??? Microsoft ???????? ?? ????? ????? ???????.

??? 17881 ?????? 17883

???? ??? ??????? ??? ????? UMS ???? ?? ????? ????? ??????. ?????? ????? ??? ?? ?? ???? ?? ?????? ????? ?? ???? ????? ???? ?? ???? ???????? ???????? ?????? ?????? ?? ??? ??? ??? ????? ?? ??? ???????. ???? ??? ??? ????? ???? ?? ????????? ??? ?? ?????? SQL Server ?? ???? ????? (XProc ???? COM ?????).

???? ??? ????? ??? ???? 17833 ????????. ???? ?? ????? ?? "????? ??????? ?? Microsoft" ?? ?????? ??? ?????. ??? ???? ?????? ????? ????? ? ?????? ????? ????.
815056FIX: ????? ?????? ???? ????? ???? ????? ?????? SQL Server ? ?? ?????? ???? ???? ???? ??? ?????: 17883 ????
810885?? ????? ????? ????? ????? ????? ??? 17883
??? ??? ?? ???? ????? ????? ????? ???????, ???? ??? ??????? ?? ??????? ?? ?????? ?? ???? ????? ??????? ???????.

??? ??? ??????? ????? ???? ????, ???? ???? ????? ??????? ????? ?? SQL Server. ???? ?? ???? SQL Server ????? ?? ????? ?? ?? ????? ?? ?????????.

??? 17882 17884

???? ??? ??????? ??? ?? ???? ?? ???? schedulers UMS ?????? ?????. ???? ??? ??? ??? ???? ??????? ????? ???? SQL Server ? SQL Server ????? ?? ?????????. ??? ?? ????? ?? ????? 17881 ? 17883 ???? ??? ??????? ? ????? ??????? ?? Microsoft ?????? ??? ???? ?? ?????????. ??? ??? ???????? ?????? ??????? ?????? ????? ???????.

???????

???? ???????: 319892 - ????? ??? ??????: 10/???? ??????/1426 - ??????: 8.0
????? ???
  • Microsoft SQL Server 2000 Service Pack 3
  • Microsoft SQL Server 7.0 Service Pack 4
????? ??????: 
kbmt kbsample kberrmsg kbbug kbfix kbinfo KB319892 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????319892

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

 

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