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 primary node and it is taking around 9-10 seconds where as in secondary node taking 3-4 seconds. There is no much users or load on the primary node database. 

For testing I have removed database from Alwayson and rerun the same query and it is taking  4 seconds on the primary node then I have added again database into Alwayson then the query time in primary node is again 9-10 seconds. 

Could you please guide me how to improve the query performance on the primary node when database in Alwayson.

Thanks

Sreenivasa

​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 primary node and it is taking around 9-10 seconds where as in secondary node taking 3-4 seconds. There is no much users or load on the primary node database. For testing I have removed database from Alwayson and rerun the same query and it is taking  4 seconds on the primary node then I have added again database into Alwayson then the query time in primary node is again 9-10 seconds.  Could you please guide me how to improve the query performance on the primary node when database in Alwayson. ThanksSreenivasa    Read More

​