INF: ??? ????? ????? ???? ????? ????? ????? ???? SQL

???? ???????: 299641 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???????? ????? ????? ??????? ?????? ?????? ???????
????? ???? | ?? ????

??????

???? ??? ??????? ????? ??????? ?????? ???? ??????? ??????? ???? ????? ?? SQL Server 2000 ?????? ????? ?????? SP1 ?? ????? ????.

?? ???? ??????? ??? ?????? ?????? ???? (OLTP) ? ?? ???? ?????? ???? ??????? ????? ????? ?????? ?? ????? SQL Server ????? ? ????? ??????? ???? ???? ??? ????? ????????? ??? ????? ???????? ???????? (CPU 16 ?? ????). ????? ???? ??? ?????? ?????? ??? ???? ??? ???? ?? ??????? ???? ??????? (???? ?? 10,000 ?? ???????) ??? ?????? ????????? ?????? ???????? ????? ???? SQL ??????? ???????.

??????? ????

????? SQL Server 2000 Service Pack 1 ????? ???????? ????? ????? ?????? (VIA) ?? ???? ????? ???? ???? ??????? ??????? ?? ?????? ???????? Network Server. ????? ?? ????????? ??? VIA ???? "??? SQL Server ???????".

????? ??????? ?????? ???????? Network Server ?????? ???????????? ???????? ???? ??? ??????? SQL Server. ???? VIA ??? ????? ???? ????? ???? ???? ??? ???? ?????. ???? ????? ???? ??????? ??? ?????? ??? ?????? ?????? ?? ????? ???????? ???????? (CPU) ?? ???? ????. ???? ??? ????? ???? ????? ???? ????? ????? ??? schedulers ??? ??????? ??? ??? ?????? ????? ???????? ???????? (CPU) ??? ?? ???? ?????? ???? ??????? ???????.

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

?????? ???? ??????? ????? ???? ??????? ???????:
  1. ??? ????? ???? ???? ??????.
  2. ???? ??? ????? ?????? VIA ?????????? ??????.
  3. ???? ??? ????? ????????? VIA.
  4. ??? ?????? ?????????? ???????? ?????? ??? ????? ???????? ??? ?????? (??? ???? ??????? Giganet ?? Servernet).
  5. ?? ?????? ??????? ??????? ????? ??????? ???? ???? ?? ???? SQL Server ??????? ??? ? ???????? ???? ?????? ??????:
    <??? nic >: <??? ?????? VIA > [???? CPU]...
    ?????? ??? ?? ????? ????? ???? ??????? (NIC) ???? ??? ?? ??? ?????.

    ??? ???? ??????? ??????? 
    0:1000[0x000f],0:1001[0x00f0],1:1000[0x0f00],1:1001[0xf000]
    ????? ????? ?????? ????? ???? ???????. ?? ???? ????? ????? ??? ???? ????? ???????? ???????? (CPU) ?????? ??? ????? ????? ????? ?? ??? ????? ???????? ???????? (CPUs ??? ?????) ????????.
?????? ?????? ?????? ???????? ???????:
  • ??? ?????? VIA ??? ??? ??? ???? TCP. ????? ??? ????? ??????? ??? ?????? ???????.
  • ??? ????? ???? ??????? ??????? ??????? ???? ???? (?????? ?? 0 x "??" 0 X).
  • ?????? ???? ?? ???? ????? ???? ???? ???? ??????? ???? ?????? CPU ????? ???? (0) ? ???? ???? ??????? ???? ?????? ?????? CPU ??????? ?????? ?????? (1) ?????.
  • ???? ???? ???? ???? ??????? ????? ????? ???????? ???????? (CPUs) ??? ?????? ?? ????? ????????? ???? ????? ???? ???? ????? ???????? ???????? (CPU) ??? 16 ???? ????? ????? ???? ???? ????? ???????? ???????? (CPU) ??? 24 ? ???? ???? ???? ???? ????? ???????? ???????? (CPU) ??? 32.
  • ?????? ????? ??????? ??? CPU ????? ??? ????? ?? ???????? ??? ???? ???????? ???????? (CPU) ??? ?? ???? ??????? ????? ??? 1.
  • ??? ????? ?? ???? ??? 0 ?? ??? ??? ????? ???? ??????? ??????? ??? ????? ???? ???? SQL I/O ??? ?? ?? ????? ???????? ???????? (CPUs) ???????? ???? ????? ?????? ?????? ??????? SQL Server.
  • ?? ???? ????? ???? ???? ??????? ??????? ????? ????? SQL Server. ??? ????? ????? ?? ?? ?????? ????? "???? SQL Server" ???? ???? ????? ????? ???? ??????? ????? ????? ???????.
???? ??????? ???? ??????? ??????? ?? ??????? ??????? (??? ????? ?? ?? ????? ??????? ???????? ??? ??????? ?????? ????????? ???????):
  • ????? ???? ?????? ??? ???? ?? ????? ???? ??????? ?? ????? ??? ????? VIA ?? SQL Server.
  • ?????? ?????? ??? ????? ??????? ?????? ????????.

    ????? ??????? ????? ????? ?? ????????? ??? ???? VIA ?????? ????? ??? ?? ????? ???????? ???????? (CPU) ??? ?? ???? ?????? ???? ??????? ???????. ???? ??? ?????? ??? ?????.

    ??? ???? ??????? ??? ???? CPU 16 ???? ?????? ??????? ?? ??? ??????? ??? nic:port [???? cpu 0xf000] ????? ????? OLTP ?? ??? ??????? ??? nic:port ?????? [???? cpu 0x0fff]. ?? ??? ?????????? ??????? SQL Server ????? ???????? ???????? (CPUs) ???????? ??????? ?????? ??????? ??????? ?????? ?????? ?????? ??????? ?? OLTP. ???? ?? ?? ??? ??????? ???? ??????? ???? ??????? (sp_configure) ??? ?? ?? ??????? ??? 0xffff.

???????

???? ???????: 299641 - ????? ??? ??????: 14/????/1428 - ??????: 1.2
????? ???
  • Microsoft SQL Server 2000 Service Pack 1
????? ??????: 
kbmt kbproductlink kbinfo kbsqlserv2000sp1fix KB299641 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????299641
(http://support.microsoft.com/kb/299641/en-us/ )
???? ??? ?????? | ????? ???????

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

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