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