Secondary replica

• sqlguru

  SSC-Addicted

  Points: 471

  More actions

  February 25, 2022 at 12:15 am

  #3988581

  There is a reporting query running on secondary replica runs longer and I can't add indexes to fine tune it. I see the warning of type conversion in expression may affect cordinalityestimate and I think distinct is making the query by serializable?

• r.dragoi-1095738

  SSCrazy

  Points: 2022

  More actions

  February 25, 2022 at 10:20 am

  #3988744

  This article may help you : https://docs.microsoft.com/en-us/troubleshoot/sql/availability-groups/query-performance-degradation

  and this as well : https://www.sqlshack.com/isolation-levels-behavior-in-sql-server-always-on-availability-groups/