INF: ??????? SQL Server 6.5 ????? ???????

?????? ????????? ?????? ?????????
???? ???????: 166967 - ??? ???????? ???? ????? ????? ??? ???????.
??? ????? ??? ???????. ????? "??? ??" ??? ??? ??????? ??? ????.
????? ???? | ?? ????

??????

?????? ??? SQL Server ??????? ??????? ??? ??????? SQL Server ??????? ?????? ?? SQL Server 6.5 ???? ????? "????? ??????? ?? Microsoft":
319942HOW: ??????? ????? ???? SQL ??????? ?????
???? ?? ???? SQL Server ???? ?????? ?? ?????? ????? ??????? ?????. ??? ???? ??????? ????? ????? IS ?? Microsoft SQL Server ???? ???? 4,000 ???? ???????? ????????. ??? ????? ??????? ??? ??????? ????? ???????? ???????? ???? ?????? ??????? ??????? ?????????? ???? ????. ??? ???? ???? ???? ??? ??????? ??? ??????? ????? ????? ???????? ??????. ?? facilitated ??? ??????? ?????? ?? ?????? ?????? ??????? ???? ????? ????? ???????? ??? ?????? ????? ??????? ?????.

?????? ??? ??????? ?????? ??? ??? ?????? ?????? SQL Server ???? ??? ??? ??????? ????? ?????? ?? "????? ??????? ?? Microsoft:
110352?????? ?????? ???? Microsoft SQL
??? ????? ????? ???? ? ???? ??????? ?????? ?? ????? ??????? ????? modest ??? ??? ?????? ?????? ?? ??? ?????? ???? ????. ??? ??? ?? ?? ???? ??? ??? ????? ??? ????? ??? ???? ?? ????? methodical ?????? ?? ?????? ??? ????? ????????? ??????? ????? ??? ?????.

??? ?? ??? ?????? ???? ????, ?? ??? ??????? ?????? ??? ????????? ?? ???? ?? ???? ?????? ??????. ???????? ?? ????? ????? ????????? ??? ??????? ????? ???????? ???????? ??? ?? ??? ??? ?????? ????? ??? ??? ??????? ???? ???? ????????? ????????. ?? blindly ??? ??? ???? ????? ??? ??? ????? ??????? ?????? ?? ????? ?????? ?????? ??? ????????? ??????? ?????? ?? ?????? ?? ??? ????? ?????? ?? Microsoft.

??????? ????

???? ????? ?? ?????? ????? ?? ???? ????? ??? ?? ??????? ??????? ??? ???? ?? ????? ??? ????? ?????? ???????? ????? ????. ???? ???? ??? ?? ?? ???? ????????? ????? ??? ?? ????????? ??? ??? ???? ??????. ????? ??? ?? ????? ?? ??? ??? ??? ???? ?????? methodical ?????? ??? ???? ??????? ?????? ???? ???????.
?????? ???? ?????? ?????
??????? smp
????? ????????
?????? ?????? ?????? ???????
????? ??????? ?????? ???????
??????? ???? ??? tempdb ?? RAM? ????? ????? ???, ????? ?????? ????? ? ???????? ???? ?????? I/O ? ??? ????? ?? casually ??? ??? ??? ???? ??????? ?? ???? ?????? ????? ?????????? ?????? ?? ???????.

?????? ??? ??????? ?? ?? ??? ???????? ???? ??????? ??? ???? ??? ???????? ?? ?????????:

????? ???? ?????? ?????:

??? ??????? ????????? 0 ???? Windows NT Server ????? ??????? ???????? ????? ??? ?????? ????? ?? SQL Server. ??? ???? ???? ??? ?? ??????? ??????. ??? ????? SQL Server? ?????? ??????? ???????? ?????? "????? ???? ??? ??????? ???? ???????" ?? "???? ??????" ?????? "??? ????? ???? ??????. ??? ???? ????? ??????? ???????? Windows NT Server ?????? ?????? ????? ??? ??? ? ???????? ???? ?? ?? ??????? ?????? ?? ?????? ????? SQL Server. ???? ?????? ??? ??????? ????? ????? ????????? "????? ???? ?????? ?????". ??? ???? ??? ??? ??????? ??? 1 ??? ??? ??????? ?????? SQL Server SetProcessWorkingSetSize() Win32 API ???? rigidly ????? ?????? ?????. ??? overcommit ??????? SQL Server ?? ???? ??????? ??? ?? ??????? ?? ?? ???? ??????? ???? ????? ???? ??????? ???????? ????????.

?????? ??? ??????? ??????? ???? ??? ??? ??????? ????? ?????? ?? "????? ??????? ?? Microsoft:
110983?? ???????? SQL Server ??????? ??????? NT
??????? smp (6.5 ???):

??? ??????? ????????? 0 ???? SQL Server (?? ??? ??? ???????) ????? ?? ????????? ??? n-1 ??? ??????????. ??? ???? ??????? SMP ??? ????? ??? ???????? ????? ?? SQL ??? 15. ???????? ?????? ?? ?????, ??? ???? ??????? ??????? ?????????. ????? ??? ??????? ??? -1 ??? ????? ??? ???? ??? ??? ????????? ???? ???? ??????? SQL Server ???? ?? starve ???? ??????? ?? ????? ???????? ???????? (CPU) ??? ???? ?????. ????? ??????? ????????? ????? ???? ??????? ?? ???? ???? ???? ???? ?? ?????????. ?? ???? ????? NET VIEW ?? ??? "?? ????? ???? ??? ???? ???????". ?????? ???? ?????? ???? ??? ??????? ??? ????????? ?? ????????? ???? ??? starvation CPU. ?? ????? ?????? ????? SQL Executive ? ????? ????????? ? ?????? ??????? ???????? ???.

??? ?????? Compaq Proliant ????????? Server ??????? (ASR) ?????? ??????? watchdog ?? ???? CPU starved ? ????? ??? ???? ??????? Windows NT Server ?? ??? ????? ???? ???????.

??????? ????????? "smp ???????" ?? 0 ??? "????" ??? ????????? ??? ???? ??????? SQL Server ?????? ???? ?????? I/O ? ????? ????? ???????. ????? ??? ????? ???? ??????? ??? ??????????? ?????? ? ?????? ????? ???? ???????? ???????? ??????? ????????? ???? ?? ???? ???? ??????? ????? CPU ????? ????? ???? ???? ???? ???? ???? SQL. ??? ?? ???? ???? ????????? ??? ???? SQL Server ????? ???? ???????? ??? ??????? ??????? ????????? "smp ???????" ?? 0. ????? "smp ???????" ??? 1 ?2 ????? ?????? ????? ?? ??? ?? ???? ??? ???????.

?? ??? ??? ?????? ??? ??????? ??? ??????? "smp ???????" ?????- 1 ? ????? ??? ????? ???????. ??? ??????? ??? ?????? ??? ?????? ??????? (OLTP) ?? ????? ???? ???????? ?????? ????? ? ??? ???? ?? ??? ????? ?? ???? ????? ??????????? ? ?? ???? ??? ???? ????????? ?? ????? ?????? ??? ?? SQL Server (???? ?????? ?? ??? ??????? ??? ????? ?????? ??? ??????? SQL ?????) ??? ??????? ???? ????? ??????? ???? ??? ?? ??????? ?????? ???? ??????.

??? ???? ??? ??? ????? ????? ????? ????????? ?????? ?????? ?? ?? ??? ??? ?? ???? ???? ?????, ?? ?????? ?????? ????. ??? ???? ??????? ???? ???? ???? ?????? ????? ???? ????? ?? ????? ?? ????? ???? ?? ?????????. ????? ?? ???? ????? ? ????? ?? ????? ???? ????? ?? ???? ???????.

????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft:
111405SQL Server ? Windows NT ???? ????? ???????
????? ????????: ??? ??????? ????????? 0 ???? ???? SQL Server ?????? ??????? ????? 7 ??? ???? ??????? ????? ???????? ? 15 ??? ???? ??????? SMP (?????)

?????? ??????? ????????? ?? ???? ???????. ????? ??? 1 ????? ?????? ????? SQL Server 15 ??? ??????? ????? ???????? ? 24 ??? ???? ??????? SMP. ??? ???? ?? ???? ???? ??????? ?????? ????? "smp ???????"-1.

????? ????? ????? ?????? ????? ??????? ???????? ??? ?????? ?? ??? ????? ????? ?? ???? ???????. ???? ?? ?????? ?? ???? ??????? ???? ??? ??? ?????? ???????? ??????? ??????? ??? ?? ??? ??? ??????? ???? ??? ??????? ?????? ????. ??? ???? ?????? ?? ?? ?????? ??? ????? ???? ???? ?????? ????? ??? ?????? Microsoft. ??? ???????? ??? ??? ???? ??????? ??????? ?? ????????? ???? ????. ?????? ????? worker ???? ??????: ??? ??????? ????????? ??? 255, ???? ???? ?????? ????? ?????? 255 ?????? ??????. ??????? ??????? ????????? 255 ?? ???? ???????. ??? ?? ???? ????? ??????? ?????????? 255 ???. ???? ????? ???? ??????? ?????????? ???? ????? ????? ??? 255 ?????? ????? worker ??? ???? ???? ??? ????? ??? ?????? ?? ???????. ?? ??? ??? ??????? ??? ????? ????????? 255 ??? "???? ??????" ???? ??? ????? ??? ?????? ????? ??? ??? ????? ???????? ???????? (CPU) ????????, ??? ??????? ????????? ?? ??? perceived ? ????? ??? ????? ?? ?????? ??? ?????? ???????.

?? ?????? ???? ?? ????? ?????, ??? ????? ???? ????? ???? ???? ??? ?? ???? ????? ??????. ?? SQL Server 6.5 ? ??? ???? ?? ??? ?????? ? ???? ????? ???? ???????? ???? ?? ????. ????? ??????? ?????? ?????? ????? worker counterproductive ????? ??? ???? ??? ????? ?????? ???? ??? ????? ????? ?????? ????????. ????? ??????? ?????? ???????:

?? SQL Server 6.5 ??? ??????? ????????? ?? ? ????? ???? ??? 30 ??????? ????? ????? ??????? ??????? ?? SQL Server ??? ???? ???????? ?????? ??????? ?????? ???????. ?? ???? ?? ??? ???? ?? ??????? (?? 256 ???????? ?? ????) ? ?? ??????? ?? ???? ?? ????? ??? ?? ??????? ?????? ?????? ????? ?????? ?????? ??????? ?????? ?????? ??????. ????? ?? blindly ????? ??? ??????? ??? ??? ????? ???? (??? ???? ?????? 5 ???????) ? ??? ??? ??? ?????? ?????? ??? ????????? ???????. ???? ??? ????? ??????? ?????? ??????? ????? ????? VivoActive ??????? ?????? ?? ??????? ????? ????? ?? ?????? ???? ??? ?? ??????? ?????? ????????? ???????. ???? ???? ????? ?? ??????? ?? ??? ?????? ? ?? ????? ????? ?? ?????? ?? ???? ??? ????. ?? SQL Server 6.5 ???? ???? ?????? ??????? ????? ??????? ??????? ??????? ?? "?????? ??????" ?? ????? ?? ??? ??? ??? ????? ????? ????? ??????? ?????? ???????.

?? ?????? ?? ???????? ?????? ????? ????? ??????? ?????? ?????? ?????? ????? ?? ???? ????? ????? ????? ??????? ?????? ??????? ?? ???? appreciably ??? ?????? ?????? ????? ??????? ?????? ??? ???? ?????? ??? ??????, ????? ????? ?????? ???????? ??? ????????? ??????? (percentage-wise) ?? ??? ????? ??????? ??????.

???????

???? ???????: 166967 - ????? ??? ??????: 05/???? ??????/1435 - ??????: 4.0
????? ???
  • Microsoft SQL Server 6.5 Standard Edition
????? ??????: 
kbnosurvey kbarchive kbmt kbenv kbinfo kbusage KB166967 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????166967

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

 

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