Главная
Study mode:
on
1
Introduction
2
Who are you
3
Agenda
4
Background Check
5
Performance Issues
6
CPU Performance
7
Management Studio
8
Diagnostic Settings
9
Lessons Learned
10
Serverless
11
Review your code
12
Troubleshooting
13
Running extended events
14
Opening previous capture
15
Managing Azure SQL Database
16
Download Azure SQL Database
17
Client closed connection
18
USB timeout
19
USB aborted
20
Command timeout
21
More questions
22
Which one do you prefer
23
Whats running
24
Event Profiler
25
What we learned
26
The issue
27
Profiler
28
Connection Times
29
How Did We Fix That
30
Whats The Issue
31
My Role
32
Every Time
33
Connection Time
34
Replication Time
35
Connection Pooling
36
The Developer
37
What were the lessons learned
38
How connections work
Description:
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.

Azure SQL Database - Lessons Learned from the Trenches

PASS Data Community Summit
Add to list