Upon reading the title, you may be thinking that of course parallel scans will be slow in the cloud. Cloud storage storage simply isn’t very fast. I would argue that there’s a bit more to it.
The Timeout
A query …
Category: Managed Instance
Why does FAST_FORWARD make some cursors so much faster in SQL Server?
If you’re like me, you started your database journey by defining cursors with the default options. This went on until a senior developer or DBA kindly pointed out that you can get better performance by using the FAST_FORWARD option. Or …
Trying out the new premium-series Azure SQL Managed Instances
At Microsoft Ignite 2021, public preview for new “premium-series” hardware was announced for Azure SQL Managed Instances. There’s even a black friday sort of sale during this month where you can do testing on premium-series VMs without paying for the …
Azure Managed Instance Doesn’t Manage tempdb Well
Twelve Angry Files
This post is admittedly short, but since we’re short of First Party Solutions™ to gripe to Microsoft with… I need to save this stuff somewhere.
- You get 12 tempdb files, even if your instance has 16,
Simple test results for query I/O performance on Azure SQL Managed Instance
Lately I’ve been doing some exploratory performance testing on Azure SQL Managed Instances in preparation for a migration to that platform. This blog post documents some storage testing results and may even have practical advice near the end. All testing …