Read Only Routing Configuration UI
One of the big downsides to using the SQL Server 2012’s AlwaysOn Availability Group feature is that there is no UI to help you configure read only routing. Thankfully there is a fix for this. Denny Cherry & Associates Consulting is happy to announce the first of or AlwaysOn Tools which is the Read Only […]
SQL Server 2014 Standard Edition High Availability
With all the announcements about SQL Server 2014 this last week there have been a lot of questions about what’s going to happen for SQL Server 2014 and the non-shared storage High Availability options as we are now one step closer to database mirroring being removed from the product. You’ll see several blog posts coming […]
What does the RCSI overhead mean?
Earlier I posted a blog post which talked about the fact that when you turn on readable secondary replicas there are an additional 14 bytes of overhead which are added to each row. Overall the thought here is that the impact of this is probably pretty minimal. After all this is the same overhead for […]
Extra Bytes Per Row With AlwaysOn Availability Groups
One of things to keep in mind with SQL Server 2012 AlwaysOn Availability Groups is that when the availability group has readable secondary replicas any rows that are changed will have an additional 14 bytes added to each row. These 14 bytes are used by the readable secondary to handle the read committed snapshot isolation […]