1 / 32

Optimize SQL Server for Private Cloud

DBI315. Optimize SQL Server for Private Cloud. Darmadi Komo Senior Product Manager Microsoft. Guy Bowerman Senior Program Manager Microsoft. Agenda. Why Private Cloud Optimize SQL Server for Private Cloud Consolidation Elasticity Self Service Control & Customization

maribeth
Download Presentation

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. DBI315 Optimize SQL Server for Private Cloud Darmadi Komo Senior Product Manager Microsoft Guy Bowerman Senior Program Manager Microsoft

  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

  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. Optimize SQL Server for Private Cloud

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

  11. 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

  12. Elasticity demo

  13. 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

  14. Optimize SQL Server for Private Cloud

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

  16. 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

  17. Self-Service demo

  18. 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) • Make use of pre-built VM templates • 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

  19. Optimize SQL Server for Private Cloud

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

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

  22. Control & Customization demo

  23. 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

  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. Required Slide Track PMs will supply the content for this slide, which will be inserted during the final scrub. Database Platform (DAT) Resources • Visit the updated website for SQL Server® Code Name “Denali” on www.microsoft.com/sqlserverand sign to be notified when the next CTP is available • Follow the @SQLServer Twitter account to watch for updates • Try the new SQL Server Mission Critical BareMetal Hand’s on-Labs • Visit the SQL Server Product Demo Stations in the DBI Track section of the Expo/TLC Hall. Bring your questions, ideas and conversations!

  28. Resources • Connect. Share. Discuss. http://northamerica.msteched.com Learning • Sessions On-Demand & Community • Microsoft Certification & Training Resources www.microsoft.com/teched www.microsoft.com/learning • Resources for IT Professionals • Resources for Developers http://microsoft.com/technet http://microsoft.com/msdn

  29. Complete an evaluation on CommNet and enter to win!

  30. © 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.

More Related