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 […]
The Optimizer Isn’t As Smart As You Might Want It To Be
A little while back I got one of those phone calls. You know the one, the lovely 6am phone call about random performance problems. There were two problems that night. One which I’ll talk about later in another post, the second one which I want to talk about today. The query that was having problems […]