Skip to Content
Former Member
Feb 09, 2012 at 09:41 AM

Can the database size cause system wide freezing ?



We're running SAP B1 8.8 PL20 on SQL 2005. The server has a Xeon E5420 processor and 11GB RAM, operating system is Windows 2003 R2 Enterprise x64. Our database is approximately 30Gb.

At times, when running some queries, crystal reports, running customer ageing or drilling into the COA SAP can freeze system wide while the user is performing one of these actions. At times we can have upto 40-45 users on the system at one time

Could the size of our database be causing this ?

We are looking at using the archiving to reduce the size of the database but need to get some validation issues fixed on the database first this can happen so it's not likely to happen soon