Cloud Computing

Azure SQL DB is Slow: Do I Need to Buy More DTUs?

Microsoft Azure
23 Comments
You’ve got an Azure SQL DB, and your queries are going slow. You’re wondering, “Am I hitting the performance limits? Is Microsoft throttling my queries?” There’s an easy way to check: run sp_BlitzFirst. sp_BlitzFirst is our free performance health check stored procedure that analyzes a lot of common performance issues and then gives you a…
Read More
Brent Ozar reading

What’s Different About SQL Server in Cloud VMs?

Cloud Computing
7 Comments
When you start running SQL Server in cloud VMs – whether it’s Amazon EC2, Google Compute Engine, or Microsoft Azure VMs – there are a few things you need to treat differently than on-premises virtual machines. Fast shared storage is really expensive – and still slow. If you’re used to fancypants flash storage on-premises, you’re…
Read More

Building SQL ConstantCare®: What Cloud Hosting Costs

In our behind-the-scenes posts about building SQL ConstantCare®, I’ve written about how we picked serverless architecture for the application layer, and how we picked AWS Aurora for the database layer. Hosting costs were a big driving factor in those decisions – so how has that worked out? Presented for your enjoyment, here are our total…
Read More

Updating Paste The Plan to use the Serverless Framework

I just updated PasteThePlan, and the change you’ll notice first is that we’re using the latest version of Justin Pealing’s html-query-plan. It adds missing index hints, yellow bangs for warnings like implicit conversions and no join predicate, and more. Check out this example plan: PasteThePlan, June 2018 Edition Plus variable line widths for different amounts…
Read More

How to Restore a SQL Server Database into Azure SQL DB Managed Instances Redux

Anything Brent Can Do There’s some things you can do with Managed Instances, and some ways you can look at data that you can’t do elsewhere. For instance, you have the ability to start an restore ASYNC — that means if your session drops, the restore will continue headlessly in the background. There’s nothing about…
Read More

Azure SQL DB Managed Instances: We’re All GUIDs

Six is having problems adjusting to his clone status Some funny things happen when you create databases up in a Managed Instance. For Instance (HEH!), you may expect this to yield some fruitful results, but it Manages (HAH!) to defy logic. Transact-SQL CREATE DATABASE YourMom; SELECT * FROM sys.master_files WHERE name = 'YourMom'; 12345 CREATE DATABASE YourMom; SELECT…
Read More

Running SQL Server in the Cloud: 2017 Edition

Cloud Computing
25 Comments
You have two basic options: Infrastructure as a Service (IaaS) is just VMs running in someone else’s data center – be it Amazon, Google, or Microsoft. Job duties for a DBA are the same as on-premises virtual machines: you manage HA, DR, patching, backups, and performance tuning. It’s just that you may have slightly different…
Read More
Menu