続きを読む（PDF 392KB）
Contents
1. SQL Server 1 0 DL580 Gen8 Xeon5 E7 v2 I 0 DDIO Data Direct 0 PCI Express 0 3096 CPU PCI I 02. Intel Atom Intel Atom Inside Intel Core Core Inside Intel vPro vPro Intel Inside Intel Inside Intel Intel Inside Celeron Celeron Inside Itanium Itanium Inside Pentium Pentium Inside Xeon Xeon Phi Xeon Inside Ultrabook Intel Corporation 2014 7 Copyright 2014 Hewlett Packard Development Company L P 136 8711 2 2 1 WPC13620 01
3. 11213 51617 48 T2415 61718 CPU 1 CPU 2 CPU 3 CPU 4 NUMA 0 NUMA 1 NUMA 0 NUMA 1 Xeon E7 V2 1 NUMA NUMA 3 500 Transaction 5 sec 3 000 2 500 2 000 1 500 1 000 500 0 1 2345678 91011121314151617 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 2 30 NUMA 4 60 NUMA NUMA HP 3 Xeon E7 v2 HP ProLiant DL580 Gen8 4 60
4. CPU VHD Virtual Hard Disc SSD 7 SQL Server SQL Server 2008 R2 Plan Cache Memory Object Optimizer Memory Database Buffer Page Cache Pool SQL Server 2012 Plan Cache Memory Object Memory Backup Buffers Clerk Database Buffer Pool Page Cache Memory Clerk Backup Buffers Clerk NUMA Memory Node VirtualAlloc and AWE API NUMA Memory Node Fragment Manager Virtual Block Allocator Allocator Workspaces VirtualAlloc and AWE API 8 OLTP HPProLiant DL580 Gen8 9 Xeon E7 4890 v2 2 8GHz 4P 60C 2200 Thread NUMA_on SMT_off Microsoft9SQL Server 2014 Datacenter x64 CU1 HP ProLiant DL580 G7 Xeon
5. Hyper V SQL Server NUMA SQL Server NUMA SMP NUMA NUMA DL 580 Gen8 Hyper V SQL Server NUMA 2 30 2 SQL Server NUMA SQL Server 2 NUMA
6. 2 4 60 2 4 Hyper V NUMA 1 Oemeariry 0 TEM OTE YT VitTemeed ou FOBRMOG ET 0 RIO EE ET EE 2 OC PRET ou rt FO TET ST em tS BT SCLC ire FREERID WT sm SE RNN a Vy 1 3 NUMA NUMA CPU 1 CPU 2 CPU3 CPU 4 4 60 NUMA CPU 1 CPU 2 2 30 NUMA CPU 1 CPU 2 CPU 1 CPU 2 CPU3 eu zZ 30 2 30 NUMA NUMA NUMA SQL Server 3
7. 4 60 1 4 60 2 2 30 3 2 30 4 3 2 30 2 Web NUMA NUMA NUMA 2 30 2 30 2 30
8. 0 2 I 0 0 I 0 tempdb 0 NUMA NUMA 1 SQL Server SQL Server 2008 R2 1 SQL 0S SQL 05 SQL Server 2012 R2 Windows 05 0 SQL 0S SQL 05 1 0S SQL Server I 0 0
9. 1 SQL Server 2008 R2 0S SQL Server 8K 2M 2 2012 2012 A EN A 6 CPU I 0 9 Xeon E7 v2 Xeon E7 9 Xeon E7 v2 BLOB 1 SQL Server 2014 OLTP
10. SQL Server 4 60 CPU CPU Microsoft SQL Server 1 CPU MAX DOP CPU 1 1 2 tempdb tempdb Microsoft5 SQL Server CPU tempdb
11. SQL Server 2014 Xeon E7 v2 HP ProLiant DL580 Gen8 NUMA HP ProLiant DL580 Generation8 Gen8 4 60 Xeon E7 v2 6TB HP 3 HP ProLiant DL580 Gen8 Hyper V Microsoft SQL Server 2014 2 NUMA Hyper V saLserver stsewer Windows Server amp Hyper V Host
12. Microsoft SQL Server 2014 NUMA NUMA vNUMA Microsoft9 SQL Server Microsoft5 SQL Server HP ProLiant DL580 Gen8 NUMA Hyper V 2 4 2 NUMA 2 NUMA 4 NUMA 240 900 5 3 000
13. Hyper V 2 Hyper V Guest NUMA NUMA NUMA 4 NUMA 1 1 Hyper V NUMA SQL Server NUMA 5 SQL Server NUMA Hyper V
14. 2 30 NUMA 2 30 NUMA 1 4 Microsoft5 SQL Server NUMA 15 Xeon E7 4890 v2 2 8GHz 4 60 HP ProLiant DL580 Gen8 Microsoft Windows Server 2012 Datacenter R2 Microsoft SQL Server 2014 Enterprise Edition CU1
15. E7 4870 2 4GHz 4P 40C 1200 Thread NUMA_on SMT_off Microsoft SQL Server 2008 R2 Enterprise HPProLiant DL580 Gen8 Xeon E7 4890 v2 2 8GHz 4P 60C 2200 Thread NUMA_on SMT_off Microsoft9SQL Server 2014 Datacenter x64 CU1 HP ProLiant DL980 G7 Xeon E7 8870 2 4GHz 8P 80C 2400 Thread NUMA_on SMT_off Microsoft9SQL Server 2008 R2 Datacenter x64 CU6 1 235 83 trans sec 756 08 trans sec 1 235 83 trans sec 1 110 61 trans sec OLTP 4 60 Xeon E7 v2 DL580 Gen8 4 40 Xeon E7 DL580 G7 1 64 8 80 Xeon E7 DL 980 G7 4 60 Xeon E7 v2 DL5
16. NUMA 2 2 NUMA 2 NUMA 2 30 CPU CPU 50L Server SQL SQL Server 5 CPU
17. 80 Gen8 HP ProLiant DL580 Geng 0 200 400 600 800 1000 1200 1400 1600 DL580 Gen8 1 11 HP ProLiant DL580 Gen8 9 Xeon E7 v2 Microsoft SQL Server 2014 Microsoft SQL Server 2014 En
18. terprise Edition CU1 0S Microsoft Windows Server 2012 Datacenter R2 2TB 4 60 Xeon E7 4890 v2 2 8GHz HP ProLiant DL360 Geng Microsoft5SQL Server 2014 Enterprise Edition CU1 0S Microsoft9Windows Server 2012 Datacenter R2 128GB 2 20 Xeon E5 2690 v2 3 0GHz A FE 03 5749 8330 9 00 19 00 10 00 17 00 5 1 HP ProLiant http www hp com jp proliant
Download Pdf Manuals
Related Search