Month: May 2021

SQL Server FCI or AG?

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

May 27, 2021

“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

May 12, 2021

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

Subscribe to Blog

TAGS
Recent
Database Administration
Script Library

2000 Mallory Lane
Suite 130-707
Franklin, TN 37067

© 2024 The SERO Group.