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

???? ?????? ???? ??????
???? ID: 299641
??? ?? ??????? ???? | ??? ?? ??????? ????

??????

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

??? ?????? ????????? ?????? (OLTP) ?????? ?????????? ???? ??????????? ??? high-end, ??????????-???? SQL ????? ????????? 16 ?? ?? ???? CPU ?? ??? ???????? ?? ?? ??? ???????? ??????????? ?????? ?? ???? ??? Particular ???, ?? ?????? ?????? ?? ?? ????-tier ????????? ????? ?? ???-??? SQL Server ?????? ?? ??? ?????? ??????? (?? ???? 10,000 ????? ?????) ?? ?? ?????????? ?????? ????

???? ???????

SQL Server 2000 ?????? ??? 1 introducing ?????? ??????? ???????? ??????????? (VIA) ????????? ?? ??????????? ?? ????? ????????? ???? ?????????? ??????? ?????? ??? ??????? VIA ?? ???? ??? ???? ??????? ?? ??? SQL Server ???????? ?????? ??????

????? ?? ???? ??? ????? ??????? ?????? ????????? ?? ????? ?? SQL Server ????? ???? ?? ?? ????????? ???? ?? ???? For the VIA transport, a network reader thread is created for each port defined. This thread can be restricted to run on a defined set of CPUs with a specified mask. The network thread will only distribute work items to schedulers running on the same set of CPUs as defined by theconnection affinity mask.

If you do specify theconnection affinity mask, you should use it in conjunction with the processoraffinity masksystem configuration option. Theconnection affinity maskshould be a subset of theaffinity maskconfiguration option. ?? ???? ??? ???? ??????? ?? ??????? ??????????? ??, SQL Server ???????? ?????? ??????

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

    ?????? ?? ???, ?????
    0:1000[0x000f],0:1001[0x00f0],1:1000[0x0f00],1:1001[0xf000]
    						
    ??? ??????? ??????? ???? ????? Each thread will be restricted to four CPUs and will distribute its work items to the same four CPUs.
Please note the following additional points:
  • The VIA port number is not the same as the TCP port number. This number needs to match up between the client and the server.
  • Theconnection affinity maskis represented in hexadecimal (preceded by 0x or 0X).
  • The mask is a bitmap in which the rightmost bit specifies the lowest-order CPU (0), the next rightmost bit specifies the next lowest-order CPU (1), and so on.
  • ??? ??-??????????? ???? ???????????????? ????????, ???? ??-???? ????? ??? ?? CPU ?? ??? covers ?? 16 CPU, ?? ???-???? ????? covers ?? 24 CPU, ?? ??? ?????-???? ????? covers 32 ?? CPU.
  • ???? ??????? CPU, ??? ?? CPU ?? ???? ??? ?? ??????? ???? ?? ????? ???? ?? ?????????? ???? ?????????? 1 ?? ??? ??? ???? ?? ?????
  • ?? ??? ????? 0 ?? ??? ???, ?? ?? ????????? ???? ?????is not specified, SQL Server network I/O is scheduled to any of the CPUs that are eligible to process SQL Server threads.
  • ?? ???connection affinity maskcannot be changed while SQL Server is running. You should shut down and then restart the instance of SQL Server in order to have a new value specified for theconnection affinity masktake effect.
Theconnection affinity maskcan be used in following cases (although the final configuration depends on server specifications and subsequent tests):
  • ?? SQL ????? ?? VIA ??????????? ?? ???? ?????? ??? ??????? ?? ??????? ???????? ?? ????? ???? ?? ????
  • ??????????? ?????? ?? ???? locality ?????? ?????

    ??????? VIA ????? ?? ???? ?? ????? ?????? ????? ?? ?????? ???????? ???? ???? ????? ?????? ??? CPU ?????? ????????? ?? ??? ?????????? ???? ?????. ?? ??????????? ???????? ???? ?? ?????? ???? ???

    ?????? ?? ???, ??? 16-CPU ?????? ?? ??? ??? ????? ??? ?? ??? ???? nic:port ?? ?????? ??[cpu ????? 0xf000]?? OLTP ??? ?? ??? nic:port ?????? ??? ???? ?? ???[cpu ????? 0x0fff]. ?? ???????? ???, SQL Server ??? ??? ?? ????? ???? ?? ??? ???? ??? CPU ????? ????? ?? ??? OLTP ?? ????? ???? ?? ??? ??? ????? ?? ?????? ?? ??? ?? ??????? ???????????????? ?????? (sp_configure) ????? ??? ???? ?? ???? ?? ???0xFFFF.

???

???? ID: 299641 - ????? ???????: 02 ?????? 2010 - ??????: 2.0
??????: 
kbproductlink kbinfo kbsqlserv2000sp1fix kbmt KB299641 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:299641

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

 

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