Msg 8624 with Server Running Low on Memory
I attach the SQL Server error log for a development server. As you will see there is a serious stack dump.
Please pass this on to your product team.
The scenario in which it occurred was that there was a large (60GB) database on the server, which wasn't being used.
Queries started displaying the following error:
Msg 8624, Level 16, State 1, Line 1
Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services.
As soon as I took the large database Offline, the above error didn't occur but the query didn't complete.
This is the query:
insert changedprofile (userprofileid)
select userprofileid from userprofile
where userprofileid not in (select userprofileid from changedprofile)
Both of the tables concerned had less than 5 rows and all datatypes were conventional (non-clr).