R
rchundur
Guest
Hi, Generally, a 32bit process on windows has 2 GB address space. This 2 GB address space will have to contain code, C runtime libraries, dynamically allocated data structures, etc... In this cases, SQL engine process consumed most/all of the heap memory available and hence you are getting this insufficient memory allocation failure. It would be good to understand the reasons for the huge consumption of the memory. Is the memory consumption of SQL engine process continuously increasing? What is the query that is causing this memory failures? Thanks, Raja Sekhar
Continue reading...
Continue reading...