Aug 26 2024 11:32 AM
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
Aug 26 2024 03:28 PM
Aug 27 2024 04:37 AM