ʹѺʹع SQL Server ҾǴ hyper ô

ź ź
Ţ (Article ID): 322385 - ԵѳǢͧ㹺
· | غ

Һ˹ҹ

й

͸Ժ¡ʹѺʹعͧ SQL Server 㹡 ҾǴ hyper ô

ѡ ͡Ẻͧ SQL Server зӧҹҾǴ hyper ô ҧá ҤسѧҾǴ hyper ô Ңйӷس ӵ仹:
  • ¡ Microsoft SQL Server 2000 Service Pack 3 (SP3) 蹷
  • Դ駡ûѺاʹش
кԺѵԡ Microsoft Windows Cpu hyper ôẺͨԤŻҡ Cpu ԧ ͧҡ SQL Server дѺ٧ö͢ Cpu SQL Server ö ǻż

ѺǡѺ Microsoft Windows ʹѺʹعͧ 䫵仹ͧ Microsoft:
http://www.microsoft.com/whdc/system/sysinternals/ht-windows.mspx

سͧѧ 仹ͤسѧԨóҡûѺô hyper:
  • ͹حҵԷ
  • ǻż
  • ԷҾ÷ӧҹ
  • CPU ͧ Intel öªõǨѺ
ǡѺԹ¡õ仹

͹حҵԷ

ʹԴ 鹰ҹԹصҷصк (BIOS) Ѻѵǹͧ CPU ԧ ҹѨغѹ¡ 2:1 ¤ ͧ (2) ẺͨԤ Cpu Ѻ CPU ԧ ¡ҹҨ¹ŧ͹Ҥ ҧá Microsoft SQL Server 2000 Service Pack 3 (SP3) 蹷ԷҹѺاͨӡѴ͹حҵԷͨѴáѺѵǹ ҧ ʼԵѳ SQL Server سԴ͹حҵԷҹ CPU 4 ѵ 2:1 蹢ͧ SQL Server 2000 SP3 蹷ҧ Ѿവ Ъس Cpu 8

ͤسԴ SQL س㹡õǨѺ CPU ԧ ѴáѺ SQL Server ŧѵǹ 㹷ҧç ͤس駤ҵ͡ٻẺѹس CPU ẺͨԤͧҡ SQL Server Cpu ͧǻżŷԧ

Ѻ ͹حҵԷ ѺʹѺʹعõ駤Ҥ͹ԡ´ ô Microsoft 仹 䫵:
http://www.microsoft.com/sql/howtobuy/default.mspx

ǻż

¤ SQL Server ҧèѴẺͨԤż˹ ǨѴ˹ (UMS) Ѻеǻżŵ觢ͧǻż"30th" hyper ôкԴҹ Microsoft Windows ǻżŷ ҹѺкǹ SQL Server ͧҡյǻżŷҧҾԧ A ҧ ͧá 绵ǻżŷҧҾ١ʴ㹢ͤ仹 ҧ

ҧǻż 1
غҧµҧ
áԧ
00
11
22
33
40
51
62
73
͵ҧ绵ǻż

ǻż 绵ҧ 2
غҧµҧ
áԧ
00
10
21
31
42
52
63
73
ҧҧ˹觤ѺѺ SQL Server ҧá ѧ ͵ͧҧʶҹóӡѴҴԴѺ SQL Server ա CPU ԧͤҴҨ Cpu ԧ

س ö͡ʡѹͧ SQL Server ͵ͧ¹ŧҧҾҴ ҹǻż ͵ͧ÷蹹 ٵҧǻż 1 Ҥѹ ٻẺ 00010001 ǻż 0 еǻż 4 ẺͨԤ ǻżŷѺҧҧҾ #0 觼šǻżŷԧǷʹѺʹعͧẺͨԤ ǻż᷹繵ǻżͧǷԧ ʶҹóҨ ŴԷҾ÷ӧҹ

سöѹͧٻẺѹ ͡о鹢ͧٻẺѹ IO ͵ͧ¹ ѡɳС÷ӧҹ ѺǡѺ͡ʡѹ IO ѹʡ SQL Server Books Online

Ѻ ԡŢ仹ʹٺ㹰ҹͧ Microsoft:
298402÷ӤǡѺԸաõ駤 SQL ͡ѹͧ I/O ͧ
͹ ѴѧͤسҧٻẺѹ سöҧ´ 駤Ҥ͹ԡٻẺѹ١ͧ ǻżŷҧҾǡѹѺ ʹѺʹعǻżẺͨԤŷͧͤسͧҧҾ¡ҧҡ ǻż

ԷҾ÷ӧҹ

ԷҾͧҾǴ hyper ôᵡҧѹ ÷ͺ Conservative ʴ 10 ֧ 20 繵ѺŴ SQL Server ٻẺͧ;पѹռչӤѭ سҨ ءҧѺԷҾ÷ӧҹ ¡ªҡ ͧ ҵǻżŷҧҾ saturated ǻżẺͨԤöŴҳҹԧ

Ѻ ҧ ͻपѹ˵ط͢ѴдѺ٧Ŵŧ ԷҾ÷ӧҹҾǴ hyper ô Ңй سͺͧس ;पѹҧ´ ҾǴ hyper ô ԷҾ÷ӧҹͧسѺسͧºѺëͧ͢ºҡѺ Cpu ԧ -ô Hyper 繻ªҡ ᷹ѧҹͧ CPU ԧ

Եѳͧѷ蹷Ƕ֧㹺 繼ԵѳԵºѷ ǢͧѺ Microsoft Microsoft ѺСѹ¹ٻẺ ǡѺԷҾͤͶͧ͢Եѳҹ

Intel 䫵բźҧҧ к͹ǡѺ (Intel NetBurst microarchitecture) Ѻ ǡѺкʹѺʹع Intel 䫵仹:
http://software.intel.com/en-us/blogs/2009/06/02/intel-hyper-threading-technology-your-questions-answered

http://developer.intel.com


дѺ٧شͧ parallelism (MAXDOP)

CPU hyper ôй CPU invalidation ѭҷ价辺ҹŵԧ ҳҹͧ;पѹռŵ͡ûԷҾС÷ӧҹᤪͧ CPU Ңй سͺҳ;पѹҡ¢ͧõ駤MAXDOP ԷҾ÷ӧҹѺҨѺ MAXDOPõ駤ҷԹӹǹͧǻżŷҧҾա Ҥسѧ NUMA õ駤ҡõ駤MAXDOPͧԹӹǹͧ Cpu ˹ NUMA ҧ աá˹кѺǻżͧǷԧеǻżẺͨԤŷ õ駤MAXDOP 2 Ѻ ԡŢ仹ʹٺ㹰ҹͧ Microsoft:
2023536 йǷҧѺ͡õ駤Ҥ͹ԡ 'дѺ٧شͧ parallelism'

سѵ

Ţ (Article ID): 322385 - Ǥش: 18 Ҥ 2556 - Revision: 4.0
Ѻ
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 64-bit Edition
  • Microsoft SQL Server 2000 Developer Edition
  • Microsoft SQL Server 2000 Enterprise Edition
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2000 Workgroup Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL 2005 Server Enterprise
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Evaluation Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Express Edition with Advanced Services
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium Based Systems
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL 2005 Server Workgroup
  • Microsoft SQL Server 2008 Developer
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Enterprise Evaluation
  • Microsoft SQL Server 2008 Express
  • Microsoft SQL Server 2008 Express with Advanced Services
  • Microsoft SQL Server 2008 R2 Developer
  • Microsoft SQL Server 2008 R2 Enterprise
  • Microsoft SQL Server 2008 R2 Express
  • Microsoft SQL Server 2008 R2 Express with Advanced Services
  • Microsoft SQL Server 2008 R2 Parallel Data Warehouse
  • Microsoft SQL Server 2008 R2 Standard
  • Microsoft SQL Server 2008 R2 Standard Edition for Small Business
  • Microsoft SQL Server 2008 R2 Web
  • Microsoft SQL Server 2008 R2 Workgroup
  • Microsoft SQL Server 2008 Reporting Services
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Standard Edition for Small Business
  • Microsoft SQL Server 2008 Web
  • Microsoft SQL Server 2012 Business Intelligence
  • Microsoft SQL Server 2012 Developer
  • Microsoft SQL Server 2012 Enterprise
  • Microsoft SQL Server 2012 Express
  • Microsoft SQL Server 2012 Standard
  • Microsoft SQL Server 2012 Web
  • SQL Server 2012 Enterprise Core
Keywords:
kbinfo kbmt KB322385 KbMtth
¤
Ӥѭ: «ͿŴ¤ͧ Microsoft ᷹繹ѡŷ繺ؤ Microsoft պ¹ѡкŴ¤ سöҶ֧㹰ҹͧ Ңͧسͧ ҧá Ŵ¤Ҩբͺͧ ҨբͼԴҴ㹤Ѿ ٻẺҡó ǡѺóշǵҧҵԾٴԴ;ٴҢͧس Microsoft ǹѺԴͺͤҴ͹ ԴҴͤ·ԴҡҼԴҴ ͡麷Ţͧ١ Microsoft աûѺاͿŴ¤繻Ш
仹繩Ѻѧɢͧ:322385

ʹ

 

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