Why are encrypted stored procedures taking a long time to execute in SQL Server 2022?
Is there any specific settings or configuration at server level?
Our large procedures are working fine in SQL Server 2019 with encryption. But in SQL Server 2022 It's taking a very long time to execute.
Need some setting or configuration idea to make execution fast with encryption.
In the procedure, we just have simple insert statements. and when we had removed With encryption from procedure. It works faster as it was working in SQL 2019.