Suppose that we have an Availability Group configuration (SQL Server 2017) where primary and synchronous secondary do not share any resources (each replica have dedicated CPU, memory, disk, etc.)
Will read-only activity on synchronous secondary have performace impact on primary replica ?
The reason I ask because different sources tell different (contradictory) things:
Some sources say it has impact and not recommended to offload read-only activity to sync secondary (recommend only offload to asynchronous replica), and others tell that is best practice to offload reporting load on secondary even if it is sychronous
What do you think on this ?