Again this error: Could not load file or assembly or one of its dependencies. Not enough storage is available to process this command

I have a 32 bit version of SQL Server 2012 32 bit BI edition, which throws the following error

Failed to create AppDomain,....

occasionally. Most forums suggested restarting SQL Server which is not a permanent solution or mentioned some broken packages, but not enough instruction to narrow down the problem. I have noticed that it might be related to spatial queries.

SELECT TOP 1 
    [BS_ID], [PK],
    [Enabled],
    [StartDate], [EndDate],
    Geom  --type is Geometry
FROM 
    [dbo].[DIMV1_Bus_Connectors]

I get this error:

Msg 6517, Level 16, State 1, Line 1
Failed to create AppDomain "master.sys[runtime].9".
Could not load file or assembly 'System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. Not enough storage is available to process this command.
(Exception from HRESULT: 0x80070008)

but this works fine (does not have spatial column)

SELECT TOP 1 
    [BS_ID], [PK], [Enabled],
    [StartDate], [EndDate]
    -- ,Geom
FROM 
    [dbo].[DIMV1_Bus_Connectors]

Please note there is nothing wrong with Geom (spatial) column as it works fine when I restart SQL Server. I guess it should be related to a dll or something similar. I also reinstalled SQLCLR, but the same error occasionally.

In addition, I have noticed some people have talked about not having enough space or memory but neither of those apply to me. I have plenty of free hard disk and memory. The max memory size is limited to 20000 MB in SQL Server, which is even higher than 4GB which SQL Server 32-bit version supports.

The following screenshots provide more information.

Please let me know if you need further information.

Unfortunately, it is really difficult to replicate/stimulate this error as it happens occasionally.