1 / 0

Windows Azure Migrating SQL Server Workloads

Windows Azure Migrating SQL Server Workloads. Speaker Title Organization. Agenda . Recap Migrating SQL Server Workloads SQL Server IaaS Best Practices Summary. Recap. Check Out These Presentations First. Windows Azure Infrastructure as a Service

doria
Download Presentation

Windows Azure Migrating SQL Server Workloads

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. Windows Azure Migrating SQL Server Workloads

    Speaker Title Organization
  2. Agenda Recap Migrating SQL Server Workloads SQL Server IaaS Best Practices Summary
  3. Recap
  4. Check Out These Presentations First Windows Azure Infrastructure as a Service Overview of Windows Azure Virtual Machine, Storage and Networking Windows Azure - Migrating Apps and WorkloadsOverview of what kinds of apps and workloads to migrate and how to get started
  5. A Continuous Offering From Private to Public Cloud Physical IaaS PaaS SaaS Windows Azure SQL Database Virtual
  6. IaaS Workloads – all about the app Line of Business Applications Custom Applications, CRM, CMS, ERP, Business Intelligence Application InfrastructureFile Servers, Databases, Identity, Source Control Developer, Test and Staging Environments Quickly Provision and Un-provision Entire Environments Hybrid Applications Applications that span your data center and the cloud
  7. Migrating SQL Server Workloads
  8. SQL Server and Windows Azure VM Supported Versions SQL Server 2012, 2008 R2, 2008 Supported FeaturesAll SQL Server features supported except failover clustering * SQL Server Provisioning Cloud-first using stock images, bring your own server / VHD, capture cloud images SQL Server Licensing Pay by the hour or migrate your own license via Software Assurance ** * AlwaysOn Availability Groups not supported until GA ** Windows Azure Compute and Storage charges also apply
  9. Virtual Machine Sizes and SQL Editions Each Persistent Data Disk Can be up to 1 TB

  10. Demo

    Provisioning SQL Server with a Stock Image
  11. SQL Server on Virtual Machines Best Practices
  12. Running SQL Server in a Windows Azure VM Storage Recommendations Do not use write caching Avoid using OS drive for large databases Consider putting database and transaction log files on separate drives Consider putting tempdbon the non-persistent cache disk (D:\) Database Recommendations Consider using database page compression to reduce I/O High Availability Recommendations Consider latency between primary and replica when choosing sync mode

  13. Demo

    Using Windows Azure for SQL Server Disaster Recovery
  14. SQL Server or Windows Azure SQL Db? Shared Technology Network transport (Tabular Data Stream) SQL dialect (Transact-SQL) Data access APIs (ADO.NET, ODBC, JDBC) Development tools (SQL Server Data Tools) Management tools (SQL Server Management Studio)
  15. Summary Microsoft has a continuous offering from private to public cloud Windows Azure now supports IaaS workloads SQL Server is fully supported on Windows Azure Virtual Machine IaaS is about migration, PaaS is about new development
More Related