Does enabling readable secondary in the availability group put any load on the primary server's tempdb?
-5
votes
1
answer
319
views
Enabling readable secondary will result in addition of 14byte extra information to each row in the primary as well as secondary.
This will also automatically enable the snapshot isolation level on the secondary which will result in additional load on the secondary server's tempdb.
Is there any chance this will put any load on the primary server's tempdb?
Asked by variable
(3590 rep)
May 18, 2022, 06:00 AM
Last activity: Jan 8, 2025, 01:26 PM
Last activity: Jan 8, 2025, 01:26 PM