Franklin, TN 37067
+1 (888) 412-7376
info@theserogroup.com

Category: Azure

rope safety net

How to Create SQL Server 2019 Failover Clustered Instances in Azure

August 30, 2020

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

How Many tempdb Data Files Should My SQL Server Have?

July 2, 2019

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

Subscribe to Blog

TAGS
Recent
Database Administration
Script Library

© 2024 The SERO Group.