microsoft sql server 2016 on vmware vsphere 6 …...microsoft sql server 2016 on hyper converged...

Microsoft SQL Server 2016 on

Hyper Converged Infrastructure

using VMware vSphere 6 T E C H N I C A L W H I T E P A P E R

VMware, Inc. 3401 Hillview Avenue Palo Alto CA 94304 USA Tel 877-486-9273 Fax 650-427-5001 www.vmware.com

Copyright © 2016 VMware, Inc. All rights reserved. This product is protected by U.S. and international copyright and intellectual property laws. VMware products are covered by one or more patents listed at http://www.vmware.com/go/patents. VMware is a

registered trademark or trademark of VMware, Inc. in the United States and/or other jurisdictions. All other marks and names mentioned herein may be trademarks of their respective companies.

Microsoft SQL Server 2016 on Hyper Converged Infrastructure using VMware vSphere 6

Executive summary .......................................................................................................................................... 3

Introduction ...................................................................................................................................................... 3

HPE Hyper Converged 380 family .............................................................................................................. 4

Solution overview ............................................................................................................................................. 4

Solution components ....................................................................................................................................... 6

Hardware .................................................................................................................................................... 6

Software ...................................................................................................................................................... 8

Application software .................................................................................................................................... 8

Best practices and configuration guidance for the solution .............................................................................. 8

Capacity and sizing ................................................................................................................................... 10

Scale-up scenario ..................................................................................................................................... 10

Scale-out scenario .................................................................................................................................... 12

Consolidation scenario .............................................................................................................................. 14

Analysis and recommendations ................................................................................................................ 18

Summary ....................................................................................................................................................... 19

Resources and additional links ...................................................................................................................... 19

http://www.vmware.com/go/patents





Executive summary

Target audience:

Document purpose:

Introduction






HPE Hyper Converged 380 family

Solution overview

Figure 1.






Resources and

additional links

Figure 2.






Figure 3.

Solution components

Hardware

4 HC 380 Nodes






Figure 4.

Figure 5.

Figure 6.






Software

Application software

Best practices and configuration guidance for the solution

Resources and additional links






Resources and

additional links

” Resources and additional links






Capacity and sizing

Scale-up scenario

Table 1.

Drive Used for VSA Volume Name Adaptive Optimization SIZE






Figure 7.






Table 2.

VM Core/memory Database size Batch requests/sec -k value

Figure 8.

Scale-out scenario

0

5000

10000

15000

20000

25000

16 vCPU/32 GBRAM

32 vCPU/64 GBRAM

40 vCPU/156 GBRAM

64 vCPU/256 GBRAM

Ba

tch

Req

ue

ts/S

ec

Scale-up Results






Table 3.

Drive Used for VSA Volume Name Adaptive Optimization Size

Figure 9.






Figure 10.

Consolidation scenario

Table 4.

Drive Used for VSA Volume Name Adaptive Optimization Size

0

5000

10000

15000

20000

25000

30000

35000

40000

45000

No of VMs = 1 No of VMs = 2 No of VMs = 3 No of VMs = 4

Ba

tch

Re

qu

ests

/Se

c

Scale-out

IOPS Batch Requests/Sec






Figure 11.

Tier 0 consolidation case

Table 5.

No. of VMs VM Core/memory Database size Batch requests/sec -k Value






Multi-tier consolidation case

Storage

enabled

disabled

Figure 12.






Memory

Figure 13.






Analysis and recommendations






Summary

Resources and additional links HPE Hyper Converged systems

hpe.com/info/hyperconverged

https://www.hpe.com/us/en/product-catalog/convergedsystems/hyper-converged/pip.hyper-converged-

300.1008591219.html

http://h20564.www2.hpe.com/hpsc/doc/public/display?docId=c05102727

http://h20195.www2.hpe.com/V2/GetDocument.aspx?docname=4AA4-9000ENW


hpe.com/info/RA

hpe.com/servers

hpe.com/storage

hpe.com/networking

hpe.com/us/en/services/consulting.html

https://h20195.www2.hpe.com/V2/getpdf.aspx/4AA6-7774ENW.pdf?ver=1.0

vmware.com/content/dam/digitalmarketing/vmware/en/pdf/solutions/sql-server-on-vmware-best-practices-

guide.pdf

https://msdn.microsoft.com/en-us/library/ms189573.aspx


http://www.hpe.com/info/hyperconverged

https://www.hpe.com/us/en/product-catalog/convergedsystems/hyper-converged/pip.hyper-converged-300.1008591219.html

https://www.hpe.com/us/en/product-catalog/convergedsystems/hyper-converged/pip.hyper-converged-300.1008591219.html


http://h20195.www2.hpe.com/V2/GetDocument.aspx?docname=4AA4-9000ENW


http://www.hpe.com/info/RA

http://www.hpe.com/servers

http://www.hpe.com/storage

http://www.hpe.com/networking

http://www.hpe.com/us/en/services/consulting.html

http://www.vmware.com/content/dam/digitalmarketing/vmware/en/pdf/solutions/sql-server-on-vmware-best-practices-guide.pdf

http://www.vmware.com/content/dam/digitalmarketing/vmware/en/pdf/solutions/sql-server-on-vmware-best-practices-guide.pdf

https://msdn.microsoft.com/en-us/library/ms189573.aspx





About the Authors

D.S Ravishankar, SQL Engineer, HPE Maurice De Vidts, Lead SQL Engineer, HPE Kannan Mani, Principal Product Manager – Data Platforms, HPE Niran Chen Evan, Staff Solutions Architect, VMware Deji Akomolafe, Staff Solutions Architect – Microsoft Applications Lead, VMware Don Sullivan, Product Line Marketing Manager for Business Critical Applications, VMware

Acknowledgements

The authors thank Scott Salyer (VMware), Joe Sullivan, Don Wilson, Kimberly Kato, Said A. Syed, Rudy Castillo, Jodie Jordanger and Janet Runberg (HPE)


microsoft sql server 2016 on vmware vsphere 6 …...microsoft sql server 2016 on hyper converged...

Documents