OutOfMemoryException

Raul

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

Sergio R

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,