Skip to Content
0
Former Member
Jun 03, 2011 at 01:46 PM

System no Roll : Memory tuning in 4.6c system on windows with 32 bit

162 Views

Hi all,

We are on 4.6c 32 bit on WIndows 2003 and sqlserver 2005 with 4 TB size.

We are getting System no Roll memory error for a particular background program, we have the below parameters.

em/initial_size_MB =10260

non dia heap =2 gb

ztta/max_memreq_MB = 2000

PHYS _MEMORY = 102600

we have observed the below info in short dump.

Unable to fulfil request for 67108864 bytes of memory space.

Warning: EM-Memory exhausted: Workprocess gets PRIV "

The amount of storage space (in bytes) filled at termination time was:

Roll area...................... 1581552

Extended memory (EM)........... 509376660

Assigned memory (HEAP)......... 442088384

Short area..................... 8063

Paging area.................... 24576

Maximum address space.......... " "

From the above short dump EM is used up to 500 mb only but we have given 10 gb as intial and PHY set to 100 gb and even heap is used only 400 mb and limit is set to 2 gb .

Please suggest is there any other parameter to be tuned in windows env to fix this issue..

Thanks,

Subhash.G

Edited by: Subhash Gadde on Jun 3, 2011 3:46 PM