OutOfMemoryException

RaulRaul Posts: 1 New member
edited August 14, 2018 2:01PM in SQL Search
Almost every time after I use SQL Search I get an System.OutOfMemoryException when I try to run any queries regardless of the number of rows it would return. I have to close SSMS and reopen to get rid of the error. Running SQL Search 3.1.7.2082 on SQL Server 2014 and 12Gb of RAM. Actually if I open another instance of SSMS it would work fine while having the other one still crashing
Tagged:
· Share on Twitter

Answers

  • Sergio RSergio R Posts: 610 Rose Gold 5
    Hi Raul,

    SQL Search runs in the ssms.exe process, which is a 32bit process, as a result it can only access a limited amount of RAM.

    If you are using an older version of SSMS I suggest that you update to 17.3 or newer since in that version SSMS became Large Address Aware (meaning that the process can access more RAM).

    Kind Regards,
    Sergio
    Product Support Engineer
    Redgate Software Ltd
    Please see our Help Center for detailed guides on how to use our tools
    · Share on Twitter
Sign In or Register to comment.