Activate Azure SQL Performance Tuning and Optimization

[Pages:3]Activate Azure SQL Performance Tuning and Optimization

Proof of Concept

Duration: 4 Days [Remote / Onsite] Difficulty Level: 300 - Advanced

Description

This offering presents how to tune and optimize the data tier of an application using SQL on Azure. The performance optimization strategy describes how you can monitor the compute resources used by your workload which is relative to the service tier. You will learn about best practices on how to address common performance issues.

Objectives

Understand the service tiers, capabilities, and limitations

Review how to monitor and improve performance with different techniques

Discover best practices and learn how to apply them

Outcomes

Learn how to monitor, troubleshoot, and resolve any issues in Azure SQL

Enable Azure SQL features to help improve your performance

Methodology

Learn by example

Work closely with a Microsoft engineer to learn key concepts and best practices to enable a real-world deployment scenario.

Hands-on

Work with a Microsoft engineer to strengthen the performance of SQL on Azure.

Scope

This offering is scoped for one of the following environments: Azure SQL Virtual Machine Azure SQL Managed Instance

Agenda

Day 1-2 Educate: Select any Educate items for a customized

delivery. Day 3-4 PoC: Select any PoC items for a customized delivery.

Lead a close-out meeting with all relevant stakeholders and provide them with prioritized findings and deliverables.

? Microsoft Corporation. All rights reserved. This data sheet is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS OR IMPLIED, IN THIS SUMMARY

Delivery Outline - Scope: Azure SQL Virtual Machine

Requirements

Participants SQL Server Architects, Database Administrators Skill Requirement Strong SQL troubleshooting knowledge Time Commitment Four full-day engagement with relevant roles

Delivery Requirement Customer should have Azure subscription The scoped Azure SQL Database deployment is required.

Pricing Calculator | Microsoft Azure A computer connected to Azure SQL environment is

required

Day 1-2 Day 1-2 Day 1-2 Day 1-2 Day 1-2 Day 1-2 Day 1-2 Day 1-2 Day 1-2 Day 1-2 Day 1-2

Education

Azure IaaS Fundamentals SQL Server Architecture, Scheduling and Waits SQL Server I/O and Database Structure

SQL Server Memory SQL Server Concurrency and Transactions

SQL Server Index Structure

SQL Server Statistics Structure

SQL Server Query Execution and Plans SQL Server Plan Caching and Query Store

SQL Server Query Tuning

SQL Server Performance Tools

Learn Azure Fundamentals and SQL Server IaaS Agent Extension

Learn SQL OS, Task Scheduling and Waits and Queues

Learn basics for Disk I/O and troubleshooting I/O performance Understand page, data file and log file structure and TempDB file

structure

Understand Windows and SQL Server Memory management and troubleshooting SQL Server Memory issues

Understand SQL Server Concurrency, Transactions, Isolation Levels, Locking and Delayed durability and troubleshooting

Understand SQL Server Index strategy, Partitioning, Columnstore indexes, monitoring index fragmentation

Learn In-Memory OLTP

Understand SQL Server Statistics strategy, cardinality estimation, and statistics maintenance

Learn SQL Server query execution, analysis and optimization Understand SQL Server Intelligent Query Processing

Understand SQL Server plan cache, query store, and troubleshooting performance with query store

Understand sargable expression, query hints, and query troubleshooting

Learn lightweight query profiler, extended events and resource governor

Day 3-4

PoC

Monitor and troubleshoot disk I/O, TempDB, Memory, Query Performance, blocking, deadlock problems

Analyze the query plans and improve query performance Implement right isolation levels, index, and statistics maintenance strategy Explore partitioning, Columnstore index, and In-memory OLTP Performance

For more information: Please contact your Microsoft Representative for more details.

? Microsoft Corporation. All rights reserved. This data sheet is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS OR IMPLIED, IN THIS SUMMARY

Delivery Outline - Scope: Azure SQL Managed Instance

Requirements

Participants SQL Server Architects, Database Administrators Skill Requirement Strong SQL troubleshooting knowledge Time Commitment Four full-day engagement with relevant roles

Delivery Requirement Customer should have Azure subscription The scoped Azure SQL Database deployment is required.

Pricing Calculator | Microsoft Azure A computer connected to Azure SQL environment is

required

Education

Day 1-2 Day 1-2

Azure SQL Managed Instance Fundamentals

Azure SQL Managed Instance Performance Monitoring

Day 1-2

Azure SQL Managed Instance Performance Troubleshooting

Day 1-2

Azure SQL Managed Instance Performance Improvements

Azure SQL MI Service Tiers, Capabilities and Limitations, MI Client Tools, and MI Best Practices

Azure SQL MI Performance Concepts Use SSMS Built-In Reports and Azure Data Studio Extensions

Troubleshoot performance with Plan Cache and Query Store, Query Performance Insights, Intelligent Insights, Lightweight Profiler, Extended Events, and Log Analytics

Azure SQL MI: Index and Statistics Strategy Columnstore Indexes Memory Optimized Objects Automatic Tuning Intelligent Query Processing

PoC

Day 3-4

Install SQL Assessment extension in Azure Data Studio and run the assessment Troubleshoot instance level, database level performance Use first-party and third-party Azure Data Studio Extensions Explore Lightweight Profiling, Query Store, Log Analytics and KQL, Columnstore, In-Memory Implement index and statistics maintenance strategy

For more information: Please contact your Microsoft Representative for more details.

? Microsoft Corporation. All rights reserved. This data sheet is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS OR IMPLIED, IN THIS SUMMARY

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download