question

IanProc avatar image
IanProc asked

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?
availability-groupsalwaysonfailover
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Kev Riley avatar image
Kev Riley answered
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.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.