Out of Memory Exception

crimdon

Keep an out of memory exception on the latest version. It won't even let me send an error report. Anyone else seen it?

Sergio R

Hi,

I am sorry that you are having issues when using SQL Source Control.

We have introduced caching in the latest versions of SQL Source Control, in some cases and since the tool runs within SSMS.exe which a 32bit process and therefore limited in the amount of RAM it can access this can cause out of memory exceptions.

To avoid this issue you should disable caching by following these steps:

1 - You need to have Frequent Updates turned on
http://documentation.red-gate.com/displ ... nt+Updates

2 - Update to the latest Frequent Update (version 4.2.1)

3 - After updating you will need to edit the following file:
%localappdata%Red GateSQL Source Control 4RedGate_SQLSourceControl_Engine_EngineOptions.xml
and add the following:

<EngineOptions version="3" type="EngineOptions">
<DisableCaching>True</DisableCaching>
</EngineOptions>

(Please note that %localappdata% usually corresponds to `C:Users(username under which SSMS runs - usually the logged in user)AppDataLocal)

Thank you,