1 / 32

Optimize SQL Server for Private Cloud

Optimize SQL Server for Private Cloud. Agenda. Why Private Cloud Optimize SQL Server for Private Cloud Consolidation Elasticity Self Service Control & Customization Next Steps & Resources. Private Cloud is happening …. 70% customers are doing/planning private cloud 1

susan
Télécharger la présentation

Optimize SQL Server for Private Cloud

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Optimize SQL Server for Private Cloud

  2. Agenda • Why Private Cloud • Optimize SQL Server for Private Cloud • Consolidation • Elasticity • Self Service • Control & Customization • Next Steps & Resources

  3. Private Cloud is happening … • 70% customers are doing/planning private cloud1 • Half of federal agencies will be in the cloud within 12 months2 • Adoption of virtualization and cloud computing to increase dramatically in the next 12 months3 • Self-services are catching up with virtualization quickly4 1AFCOM 2011 study 2Information Week 2011 survey 3Worldwide Executive Council 2011 survey on 100 CIOs 4CompTIA 2011 cloud computing survey

  4. Optimize SQL Server for Private Cloud Resource Pooling CONSOLIDATEdatabases Elasticity Scaleresources efficiently Self ServiceDeployresources on demand Control & CustomizeDrivestandardization and compliance • BENEFITS • Reduce capital expenses • - Standardize and consolidate • Reduce operational expenses • - Improve hardware utilization • - Manage IT infrastructure efficiently • Green IT • - Reduce space and power needs • BENEFITS • Greater agility • - Handle peak load scenarios faster • Dynamic infrastructure • - Scale to efficiently meet demand • BENEFITS • Faster time to market • - Automation without compromising control • Reduce administration overhead • Business units can request resources on demand • BENEFITS • Enforce and standardize based on policies • Measure service • - Meter resource usage and charge back to business units • Customize for your business needs Call to ActionLearn more at http://www.microsoft.com/ SQLServerPrivateCloud STEPS STEPS STEPS STEPS • Discover database sprawl and capacity planning • Consolidation options • Physical to Virtual Migration • Virtualizeand manage instances • Setup clustering for fast recovery • Upgrade host with minimum downtime • Increase virtual machine density • Load balance virtual machines • Create virtual machine templates • Build automation • Measure usage • Assign cost for each virtual machine template • Usage reporting • Charge back reporting • Manageprivate cloud CONSOLIDATE SCALE DEPLOY DRIVE MANAGE THROUGH A SINGLE PANE OF GLASS Follow us on http://www.youtube.com/sqlserver 2011 Microsoft Corporation. All rights reserved. Follow us on http://www.facebook.com/sqlserver Follow us on http://twitter.com/SQLServer For additional information go to http://www.microsoft.com/sqlserver

  5. PRIVATECLOUD DRIVERS Resource Pooling Elasticity Self - Service Control & Customize

  6. Resource Pooling Key Steps Consolidate databases CONSOLIDATE MAP Toolkit Upgrade advisor SQL Server SSMA

  7. Resource Pooling Demo

  8. Recap … Benefits Reduce capital expenses Standardize and consolidate Reduce operational expenses Improve hardware utilization Manage IT infrastructure efficiently Green IT Reduce space and power needs Tools MAP toolkit 5.5 Consolidation Planning Tool for SL Server System Center Virtual Machine Manager 2008 R2 SQL Server Upgrade Advisor SQL Server Migration Assistant • Control/discover your DB sprawl • Run MAP toolkit to identify running DBs (SQL Server, MySQL, Oracle, Sybase) • Know when to virtualize or not • Capacity Planning • Understand Isolation/security/HA requirements • Determine software edition, version, & hardware requirements • Use Consolidation Planning Tool for SQL Server to understand resource requirements • Choose consolidation options • Upgrade using SQL Server Upgrade Advisor • Migrate using SQL Server Migration Assistant • Begin conversion (virtualize) • Use P2V to keep existing settings • Create new VM to combine multiple apps

  9. PRIVATECLOUD DRIVERS Resource Pooling Elasticity Self - Service Control & Customize

  10. Elasticity Key Steps Scale resources efficiently SQL Server SQL Server SQL Server SQL Server 12Gb 8Gb Shared Storage iSCSI, SAS, Fiber SCALE Redundant Paths to Storage Guest Cluster SQL Server SQL Server SQL Server SQL Server Guest Cluster Live Migration Load Balancing Hyper-V Hyper-V Shared Storage iSCSI, SAS, Fiber

  11. Elasticity Demo

  12. Recap Benefits Greater agility Handle peak load scenarios faster Dynamic Infrastructure Scale to efficiently meet demands Tools Live Migration Dynamic Memory Guest Failover Clustering System Center Virtual Machine Manager 2008 R2 • IT develops VM templates • Build and deploy SQL Server Sysprep templates • Minimize planned downtime using Windows Server 2008 R2 Hyper-V Live Migration • Manage unplanned downtime with Guest Failover Clustering • Increase virtual machine density with Dynamic Memory • Virtual machine load balancing with System Center Virtual Machine Manager 2008 R2

  13. PRIVATECLOUD DRIVERS Resource Pooling Elasticity Self - Service Control & Customize

  14. Self Service Key Steps Deploy resources on demand Request business infrastructure Create VM Templates Create Roles Map to Existing Templates Create VMs DEPLOY BUSINESS IT Approve/ Reject

  15. Self-Service Demo

  16. Recap Benefits Faster time to market Automation without compromising control Reduce administration overhead Business units can request resources on demand Tools System Center Virtual Machine Manager 2008 R2 System Center Virtual Machine Manager Self Service Portal (SCVMM SSP 2.0) • Use automation • Leverage workflow service in SCVMM SSP 2.0 • Create & assign roles/permissions for business and IT admin • Request and build business specific infrastructures (submit & approval) • Map infrastructure to existing VM templates • Create & retire VMs on-demand

  17. PRIVATECLOUD DRIVERS Resource Pooling Elasticity Self - Service Control & Customize

  18. Control & Customize Key Steps Drive standardization and compliance Chargeback DRIVE Usage Reporting SQL Server SQL Server SQL Server

  19. Control & Customization Demo

  20. Recap Benefits Enforce and standardize based on policies Measure service Meter resource usage and charge back to business units Customize for your business needs Tools & Features System Center Virtual Machine Manager 2008 R2 System Center Virtual Machine Manager Self Service Portal (SCVMM SSP 2.0) System Center Operations Manager 2007 R2 Management Packs • Measure usage • Pre-build infrastructure by IT based on company standard and policy • Assign cost recovery model for each virtual machine templates • Monitor usage by users through reporting • Chargeback to users • Manage private cloud • Monitor & troubleshoot entire stack using SCOM

  21. Available Offers Self-Build Reference Architecture Appliance • “Hyper-V Fast Track Deployment Guide” and SQL Server Private Cloud Optimization guide. • “HP Database Consolidation Solution architecture guidance” • “Microsoft and HP database consolidation appliance” optimized to deliver Private Cloud benefits OFFER KEY POINTS KEY POINTS KEY POINTS • Highest level of flexibility • Reuse existing hardware • Longest Time to Solution - requires in-house expertise, time and investment to design test and build • Software and hardware built and deployed on site • Some flexibility in components utilized • Faster Time to Solution than Self-Build • Tested Solution: HP specific guidance, tested by Microsoft and HP and supported by HP • Proven performance & scalability • Software installed and tested at factory • Unique Appliance Features: • - Seamless scale 1/2 rack to multi-racks • - Load Balancing based on IO • - Optimization tools for Private Cloud • - Unified Health Monitoring • - Firmware, drivers, appliance utilities • Single point of support • “White Glove” delivery, configuration and support service Call to Action Learn more at http://www.microsoft.com/SQLServerPrivateCloud 2011 Microsoft Corporation. All rights reserved.

  22. DBC Appliance – Performance @ Scale Half Rack Full Rack Multi-Rack Pod 100 VMs* 200 VMs* 200 VMs per rack* 2000 VMs* A best of breed solution from the two world leaders in database infrastructure DBC Appliance (200 VMs) GREEN IT 200 Servers (in racks) Based on typical database workloads and hardware running for 1 year

  23. Optimize SQL Server for Private CloudTarget Corporation customer video

  24. Next Steps • TODAY: Build and deploy SQL Server for Private Cloud • All software are available today for immediate deployment • www.microsoft.com/SqlServerPrivateCloud • COMING SOON: • Optimized Database Consolidation Reference Architecture • LATER THIS YEAR: • Optimized Database Consolidation Appliance • Faster Time To Market – all software/hardware configured and tuned at factory • Optimized for DB OLTP performance • Can also run non-DB workloads • Single point of contact for support

  25. Resources

  26. Resources Web site: SQL Server for Private Cloud Blogs: Windows Virtualization Team BlogSQLOS Team Blog

  27. © 2011 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.

  28. Hyper-V is the best virtualization solution for SQL Server • Built-in Virtualization – Low TCO & Foundation for Cloud • Virtualization built into the operating system with Windows Server® 2008 R2 Hyper-V™ virtualization technology • Virtualization in the management platform with the System Center suite of solutions • Microsoft (existing knowledge and skills) vs. VMware (more training, support, costs) • Unified, In-Guest Management and Non-invasive • Virtualized Cloud infrastructures need comprehensive, physical, and virtual management • Only Microsoft System Center suite delivers • Unique Heterogeneous Management (Hyper-V and VMware) • Host and Unique in-guest management of applications and services • Integrated Physical and Virtual • Single infrastructure, Single license • Coexistence with no rip and replace for existing VMware customers • Single vendor to deal with : licensing, management tools, skillset, support (CDW paper) • Faster to market: with upcoming HP Database Consolidation Appliance (CY2011-H2)

  29. Licensing Cost Comparison* - Microsoft and VMware *Based on a comparison of Microsoft® System Center Server Management Suite Datacenter with VMware® vSphere Enterprise Plus with VMware vCenter Server.. Assumes a five host configuration, 2 processors on each host, 2 years support costs for both products, and no operating system costs included.. The Microsoft solution can use either the free Microsoft Hyper-V Server 2008 R2 hypervisor or an existing Windows Server 2008 R2 hypervisor.  Based on Microsoft estimated retail prices and published VMware prices available at https://www.vmware.com/vmwarestoreas of 08/04/2009 for purchases in the United States. Actual reseller prices may vary. Side-By-Side Comparison Virtualizing 5 Servers,2-processor Hosts, with Management Server Costs, 2 year Maintenance and No Operating System Costs *http://www.microsoft.com/virtualization/en/us/cost-advantage.aspx

  30. Basic Standardized Rationalized Ongoing Production Labor costs – By Maturity VM Labor Cost Per Annum (by Virtualization Technology, by estimated Maturity Ratio) 13.5% less 29.3% less 37.8% less TAKEAWAYS • When maturity %’s are used to review Labor Cost per VM – again Hyper V is cheaper per VM • The variances observed are inline with prior datacenter research Labor per Server ratios http://download.microsoft.com/download/1/F/8/1F8BD4EF-31CC-4059-9A65-4A51B3B4BC98/Hyper-V-vs-VMware-ESX-and-vShpere-WP.pdf

  31. Why Hyper-V is the best virtualization for SQL Server (mission critical workloads) • On-par Performance– SQL Server on Hyper-V or VMware • Very close to native performance for Hyper-V and VMware running SQL Server • Both products uses the latest featuresfrom Intel (EPT) and AMD chip (NPT) • Windows Clustering is the Key HA Technology • Windows Clustering is a mature technology and part of Windows Server • More SQL Server customers implemented Failover Clustering for SQL Server over DB Mirroring & Log Shipping (especially in high-end mission critical SQL Server applications) • Upcoming SQL Server “Denali” HA (AlwaysOn) make use of Windows Clustering • Customers Lose Key VMware Features in Failover Clustering* • VM mobility: No vMotion (Key reason to virtualize http://www.vmware.com/virtualization/why-virtualize.html ) • Dynamic Resource Allocation: • No automation level for VMware DRS (Dynamic Resource Scheduling) • No Virtual Machine Restart Priority • Zero-loss: No VMware Fault Tolerance • Virtual SAN: No N-Port ID virtualization (NPIV) • Memory overcommit not recommended • Customers Retain ALL Hyper-V Features in Failover Clustering– Live Migration, NPIV^, Dynamic Memory, Mixed Guest/Host Clustering, and many more Hyper-V is best for SQL Server Customer ready white paper *VMware publication (page 11) http://www.vmware.com/pdf/vsphere4/r41/vsp_41_mscs.pdf ^Needs SCVMM for NPIV support

  32. We have many case studies (over 50+)Different industries, countries, all running SQL Server Hyper-V is Enterprise Ready (3rd party study – ESG) (Workload study – ESG) Migration from VMware Win from VMware http://www.microsoft.com/virtualization/en/us/case-studies-featured.aspx?sortBy=name&switched=switched http://www.microsoft.com/casestudies/Case_Study_Search_Results.aspx?Type=1&Keywords=hyper-v%20vmware%20sql%20server&LangID=46 http://download.microsoft.com/download/C/F/B/CFB498D0-37B0-4805-9B41-EE2FCA3F1196/SQL%20Sustainability%20Technical%20White%20Paper.doc

More Related