Working with a client I run an MRP scenario for all of the 155,000 stock items. The scenario covers 37 weeks and takes into account only 1 warehouse but seeks information using Sales Order, Purchase Order and Production Order to enable the Buyer to make purchases. Running the scenario we get the dreaded "Out of Memory" and SAP B1 stops. I ran this directly on the SQL Server which has 160Gb RAM, 120Gb given exclusively to SQL. Is there any more I can do? The client ran this up to now on SAP B1 2007 with no crashes and a severely struggling SQL Server and is embarrasing to show that the faster version of SAP B1 dies whereas the struggling version has no problem. We can shorten the range of MRP scenario and tighten what we need to review but that's a compromise.
Currently running SAP B1 9.2 PL07, 32-bit version on WIndows Server 2012 R2, SQL 2014 with the specs as previous. Any thoughts would be welcome on assessing this.