Welcome to my blog series on Azure SQL DB performance. In this blog I'll write about my findings with the Azure SQL DB Premium tier. Click here for information about the set-upClick here for the scripts I’ve used Intro In my previous blog I wrote about the standard tier, one that has 9 SKU’s and … Continue reading Azure SQL Database Performance comparison part 3 of 9: Premium
Category: Performance
Azure SQL Database Performance comparison part 2 of 9: Standard
Welcome to my blog series on Azure SQL DB performance. In this blog I'll write about my findings with the Azure SQL DB Standard tier. Click here for information about the set-upClick here for the scripts I’ve used Intro This tier is more expensive than the basic, but starting at 12 euro’s per month up … Continue reading Azure SQL Database Performance comparison part 2 of 9: Standard
Azure SQL Database Performance comparison part 1 of 9: Basic
Welcome to my blog series on Azure SQL DB performance. In this blog I'll write about my findings with the Azure SQL DB Basic tier. Click here for information about the set-upClick here for the scripts I’ve used Intro This tier is the cheapest one around, it'll cost you about 5 euro's per month. This … Continue reading Azure SQL Database Performance comparison part 1 of 9: Basic
Azure SQL Database Performance comparison part 0 of 9: setup
This is the starting point of a series of blogs regarding Azure SQL DB performance. This blog contains the setup and links to all the different database SKU's I've tested so you won't have to scroll endlessly to the part that is of interest to you. I hope you'll find this useful! Click here for … Continue reading Azure SQL Database Performance comparison part 0 of 9: setup
Speaking at Data Saturday Gothenburg
In a few weeks, I'll be speaking in Gothenburg at the Data Saturday event. I've driven past Gothenburg earlier this year on my way to Hamar but didn't get the chance to stop there (other than a traffic jam ;)). As a long-time Volvo and Stiga driver, it's nice to visit the home country of … Continue reading Speaking at Data Saturday Gothenburg
Increase network performance between your VM and Azure SQL Database
For a few weeks I'm facing an issue where an application on an Azure VM has a slow network connection to an Azure SQL database. I've tried different tiers and SKU's but the speed is just not there. When the application is running, it can push about 250 to 500 kb/s to the database. As … Continue reading Increase network performance between your VM and Azure SQL Database
Clustered Columnstore performance with deletes and updates
One way that might speed up you inserts and deletes on Clustered Columnstores. @Microsoft @SQLServer @AzureSQL.
Monitoring Azure SQL with Zabbix
My first long-read about monitoring your Azure SQL DB with Zabbix. And a little bonus with Linux.