YoVDO

Azure SQL Database - Lessons Learned from the Trenches

Offered By: PASS Data Community Summit via YouTube

Tags

PASS Data Community Summit Courses Database Management Courses Serverless Computing Courses Azure SQL Database Courses Extended Events Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Dive into a comprehensive conference talk from PASS Data Community Summit on Azure SQL Database best practices and performance optimization. Learn from Microsoft CSS support cases and customer engagements as Jose Manuel Jurado Diaz shares valuable insights on monitoring and improving query performance. Explore the effective use of Query Store, Extended Events, and DMVs to enhance database response times in the Microsoft Azure cloud. Gain practical knowledge through multiple demonstrations covering topics such as CPU performance, serverless configurations, troubleshooting techniques, and connection management. Discover essential lessons learned from real-world scenarios to successfully implement and maintain Azure SQL Databases in production environments.

Syllabus

Introduction
Who are you
Agenda
Background Check
Performance Issues
CPU Performance
Management Studio
Diagnostic Settings
Lessons Learned
Serverless
Review your code
Troubleshooting
Running extended events
Opening previous capture
Managing Azure SQL Database
Download Azure SQL Database
Client closed connection
USB timeout
USB aborted
Command timeout
More questions
Which one do you prefer
Whats running
Event Profiler
What we learned
The issue
Profiler
Connection Times
How Did We Fix That
Whats The Issue
My Role
Every Time
Connection Time
Replication Time
Connection Pooling
The Developer
What were the lessons learned
How connections work


Taught by

PASS Data Community Summit

Related Courses

Introduction to Cloud Infrastructure Technologies
Linux Foundation via edX
Cloud Computing
Indian Institute of Technology, Kharagpur via Swayam
Elastic Cloud Infrastructure: Containers and Services en Español
Google Cloud via Coursera
Kyma – A Flexible Way to Connect and Extend Applications
SAP Learning
Modernize Infrastructure and Applications with Google Cloud
Google Cloud via Coursera