Memory allocation to DPA processes on WIndows

Question

We upgraded our DPA server (Windows 2k3 quad CPU) from 4Gb to 12Gb of RAM. SQL Server continues to consume between 1 and 2Gb of RAM. The OS took a bit more than prior to the upgrade. However, DPA processes don't seem to be able to use more than a pittance of the RAM. I've attempted to increase the JVM allocations in the System Settings... but anything above 1536 seems to cause the process to crash (e.g., Reporter and Publisher in particular). Meanwhile, performance of producing reports is abysmal. An uncloned media report takes up to 8 hours to produce for a 2-3 day window. CPU utilization seems nominal (0-70% overall utilized). How can I get DPA to use more RAM? What else can we do to improve performance of reporting and still keep the services running? TIA.

DavidHampson · Answer

You might want to take a look here if you are unaware of it: http://support.microsoft.com/kb/283037

qsource1 · Answer

Thanks. Yes, we are aware of and configured the boot.ini. The 12Gb is visible to the OS, it's just not being used by SQL or DPA.Task Manager currently shows over 8Gb available in RAM.Still looking...

msjBA7cQWp12355 · Answer

I am having the same problem with a new install of DPA on a new server (4x quad core 12GB ram Windows Server 2008 x64) which never has less than 9GB available while running a report that gives me the error: insufficient memory available.

JasonBailey · Answer

I know this is an old thread I had this issue a lot You need to use Windows x64 and DPA x64 binaries to use more memory

Haffiz · Answer

go to system setting on Analyse engine tab, you may find the JVM memory limit, increse to 12GB regards haffiz ym : yhaffiz

NetWorker

Was this post helpful?