Tag: SQL Server
-
Azure SQL Databases 101: Moving databases in and out of Elastic Pools
In one of my previous posts about Azure SQL Databases, I wrote about the differences between Single Database and Elastic Pool deployment options. In that post, I mentioned that it is possible to move databases between different Elastic Pools. The one thing I overlooked to say is, that you can also move Azure SQL Databases…
-
Azure SQL Database: DTU Service Tiers
I’ll continue with the Azure SQL Database, and the topic of my previous post. This time we’ll look at the Service Tiers for Azure SQL Database when going with the DTU purchasing model. Compared to vCore model, the DTU pricing model provides much simpler configuration, both in good and bad. The DTU pricing model includes…
-
Azure SQL Managed Instance Storage Performance
Let’s continue with the storage performance topic a bit further. One thing that sometimes can be confusing is the storage performance with SQL Server Managed Instances. The reason for confusion comes from having two separate performance tiers (General Purpose and Business Critical), with different method of managing the IO performance. In General Purpose the method…
-
SQL Server Managed Instance and the most unhelpful error message during a database restore
I am a huge fan of managed database services, no matter which cloud platform they’re running on. The simple reason is that I am not a huge fan of managing the automation for the basic things like backups, patching and high availability myself anymore. There is a trade-off though when you’re using someone else’s automation…
-
Sometimes the VM in Azure is the best option for your SQL Server workloads
I have previously written quite a few post about how much I like the Platform-as-a-Service databases for SQL Server (and for databases in general), and I do like them quite a bit. But would I recommend them for all use cases and workloads? Heck no! At the moment there are some features and limitations in…
-
My favorite PerfMon counters
About two months back I ended up moving to another job, which has unfortunately kept me to be bit too occupied to find the time to blog, until now. Due to this previously mentioned career change, I have been working quite a bit with monitoring, and it gave me a spark to write this post…