BizTalk 2009: Performance Characteristics on Hyper-V and Physical Platforms

1. BizTalk 2009: Performance Characteristics on Hyper-V and Physical Platforms Ewan Fairweather & Paolo Salvatori Customer Advisory Team Microsoft

2. Quantify BizTalk Server 2009 performance vs. BizTalk Server 2006 R2 Quantify performance of BizTalk Server 2009 on “Hyper-V” Provide guidance on how to effectively performance test BizTalk 2009 Session Objectives

3. Background Goals Use cases R2 vs. 2009 Performance Comparison Optimizing platform Optimizing application design Hyper-V Performance Conclusion Session Agenda

4. CSD CX Field Engagement Teams CX Field Engagement Teams Institutionalized services delivered by specialized product team to support field and partner resources in the sale, delivery and on-going support of BizTalk projects Field PM Customer Advisory Team Customer Response Engineering • Opportunity development • Sales Assistance • Readiness and Training • POC, Pilot • Virtual TS team • ADS • District Planning • Reactive services • Proactive Services • Architecture Design Review • Operational Readiness Review • Performance and Stability Review • Field Services Enablement • Key Learnings • Product Escalations • QFE & DCR • Service Packs • Beta Support • Serviceability Field and Partner Resources MCS, PFE, Partners, Virtual TS TS & SSP Partners, Virtual TS CSS, Premier Field Engineering, Partners 4

5. All Guides are published to: MSDN, Download Center End to end samples: Sample application BizUnit scripts LogParser scripts Visual Studio Load Tests Field Services Enablement Product Release Cycle Beta RTM RTM + 90 CAT & UE 4 Deliver ADR to TAP Customers Enterprise Customer Engagements Deliver MSDN Operational Guidance 2 1 Performance and Hyper-V Boot Camp Deliver MSDN Hyper-V Guidance 3 Denotes investment Deliver MSDN Performance Guidance Denotes delivery

6. The usual story We all know testing is important for every solution Testing is neglected This is a problem Solutions using BizTalk tend to be business critical and tolerate little downtime Poor testing increases the risk profile of your project This runs the risk of huge technical and political problems Our labs have shown you can double performance if you are careful Assessing Application Performance

7. Background Goals Use cases R2 vs. 2009 Performance Comparison Optimizing infrastructure Optimizing application design Hyper-V Performance Conclusion Session Agenda

8. Technical Goals: Quantify BizTalk Server 2009 (2009) vs. BizTalk Server 2006 R2 (R2) Quantify performance of BizTalk Server 2009 on “Hyper-V” Use Case 1: Logical Ports WCF Orchestration scenario Use Case 2: Inline Sends Orchestration Scenario Conditions: Perform optimizations on 2009, R2, Hyper-V Determine delta of: Throughput # of calls within 8 hours Latency Identical infrastructure for all platforms Apply infrastructure optimizations first, then application optimizations BizTalk 2009 Performance Lab Goals

9. Background Goals Use cases R2 vs. 2009 Performance Comparison Optimizing infrastructure Optimizing application design Hyper-V Performance Conclusion Session Agenda

10. Inline Sends and Logical Ports Logical Port Orchestration Vs. Inline Sends Orchestration

11. Code Walk-Through Demo Inline Sends and Logical Ports examples

12. Session Agenda • Background • Goals • Use cases • R2 vs. 2009 Performance Comparison • Optimizing platform • Optimizing application design • Hyper-V Performance • Conclusion

13. Lab Hardware Kit - Overview 8 9 1 3 5 7 2 4 6

14. Detailed SAN Configuration 3 2 1

15. R2 vs. 2009 Performance Comparison Vs. 1 2 3

16. They are grouped into the following categories: Platform Optimizations SQL Server Optimizations: General (all SQL Servers) SQL Server Optimizations: BizTalk Databases BizTalk Optimizations If appropriate: SQL Server Optimizations: Custom Databases Platform Optimizations

17. ~27% throughput improvement R2 ~77% throughput improvement 2009 *Excessive dehydration was occurring, dehydration settings were non-optimal for 64 bit host ~25% latency improvement R2 ~45% latency improvement 2009 Optimizing Platform Results Summary 1 2 3 4 7 8 5 6

18. Counters to use: Process\Virtual Bytes VirtualMemoryThrottlingCriteria Process\Private Bytes PrivateMemoryThrottlingCriteria Troubleshooting Dehydration 1 2

19. Perfmon: Virtual & Private Bytes 1 2

20. Default <xlangs> <Configuration MaxThreshold="1800" MinThreshold="1" ConstantThreshold="-1"> <Dehydration> <VirtualMemoryThrottlingCriteriaOptimalUsage=“900" MaximalUsage=“1300" IsActive=“true" /> <PrivateMemoryThrottlingCriteriaOptimalUsage="700" MaximalUsage="1000" IsActive="true" /> <PhysicalMemoryThrottlingCriteriaOptimalUsage="700" MaximalUsage="1000" IsActive="false" /> </Dehydration> </Configuration>  </xlangs> Optimized <xlangs> <Configuration MaxThreshold="1800" MinThreshold="1" ConstantThreshold="-1”> <Dehydration> <VirtualMemoryThrottlingCriteriaOptimalUsage="6000" MaximalUsage="6300" IsActive="true" /> <PrivateMemoryThrottlingCriteriaOptimalUsage="700" MaximalUsage="1000" IsActive="true" /> <PhysicalMemoryThrottlingCriteriaOptimalUsage="700" MaximalUsage="1000" IsActive="false" /> </Dehydration> </Configuration>  </xlangs> Optimizing Dehydration

21. Dehydration Optimization Summary 1 2 3 4 5 7 6 • Tuning dehydration settings on 64 bit host: • Improved throughput by 27% (R2) • Improved throughput by 33% (2009)

22. Background Goals Use cases R2 vs. 2009 Performance Comparison Optimizing platform Optimizing application design Hyper-V Performance Conclusion Session Agenda

23. Optimizing Application Results Summary 1 2 3 4 7 8 5 6

24. Background Goals Use cases R2 vs. 2009 performance comparison Optimizing platform Optimizing application design Hyper-V Performance Conclusion Session Agenda

25. VHD - single file sits on root NTFS volume Fixed, Dynamic, Differencing Pass-through – exclusive disk access to guest Root Partition Child Partition Child Partition Server Server VSPs VSPs I/OStack I/OStack I/OStack OS Kernel Enlightenments (WS08+) Drivers VSCs VSCs VMBus VMBus VMBus Shared Memory Hypervisor Devices Processors Memory Hyper-V Architecture 1 3 2 4 5

26. License required for each physical processor License for each virtual processor in each virtual operating system Exception: BizTalk Enterprise Edition License for the number of physical processors in the server Enables unlimited Virtual Processors http://www.microsoft.com/biztalk/en/us/pricing-licensing-faq.aspx BizTalk Virtualization Licensing

27. Physical BizTalk 2009 vs. Hyper-V BizTalk 2009 Comparison Tier Vs. • Physical and Hyper-V BizTalk Servers part of the same Group

28. Hyper-V provides ~87% throughput* Hyper V ~15% worse latency* *Note: Calculated from Logical Ports Test Hyper-V Results To Complete 1 2 3 4 8 5 7 6

29. Virtual Processor Allocation 1 to 1 Mapping Overload Scenario 1 2 BizTalk Server BizTalk Server BizTalk Server BizTalk Server BizTalk Server BizTalk Server BizTalk Server BizTalk Server Virtual Processors Virtual Processors Virtual Processors Virtual Processors Virtual Processors Virtual Processors Virtual Processors Virtual Processors 0 0 0 0 0 0 0 0 1 1 1 1 1 2 3 1 2 3 Logical Processors Logical Processors 0 0

30. To measure Guest processors: \Hyper-V Hypervisor Virtual Processor(*)\% Guest Run Time \Hyper-V Hypervisor Virtual Processor(*)\% Total Run Time To measure Physical processors: \Hyper-V Hypervisor Logical Processor(*)\% Total Run Time To measure Host processors: \Hyper-V Hypervisor Root Virtual Processor(*)\% Total Run Time Processor Lessons Learned

31. For VHDs use: <RootPartition>\Logical Disk(*)\Avg. sec/s <RootPartition>\Logical Disk(*)\Avg. sec/Write <Guest>\Logical Disk(*)\Avg. sec/Read <Guest>\Logical Disk(*)\Avg. sec/Write For PassThrough Disk Analysis use: “Hyper-V Virtual Storage Device” counters xPerf Tool http://msdn.microsoft.com/en-us/library/dd871252.aspx Disk Lessons Learned

32. Pass-Through Disk Perf * Other factors such as SAN performance could have been a factor

33. Use PassThrough disks for high disk I/O: BizTalk MessageBox Database BizTalk Tracking Database BizTalk File Adapter %temp directory if BizTalk is streaming large files Disk Lessons Learned

34. Virtual machines require non-paged memory (physical memory) Ensure you have enough physical memory on both the host and guest computers Use Traditional Counters: <RootPartition>\Memory\Available Mbytes <Guest>\Memory\Available Mbytes <RootPartition>\Memory\Pages/sec <Guest>\Memory\Pages/sec Memory Lessons Learned

35. For high network I/O: Use a 1:1 mapping of physical to virtual network adapters For measuring network adapters use: <RootPartition>\Network Interface Bytes Total Per Second Output Queue Length <RootPartition>\Hyper-V Virtual Network Adapter Bytes Per Second <RootPartition>\Hyper-V Virtual Switch Network Lessons Learned

36. MSDN http://msdn.microsoft.com/en-us/library/cc558617.aspx BizTalk Server Performance Optimization Guide

37. BizTalk BPA 1.2 PerfMon LoadGen BizUnit Log Man Relog Log Parser PAL SQLIO BizTalk Orchestration Profiler Helpful Tools

38. Reduce costs and expenses Win market share from expensive competitors Optimize to do more with less! Delight our customers Why Tune BizTalk Now - More than Ever?

39. Q & A

40. BizTalk Server 2006: Managing a Successful Performance Lab http://msdn2.microsoft.com/en-us/library/aa972201.aspx Scaling Your Solutions http://msdn2.microsoft.com/en-us/library/aa561567.aspx Configuration Parameters that Affect Adapter Performance http://msdn2.microsoft.com/en-us/library/aa561380.aspx Persistence and the Orchestration Engine http://msdn2.microsoft.com/en-us/library/aa547090.aspx Troubleshooting MessageBox Latency Issues http://msdn2.microsoft.com/en-us/library/aa561709.aspx Performance Tips and Tricks http://msdn2.microsoft.com/en-us/library/aa560694.aspx Rule Engine Configuration and Tuning Parameters http://technet.microsoft.com/en-us/library/aa548008.aspx Performance Considerations When Using the Rule Engine http://msdn2.microsoft.com/en-us/library/aa952929.aspx Resources

41. BizTalk Server Database Optimization http://msdn.microsoft.com/en-us/library/bb743398.aspx Understanding Files and Filegroups http://msdn2.microsoft.com/en-us/library/ms189563.aspx How to: Add Data or Log Files to a Database (SQL Server Management Studio) http://msdn2.microsoft.com/en-us/library/ms189253.aspx How to: Move an Existing Index to a Different Filegroup (SQL Server Management Studio) http://msdn2.microsoft.com/en-us/library/ms175905.aspx Physical Database Files and Filegroups http://msdn.microsoft.com/en-us/library/ms179316(SQL.90).aspx Working with tempdb in SQL Server 2005 http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx Optimizing Server Performance Using I/O Configuration Options http://msdn2.microsoft.com/en-us/library/ms189892.aspx Filegroup – Resources

42. © 2008 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.