2 min listen
Failover
FromVoice of the DBA
ratings:
Length:
3 minutes
Released:
Aug 5, 2016
Format:
Podcast episode
Description
I saw a note from someone that had a database set up in a High Availability (HA) configuration for production. This person had received an 823 error on the primary server, but a failover hadn't occurred. This wasn't a critical error, but one that noted some anomolies in a few pages, which potentially could be fixed by the automatic page repair in SQL Server. In this case, the individual would have liked to have had the system fail over, just in case there were a chance this would impact production. To make this happen, an alert on the error would be needed, which then forced a failover. This wasn't part of the native SQL Server configuration, and this individual was concerned. However, there are certainly cases where a failover might not be warranted when there is some sort of reaction such as Automatic Page Repair. Read the rest of "Failover"
Released:
Aug 5, 2016
Format:
Podcast episode
Titles in the series (88)
One Database to Rule Them All: This is what you build to juggle 6,000 tweets a second. That's the headline that caught my eye and it's about the challenges of Twitter and the data that they handle. Twitter definitely has a tough problem, one that few of us have, but perhaps they... by Voice of the DBA