SQL Server Memory usage during Availability Group Failover

What happens to the Procedure Cache and Buffer Cache on a Server in an Availability Group during failover that WAS a secondary and BECOMES the Primary?

more ▼

asked Mar 14, 2016 at 02:52 PM in Default

avatar image

21 3

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

I recently had the same question, so I tested it out.

Procedure cache on the server that is the new primary, I saw no effect - but the proc cache on the server that was Primary and had become secondary had it's plans cleared. This was different to how the cache is managed with mirroring failover : http://www.sqlsoldier.com/wp/sqlserver/doesamirroringfailovercleartheprocedurecache

Buffer cache - as far as I am aware, failing over has no effect either way, and cache management continues to work in the normal way. It will be a warm cache as the process of syncing data modifications between AGs will have pulled data into cache, but it won't be the same on each replica.

more ▼

answered Mar 14, 2016 at 03:14 PM

avatar image

Kev Riley ♦♦
66.8k 48 65 81

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Mar 14, 2016 at 02:52 PM

Seen: 96 times

Last Updated: Mar 14, 2016 at 03:20 PM

Copyright 2018 Redgate Software. Privacy Policy