Forum Discussion
SELECT query is slow in AlwaysOn primary node than secondary node
Hi Experts, Could you please help me !!! We have one database hosted on SQL Server 2019 AlwaysOn with database compatibility level 100 (SQL 2008 ). We are running one SQL View Select statement on...
Hello,
Is the AG configured as synchronous or asynchronous ? I'll guess synchronous. if that is the case you can try to switch it to verify
Also clean all the caches and perform an update statistics on the involved tables
Regards
Javier
Is the AG configured as synchronous or asynchronous ? I'll guess synchronous. if that is the case you can try to switch it to verify
Also clean all the caches and perform an update statistics on the involved tables
Regards
Javier
- Hi Javier, thanks for the reply. yes i have tried switching and cleaning the caches but the response time is higher in primary. if i remove alwayson then the response is same for both primary and secondary node. Is there any performance degradation in sql server 2019 AlwaysON if we place the database into AG having database compatibility level 110.
Regards,
Sreeni
