1 / 25

SQL Azure Administration and Application Self-Servicing

DBI326. SQL Azure Administration and Application Self-Servicing . Michal Lesiczka Program Manager Microsoft Corporation. Vinod Jagannathan Program Manager Microsoft Corporation. Agenda. Context and Role Definition SQL Azure Management SQL Azure Troubleshooting.

prentice
Download Presentation

SQL Azure Administration and Application Self-Servicing

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. DBI326 SQL Azure Administration and Application Self-Servicing Michal Lesiczka Program Manager Microsoft Corporation VinodJagannathan Program Manager Microsoft Corporation

  2. Agenda • Context and Role Definition • SQL Azure Management • SQL Azure Troubleshooting

  3. Who is the Application Administrator? • Breadth/Web & Departmental Apps • Many small distinct apps • 1 DB per app • 1:N (~10) App Admin to App Azure Application Azure Application Azure App Azure App • Enterprise Tier 1 / Mission Critical • Small # (tens) • 1:1 Admin to App • Highly managed SQL Azure SQL Azure SQL Azure SQL Azure SQL Azure SQL Azure SQL Azure SQL Azure SQL Azure SQL Azure • CSV • No traditional roles (devs?) • Highly automated • Multi-tenant (1 tenant per DB or Federations) • 100s – 10,000s tenants • Aggregated experience for monitoring, troubleshooting, management is key

  4. Physical vs. Logical Administration Instance Database HA Configuration Transparent Failovers Load Balancing Schema Creation & Management Security Query Optimization App Admin role places more focus on logical management

  5. App Lifecycle App Schema App Health App Security App Admin Responsibilities User management Plan, Stage, Deploy Monitoring Schema editing Import, Export, Workflows Diagnostics Patch, Upgrade Compliance Reports Ad-hoc queries Backup, Restore, Recover Fixes Delete, Retire

  6. Troubleshooting Features • Summaries and global views • SQL Azure Management portal integration • Live Troubleshooting • Limited DMV coverage • Extending DMV coverage • Database Extended Events • Historical Troubleshooting • Event Table (Logging)

  7. SQL Azure Management Portal

  8. SQL Azure Management Portal Customer Complaints: • How do I easily manage my SQL Azure databases? • How can I easily look at query plans and troubleshoot my query? Solution: • The SQL Azure Management Portal simplifies management and troubleshooting of databases. • Database management experience • Query performance details • Query plans • Event table support

  9. demo SQL Azure Management Portal

  10. Database Extended Events

  11. Database Extended Events Customer Complaint: • How do I trace the workload to understand where time is being spent and pinpoint any potential issues? Solution: • Utilize Extended Events to do live troubleshooting on databases in SQL Azure • Provides consistent experience between on-premise and SQL Azure troubleshooting

  12. demo Database Extended Events

  13. Live Troubleshooting using DMVs Customer Complaint: • I have a high workload but I am seeing a fairly low number of connections and sessions for my application. How can I find out what T-SQL is executing and if I can improve things? Solution: • New DMVs that provide insight into cached plans, trigger and stored procedure usage and performance.

  14. demo Troubleshooting using DMVs

  15. New DMVs

  16. Historical Troubleshooting using Event Table Customer Complaint: • My application experienced issues a few days ago. Is it potentially related to a deadlock in SQL Azure? Solution: • Event table provides historical event logging inside the logical master • Events types: • Successful connections • Connection failures • Throttling • Deadlocks

  17. demo Event Table

  18. Session Takeaways • Position the App Admin role • Manage a SQL Azure application • Troubleshoot a SQL Azure application

  19. Contact Information mlesicz@microsoft.com vinkjag@microsoft.com Vinod Jagannathan Michal Lesiczka

  20. Track Resources Hands-On Labs @sqlserver @TechEd_NA #msTechEd SQL Server 2012 Eval Copy Get Certified! mva Microsoft Virtual Academy

  21. Resources Learning TechNet • Connect. Share. Discuss. • Microsoft Certification & Training Resources http://northamerica.msteched.com www.microsoft.com/learning • Resources for IT Professionals • Resources for Developers http://microsoft.com/technet http://microsoft.com/msdn

  22. Required Slide Complete an evaluation on CommNet and enter to win!

  23. MS Tag Scan the Tag to evaluate this session now on myTechEd Mobile

  24. © 2012 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