1 / 14

Azure SQL Data Warehouse: tips and tricks

Learn best practices for Azure SQL Data Warehouse to boost performance and efficiency. Discover strategies for statistics, table distribution, compression, and maintenance schedules. Take advantage of recommendations and insights to optimize your data warehouse. Evaluate this session and share your feedback!

maeda
Download Presentation

Azure SQL Data Warehouse: tips and tricks

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. Azure SQL Data Warehouse: tips and tricks Kevin Ngo Program Manager Azure SQL Data Warehouse @ngovkevin THR2181

  2. SQL Data Warehouse Best Practices • Create and update statistics • Enable auto-create stats (auto sample stats) • Add multi-column statistics for joins on multiple columns or predicates • Auto-update coming soon! • Select the proper table distribution • Select the right hash distribution column and minimize data movement and data skew • Replicate dimension tables to reduce data movement • Maintain high quality CCI row groups • Maximize compression and limit remote I/O • Auto-index rebuild + Aggressive tuple mover! • Initiate user-defined restore points and configure maintenance schedules

  3. Check for Data Warehouse Recommendations!

  4. Azure Advisor recommendation blade Recommendation generated every 24 hours Data skew SQL data warehouse Recommendation API No stats Telemetry Stale stats

  5. Recommendation walkthrough

  6. Use Azure Data Studio for Data Warehouse Insights!

  7. Azure Data Studio walkthrough

  8. Configure Maintenance Schedules and Initiate User-defined restore points!

  9. Maintenance schedules and User-defined restore points Predictable & controllable downtime Seamlessly integrated with Azure monitoring services Maintenance notification alerts Resource Health Check Monitor Easy setup via the Azure portal or PowerShell Initiate snapshots via the Azure portal or PowerShell Safeguard against large modifications 7 day retention period with up to 42 restore points <20 min same region restore for any data size

  10. Maintenance schedules & User-defined restore points walkthrough

  11. Q/A

  12. Please evaluate this sessionYour feedback is important to us! Please evaluate this session through MyEvaluations on the mobile appor website. Download the app:https://aka.ms/ignite.mobileApp Go to the website: https://myignite.techcommunity.microsoft.com/evaluations

More Related