How can we help you today? How can we help you today?

OutOfMemoryException

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
Raul
0

Comments

1 comment

Sort by
  • 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,
    Sergio R
    0

Add comment

Please sign in to leave a comment.