We have 12.52 SP1 here where we have multiple policy stores (SQL Server 2012 with replication among the policy stores). There are 2 policy servers tied to each policy store of which we have 4.
I'm trying to determine how XPSSweeper should best be scheduled :
(1) Run once per day on one and only one policy server (regardless of which policy store the policy server is tied to)?
(2) Run once per day on one policy server (at different times) tied to each policy store?
(3) Run one per day on all policy servers at different times, presumably 30 minutes apart or so (XPSSweeper usually takes about 90 seconds or less to run).
Each policy store has an Admin UI tied to it, so replication handles policy store synchronization. So I'm also wondering if a policy server can get "stale" cached data if it doesn't run XPSSweeper on a regular basis?
We usually recommend doing
(1) Run once per day on one and only one policy server (regardless of which policy store the policy server is tied to)
XPSSweeper works on the policy store directly. So , you don't need to run individually on each Policy server.
For the other policy store, the replication should synchronize the changes done with XPSSweeper.
Policy server do regularly synchronize with policy store so you won't be getting stale data.
Thank you Ujwol,
Very helpful answer!