'High PFS Contention on SQL Server AlwaysOn
We are running a SQL Server 2017 AlwaysOn but have been experiencing extremely high PFS Contentions and do understand how to resolve them. We have replicated the environment to a single server with same everything but the contention is not observed on the single server. I am wondering, if there is something AlwaysOn does that would increase the workload on tempdb that a single server doesn't.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|