After updating SQL Server database settings, certain actions or queries that previously took seconds, now take much longer delays, minutes and the performance is very slow.
We reverted the parameter change and still it's slow.
Other environments are working well.
Or sometimes the same slowness have also been seen there, but went away on its own after a couple of days.
Resolution
Ask the DBA to flush SQL Server cache for Clarity schema by running: