INF: ??? ????? ????? ???? Affinity I/O ???? SQL

?????? ????????? ?????? ?????????
???? ???????: 298402 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

??????

????? ??? ?????? ?? ??????? I/O ?????? ??????? ?????? ??????? I/O ???? ????? ?? SQL Server 2000 ?????? ????? ?????? SP1 ?? ????? ????. ?? ???? ??????? ??? ?????? ?????? ???? (OLTP) ? ?? ???? ?????? ??????? I/O ????? ?????? ?? ????? SQL Server ????? ? ????? ??????? ???? ???? ??? ????? ????????? ??? ????? ???????? ???????? (CPU 16 ?? ????). ??? ?????? ????? ????? SQL Server ?? ?????? ???????/??????? ??? ? ?? ????? ?? ??????? ??????? ??????? ??????? ?? ????? ?????? ?????.

??????? ????

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

???? ??????? ???? ??????? ??????? ?? ??????? sp_configure ????? ???? ?? ?????? ????? ????? ???????? ???????? (CPU) ??? ???? ??????? ????? ????????? ?????? ????????? ????? ?????? ??????? ?? ???? SQL Server. ????? ??????? ???? ??????? ???? ??????? ???????? ?????? ??????? SQL Server ?? ????????? ???? ???? ???????? ?????? ???? ???????. ????? ?? ????????? ??? ???? ???? ??????? ???? SQL Server 2000 ????????. ????? ?????? IO_affinity_mask ???? ?? ?????? ????? ????? ???????? ???????? (CPUs) ???? ?? ??????? ?????? ?????? ??????? SQL Server ???????? ?????? ???????/???????.

??? ????? ???? SQL Server ??? ????? ????????? ??? ????????? ???????? ????? ?? ????? ??????? ?? ????? ???????? ???????? (CPU) ???? ?? 16 ?? ??????? ????? ?????? ?????? ???????? ??? ??????? IO_affinity_mask ????????? ?? ?????? ???? ???????. ???? ??? ??????? ????? ???? ??? affinitized ????? ???????? ???????? (CPU) ??????? ????? SQL Server ???? ????? ???????? ???????? (CPU) ???? ?????? ???????? ???????? ?? SQL Server.

?? ???? ??????? ???????, ?? ??? IO_affinity_mask ?? ????????? ????? ?? ????? ??????? ?? ???? ????. ?? ???? ??? ????? ???? ????? ?????? ?????? ????? ?????? IO_affinity_mask.

????? ????? ?????? ???? ??? ????? ??? ???????? ??????? CPU ??? ??? ????? ????? ???????? ???????? (CPU) ????? ?????? IO ????? SQL Server ???? ?? ?????? ?? ????? ???????? ?????/????? ?????. ???? ?????? ?????? ???? ????? IO ?? ??? ????? ??? ?? ????? ????? ???????? ???????? (CPU ???) ??? SQL Server ?????? ?????/????? ????? ?? ?????? ?? ????? ???????? ?????/????? ?????.

?????? ?????? IO_affinity_mask ??? ????? ????? ????? ???? ?????? ?????? ??? ????? SQL Server ?? "????? ??????? ?? ??? ??? ??????? sqlservr. (??????? ??? ?????? ?? ????? ??????? sp_configure ???????.) ??? ???? ??????:

-I<IO_affinity_mask>

??? ???? ??????? ??? IO_affinity_mask ???:

  • ????? ????? ????? ???????? ???????? (CPUs) ?? ??????? ????? ????????? ??????? ?????? ?????? ?????/????? ????? SQL Server.
  • IO_affinity_mask ?? ??? ???? ???? ?????? ?? (??? ???? ?????? ???? ???? ?? ????? ???????? ???????? (CPU)) ??????? ?? ???? ????? ?????? ?? '0 x' ?? ' 0 X '.
  • ???? ????? ???? ???? ???? ??????? ???? ?????? CPU(0) ????? ???? ??????, ???? ???? ??????? ???? ?????? ?????? CPU(1) ??????? ?????? ?????? ?????.
  • ???? ???? ???? IO_affinity_mask ????? ???????? ???????? (CPUs) ??? 8 ?? ????? ????????? ???? ???? ????? ???? ????? ???????? ???????? (CPU) ??? 16 ???? ???? ???? ???? ????? ???????? ???????? (CPU) ??? 24 ? ???? ???? ???? ???? ????? ???????? ???????? (CPU) ??? 32.
  • ????? ?? ???? ?? ????? ?? CPU ??????? ??????? ?????? ?????? ?????/????? ????? SQL Server; ????? ?? ??? ??? ?? ?????? ???????/??????? ????? SQL Server ??? ????? CPU ???????.
  • ????? ??? ????? ?? ???? ??? 0 ?? ?? ??? ????? IO_affinity_mask ??? ????? ?????/????? ????? SQL Server ??? ?? ?? ????? ???????? ???????? (CPUs) ???????? ??????? ?????? ?????? ??????? SQL Server.
  • ?? ???? ????? ???? ????? ??????? IO_affinity_mask ????? ????? SQL Server. ?????? ??? ??????? IO_affinity_mask ???? ??? ????? ????? ???? SQL Server ?? ?? ????? ?????? ?? ???? ????? ?????? IO_affinity_mask.
???? SQL Server 2000 ?? IO_affinity_mask ???? ??????? ???? ???? ??? ?? ???? ???????.

?? ???? ????? ??? ??????? IO_affinity_mask ????? Microsoft ??????? ????????? ?? ?????? ????? ???? ???????. ???? ?? ??? ????? CPU ??? IO_affinity_mask ??????? ? affinity_mask ??????.

??? ?? ???? ????? ???? ???? ????? ?? CPU ?? ???? ????? ??????? ???????:
  • 0 ?? ?? ?? ??? ??????? IO_affinity_mask ?????? ???? ???????.
  • 1 ?? ????? ??????? IO_affinity_mask ? 0 ?? ?????? ???? ???????.
  • 0 ?? ????? ??????? IO_affinity_mask ? 1 ?? ?????? ???? ???????.
????? ? ?? ???? ???????? ???? 32 ??????? ???? ????? ??????? SQL Server ???? ????? ??????? ??????:
  • SQL Server ???????? 24 ?? ????? ???????? ???????? (CPUs 32) ???????? ????????.
  • ????? ????? ???????? ???????? (CPU) 8 ??? ????? SQL Server IO ? ????? ???????? ???????? (CPU) 16 ???????? SQL Server ????.
?????? ??? ??????? ?????? ??????? ???????:
  1. ????? ???? ???? ??????? ?????? SQL Server ????? ???????? ???????? (CPU) 16 ???????? SQL Server ??? ????? I/O:
      sp_configure "affinity mask", 0x0000FFFF
      go
      reconfigure with override
      go
    					
  2. ????? ????? SQL Server.
  3. ??? ????? ???? SQL ?? ????? ??????? ??????. ??? ????? SQL Server ???????? ????? ???????? ???????? (CPU) 8 ??????? "/ ??????? ??? ?????":
      sqlservr -I0x00FF0000
    					
????? ???? SQL ????? ???? ? ???? ??????? ??? ????? ?????????? ? ??? ?? ???? ?? ??? ?????? Microsoft SQL Server Always-On ??????? ???? ??????. ??????????? ?? ????????? ??? ??????? ??????? ???? ????? ?????? SQL Server "? ???? ??? ??? ??????? ?????? ?????? ??" ????? ??????? ?? Microsoft:
967576??????? ???????/??????? ???? ????? ?????? ???? Microsoft SQL

???????

???? ???????: 298402 - ????? ??? ??????: 14/????/1428 - ??????: 1.3
????? ???
  • Microsoft SQL Server 2000 Service Pack 1
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Standard
????? ??????: 
kbmt kbproductlink kbinfo kbsqlserv2000sp1fix KB298402 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????298402

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

 

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