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 […]
Recommended reading from mrdenny for May 24, 2013
This week I’ve found some great things for you to read. These are a few of my favorites that I’ve found this week. EXECUTE, not required, but advisable. Windows Azure SQL Database and SQL Server — Performance and Scalability Compared and Contrasted Setting up Quorum Node Weight in a Windows Server Failover Cluster Central Subscriber […]