Cloud Computing

Research Paper Week: Automatic Indexing in Azure SQL DB

Last Updated August 11, 2019

Before I give you the link to the next research paper in this week’s series, I wanna give you a few questions to think about: If you had to build something to automatically add indexes to SQL Server databases, where would you start? What data would you use to make your decisions? How would you…

Now is the time to sharpen your cloud database skills. Here’s how to start.

Last Updated June 10, 2019

Brent Ozar

Microsoft Azure

Many of us DBAs have been able to put off dealing with the cloud. That time is quickly coming to an end. But when was resistance to change ever a great career strategy in a tech field? Besides, two or three or four years from now, you might not have much choice in the matter.…

Developers: Azure SQL DB Serverless can save you money.

Last Updated July 8, 2019

Brent Ozar

Azure SQL DB

If you’ve got a database that doesn’t need to be on all the time, Azure SQL DB Serverless is in public preview now. It makes a lot of sense for those development databases you have to keep around, but don’t really want to pay for. If your database doesn’t get any queries for 6 hours,…

Fixing Performance By Throwing Cloud At It

Last Updated April 22, 2019

Brent Ozar

Cloud Computing

Your databases are hosted in the cloud – either in VMs or in a database-as-a-service – and you’re having a performance emergency that’s lasted for more than a day. Queries are slow, customers are getting frustrated, and you’re just not able to get a fix in quickly. Just ask management if they want to throw…

Building a SQL Server app? Start with Azure SQL DB.

Last Updated April 2, 2019

Brent Ozar

Azure SQL DB

No no, April Fool’s was yesterday. Hear me out. Azure SQL DB’s feature limitations are a good thing. It doesn’t support everything that SQL Server supports, like CLR, cross-database transactions, database mail, linked servers, and OPENQUERY, but…frankly that feature-limitation page reads like a list of my favorite things to tell developers to avoid. You shouldn’t…

Pop quiz: what do these things cost?

Last Updated March 9, 2019

Brent Ozar

Cloud Computing, Hardware, Licensing

It’s been a few years since we’ve stopped in for a sanity check. Quick: without searching the web for prices, put these items in order. Do it on a scratch paper, guessing how much you think each one costs, then arrange ’em. SQL Server 2017 Standard Edition licensing for 4 cores SQL Server 2017 Enterprise…

In Azure SQL DB, what does “The connection is broken and recovery is not possible” mean?

Last Updated March 1, 2019

Brent Ozar

Azure SQL DB

All it really means is, “Click Execute again, and you will be fine.” If I had a dollar for every time I saw this error message in SQL Server Management Studio: The connection is broken and recovery is not possible. The error says: The connection is broken and recovery is not possible. The connection is…

There’s a bottleneck in Azure SQL DB storage throughput.

Last Updated February 26, 2019

Brent Ozar

Azure SQL DB

As you pay more for Business Critical Azure SQL DB servers, they’re supposed to get more storage throughput. The documentation on this is kinda hard to read, but boiling it down, for every core you add to a Gen5 server, you’re supposed to get 2,500 IOPs. That should scale linearly: insert speed should go up evenly with…

What does Azure SQL DB Automatic Index Tuning actually do, and when?

Last Updated February 18, 2019

Brent Ozar

Azure SQL DB, Indexing

Azure SQL DB’s Automatic Tuning will create and drop indexes based on your workloads. It’s easy to enable – just go into your database in the Azure portal, Automatic Tuning, and then turn “on” for create and drop index: ENGAGE Let’s track what it does, and when. I set up Kendra Little‘s DDL trigger to log index changes, which…

How fast can a $21,468/mo Azure SQL DB load data? (Updated)

Last Updated March 19, 2019

Brent Ozar

Microsoft Azure

Update March 19: Microsoft has since acknowledged a hidden limit, then documented it, then raised it – but it’s still disappointingly slow. In my last post, I explored how fast a $5,436/mo Azure SQL DB Hyperscale could load data. I’d had a client who was curious about spinning up their dev environment up there to…

How fast can a $5,436/mo Azure SQL DB Hyperscale load data?

Last Updated February 12, 2019

Brent Ozar

Hyperscale

A client asked, “How quickly could we spin up a full copy of our database in the new Azure SQL DB Hyperscale?” Their database size wasn’t too far off from the 340GB Stack Overflow database, so I decided to migrate that to Hyperscale to see how the experience went. Hyperscale is Microsoft’s intriguing competitor to Amazon Aurora. Hyperscale…

How Azure SQL DB Hyperscale Works

Last Updated February 10, 2019

Brent Ozar

Managed Instances, Microsoft Azure

Microsoft is starting to talk about the internals for Azure SQL DB Hyperscale, their competitor to Amazon Aurora. Aurora took the open source MySQL and PostgreSQL front ends and hooked them up to much more powerful cloud-first storage engines on the back end. Here’s a quick primer on how Microsoft is doing something similar –…

What Azure SQL DB Managed Instances Don’t Support (Yet)

Last Updated June 13, 2019

Brent Ozar

Managed Instances

Whenever a new product or feature comes out, I like keeping an eye on its support forums to understand the challenges users are facing. I went through Azure SQL DB’s Managed Instance feedback forum, and here are some of the interesting issues that have been raised: Support for other collations – sounds like right now…

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

Last Updated November 30, 2018

Brent Ozar

Microsoft Azure

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…

What’s Different About SQL Server in Cloud VMs?

Last Updated August 24, 2018

Brent Ozar

Cloud Computing

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…

Building SQL ConstantCare®: What Cloud Hosting Costs

Last Updated December 7, 2019

Brent Ozar

Amazon Web Services (AWS), SQL ConstantCare

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…

How The Cloud Turns Performance Tuning Into Cost Savings

Last Updated June 20, 2018

Erik Darling

Cloud Computing

Barely Metal In Ye Olde Olden Dayyes, companies would outline hardware budgets and refresh cycles. Every 3-5 years, they’d lick a thumb and hold it up to the CPU fans. If they felt a soft breeze, they’d buy the same number of CPUs. If they felt a hard breeze, they’d buy a few more. This…

Updating Paste The Plan to use the Serverless Framework

Last Updated June 14, 2018

Richie Rump

Amazon Web Services (AWS), PasteThePlan.com

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…

Azure SQL Managed Instances and Database Corruption

Last Updated March 18, 2018

Brent Ozar

Backup and Recovery, Managed Instances

Disclaimer: I love Azure SQL Managed Instances (MIs) so far. They’re really cool, and I’m having a fun time playing with them. I’m about to describe a bug, and I’m sure this bug will be fixed soon, so it shouldn’t stop you from previewing Managed Instances. This post is not “MIs are t3h suxxors” –…

Azure SQL DB Managed Instances: Transactional Replication

Last Updated March 20, 2018

Tara Kizer

Managed Instances, Replication

I knew Brent and Erik wouldn’t touch replication, so I figured I’d give it a whirl. My good, old friend replication I have a love-hate relationship with replication. Mostly hate due to latency and errors, but it does serve its purpose. Before Availability Groups came out, I used Transactional Replication to copy data from the…

Cloud Computing

Save your cart?