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