Out of Memory Exception

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


  • 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">

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

    Thank you,
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
Sign In or Register to comment.