G
gus
Guest
> On Jun 17, 2016, at 3:02 AM, Tai Li wrote: > > 1. It would be good to understand the reasons for the huge consumption of the memory. Along with the various private data structures, code, and shared libraries used by the _sqlsrv2 process there is also the database shared-memory segments that are mapped into the server's address space. Often, these are the largest consumers of address space. In a 32-bit executable, address space is quite limited as compared to 64-bit executables. You may be able to successfully perform whatever query is failing due to lack of memory by shrinking the database configuration. Fewer -B, -L, aibufs, bibufs, etc. might shrink the shared memory enough to allow additional dynamic memory allocation by the _sqlsrv2 process to succeed. All depends on how close to the address space limit you are.
Continue reading...
Continue reading...