Can the database size cause system wide freezing ?

[Private_Member_135681]

Hi

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

Thanks

[Former Member]

I suggest upgrading to SQL 2008, as SQL2005 does not handle 64 bit well (depending on the patch level).

Do some research into some SQL tuning options. If you are getting SQL errors while the system is freezing, it could be you need to set max memory settings, or some other SQL options.

[jbrotto]

SQL 2008 R2 could handle more data better but you db is quite large. I thought we had a problem with a 8gb db and 20 users on our 32bit windows server. Also have tried archiving data.

[Former Member]

Hi,

The answer is yes. For a 30G db, you must reexamine all current queries & report carefully. Optimize them first. Better have a static recent backup db to run resource hogging queries/reports.

Thanks,

Gordon