March 26, 2019 at 2:44 pm
Looking for any performance tips for the read only node of AG. I realize memory and tempdb important but any other tips from the wild appreciated.
March 27, 2019 at 5:53 am
I'm not quite sure what you're after exactly, but one thing to bear in mind is that read queries on a readable replica can block write queries on the primary under some circumstances- is that the sort of thing you mean? Obviously indexes on both replicas have to be the same.
March 28, 2019 at 7:58 am
If you are looking to get better performance for queries running against the readable secondary, I would look at indexes. Unfortunately, you will have to add them to the actual database since there's no way to just add indexes to a readable secondary.
Also, is the readable secondary also being used as a secondary failover node? You can have a 3 nodes setup where the 3rd node is the readable secondary and set it to async commit mode.
March 28, 2019 at 8:01 am
no not a failover, I understand that tempdb actually holds indexes for this server when being used (which is great until reboot)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply