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

Month: May 2021

SQL Server FCI or AG?

What’s the Difference in SQL Server FCIs and AGs?

“What’s the difference in SQL Server FCIs and AGs?” That question comes up frequently when talking High Availability and Disaster Recovery (HADR). It’s especially important when “Everything stops and people can’t do their jobs if SQL Server is unavailable.” There are a lot of how-to articles on the internet for setting up Always On Failover…
Read more

SQL Server disk IO traffic jam

Identifying SQL Server Disk Latency

When SQL Server is not as fast as users think it ought to be, how can you tell where the slowdown is? Where’s the performance bottleneck? Where’s the traffic jam? Is it waiting on CPU? Does it needs memory? What about the disks? Could SQL Server be slow because of disk latency? Could be. But…
Read more