❓ You're managing databases that live in cloud whether it be AWS, Azure, and Google, and you're getting a lot of questions about slow performance and crazy costs.
❓Your users want everything faster and cheaper, and you're not finding good answers.
Join me, Brent Ozar, for a day of real-time demos, honest war stories, and practical fixes. I'll show how I use the First Responder Kit to assess the bottleneck, mitigate as much as I can with index and query tuning, and then write up a business case for management for better future budgeting.
Throughout the day, I'll include real-life stories from my cloud clients, with names changed to protect the innocent. I'll explain what worked, what didn't, and what went up in expensive flames.
I'll be using different flavours of SQL from across the clouds like Azure SQL DB Managed Instance and Amazon RDS SQL Server to highlight how each has nuances but also lots of similarities.
By the end of the day, you'll be armed with real-world techniques for keeping your cloud databases faster, cheaper, and more future-proof.
Databases
Faster, Cheaper Cloud Databases
Description
Learning Objectives
You'll learn:
✅How Brent uses the First Responder Kit to assess a cloud SQL Server's wait types
✅Why each cloud vendor's VM quirks make performance tuning tricky, and how to adapt
✅How to fix blocking, logging, and CPU issues when the hardware isn't yours
✅How to write a persuasive performance report for management to fairly lay out where the problem is, and what steps to take next
Things I will need
Tech Covered
Azure SQL Database, SQL 2022, Databases, Grounded in Reality