Tag Archives: high availability

Do You Really Need HA?

I ran across a thought-provoking post from Chrissy LeMaire asking if we should reconsider SQL Server HA. The post actually asks if you’ve considered not using it. The default from Chrissy, for most installations, is to use standalone SQL Servers. … Continue reading

Posted in Editorial | Tagged | 3 Comments

All the Costs of Downtime

I studied economics in university, which isn’t that close to database work, though I did have to work through linear regression problems by hand. I always enjoyed mathematics, so this wasn’t a hardship. Until I purchased a PC that was … Continue reading

Posted in Editorial | Tagged | Comments Off on All the Costs of Downtime

Pushing the Limits of AGs

Many of you reading this likely have an Availability Group (AG) set up on at least one database in your organization. Maybe not most, but many of you as this has proven to be a technology that many people like … Continue reading

Posted in Editorial | Tagged , | 1 Comment

Separate Reads

Recently I was watching a presentation on how to scale performance in your SQL Server environment and one of the suggestions was setting up Availability Groups (AGs) and having read-intent connections that would query the secondary and not the primary. … Continue reading

Posted in Editorial | Tagged , | 2 Comments