In my last post, I wrote about a new option in Azure – shared disks. Have you ever needed to build a Failover Cluster Instance (FCI) in Azure? This post will provide a few steps to get you started. To follow along with the demo, you’ll need an Azure account (available for free here )…
Read more
Azure offers a large array of options when it comes to high availability and disaster recovery. Failover clustered instances (FCIs) is a well known option, for SQL Server, that’s been available for years on premises. However, FCIs traditionally required shared storage. New versions of the Windows OS and SQL Server now support other options such…
Read more
Most of what you see in this post is similar to our prior post in the series – Azure shared disks – Failover Clustered Instance – SQL Server 2016. The key difference when setting up Failover Clustered Instances with SQL Server 2019 in Azure is we’re not going to utilize an Azure Load Balancer to…
Read more
We’re frequently asked how many tempdb files a SQL Server should have, especially from those who have downloaded our free 5 Common SQL Server Configuration Issues PDF. That’s because there’s a lot of well-intended but incorrect information posted on the internet about tempdb. What Is tempdb? Let’s start with a very brief description of tempdb. When SQL…
Read more
Recent Comments