How to enable EnableRetryOnFailure?

Questions
1

In my Umbraco 15 install I am getting random errors of type:

System.InvalidOperationException: An exception has been raised that is likely due to a transient failure. Consider enabling transient error resiliency by adding ‘EnableRetryOnFailure’ to the ‘UseSqlServer’ call.

How do I enable this function for SQL in Umbraco’s program.cs?

2

Bump, can anyone please tell me how to do this in umbraco so I stop getting these SQL errors?

3

Is this just not possible to do in Umbraco? I keep getting these errors during login and navigation in the backend and they are making using Umbraco very hard.

Is this something I should be posting as a bug over on github?