Performance and Hanging Issue

[Former Member]

Dears,
My company was using SAP Business One 8.81 PL07 but 2 months ago, the hard of server is crashed and we deploy a new server with SAP recommended configuration. We also upgraded the sap business one to 8.81 PL08.

After some days, the live database was hanging (blank screen and the users could not to enter it), once in a day and for solving, it needed to restart the server completely.

The support company connected to the server and  defined the ports of SAPBO and SQL SERVER  in firewall and the problem was solved mostly.

But in last week, the live database was hanged twice again.

Could you please tell me what problem is and how i can stable the database?

It's considerable that the test database (a backup version of live database), doesn't have any problem.

Extra Info:

1) The database size : around 17 GBs (I've placed the mdf and ldf files in separated partitions.)

2) number of concurrent Users in a day: around 70 persons (with citrix and LAN)

3) Server specification: 2 xenon CPUs and 48 GB RAM and RAID 0 for OS and RAID 10 for DB

4) I run some tasks by RSP 2.4 weekly for example re-indexing DB, shrinking sbo_common DB, clearing logs and so,

5) I shrink log file by sql server when the log file will be growth.

6) I set the DB backup plan for every 6 hours.

Thank you.

[Former Member · Accepted solution]

Hi Kayvan,

Upgrade your B1 system for latest versions and check..

http://scn.sap.com/community/business-one/blog/2012/08/09/performance-best-practices-for-sap-busines...

Regards,

Marcelo Silva Santos

[Former Member · Accepted solution]

You mean if i upgrade to the last version of sapbo, my problem is solved? i think it's related to sql server or windows server. because, i don't have any problem on my backup DBs.

[Former Member · Accepted solution]

I read this article. I've tried to do all recommendations but the problem is remained.

thank you.

[karthick_s8]

hi everyone,

I m heading with same problem,any one find solution??

Regards

Karthick.S

[former_member188586]

hI kARTHIK

This thread is Already Closed thread

for Quick replay , please post as new thread ..

--Ramudu

[jacobo_agami]

Hello Kayvan

I am having the same issue, have you been able to solve it?

Thanks

Jacobo

[Former Member]

Hi,

Kindly monitor your resource monitor program for the consumption if the memory 48 is over its

capacity then you need to upgrade your memory or server.

Does the citrix users are using the same server? or different machine? Recommended

citrix users should be in different server.

Although you created a test database but you didn't try the 70 users to log-in.

You said your database is 17Gig, did you tried implementing the data archive feature?

Thank you.

Regards,

Clint

[Former Member]

Hi Kayvan,

First of all you cannot compare performance matrix between production db which has active user’s connections and Test db.

To guide you properly I need answer of below questions;

1. Which hard drive do you have in your production server, SAS or SATA and what RPM it has?
2. At what event do you getting hanging problem at the time of user log-in?
3. Have you checked the SQL Server Activity Monitor? Is there any deadlocks occur in your database?

Below are some recommendations which may help you;

1. Stop license service and if you have multiple Network cards in your server which usually server has then disable ALL Len cards except your main Network card and start SAP license services.
2. Try to run Re-Index, Update_statistics , anc DBCC Checkdb command directly on SQL server rather than executing them via RSP

Thanks,

Waqas

[Former Member]

Hi,

    Change the Backup plan during the minimal user access time like Early Morning or Night. And check and clear any dump files available in the log.

Regards,

Priya

[Former Member]

Thank you for your reply. Would you please tell me what your meaning of Dump files in the log is?

[kothandaraman_nagarajan]

Hi,

Please check with Logger settings under Help--->Support Desk.

Thanks & Regards,

Nagarajan

[Former Member]

Hi,

When B1 crash, there is dump file created. In your case, it may not be true since your user only get hanged.

Because you have so many concurrent users, you need to restrict user to run sophisticate query with huge output. Those should run on test database.

Reduce your backup schedule to only midnight.

Thanks,

Gordon

[former_member235680]

Hi Kavyan,

When you go to LC10 on liveCache server, what is the status of Automatic Log Backup? Is it ON or OFF?

Regards....

A.K.

[Former Member]

Hi Abhi,

Would you please tell me what LiveCache is?

I searched about it and couldn't find anything related to SQL Server or Sapbo.

thank you.

[Former Member]

Thank is for R3, not for B1.

[KennedyT21]

Hi Kayvan Mohitmafi...

I think you you have to upgrade your system into latest versions.

check you DB performance while the system hang

Regards

Kennedy

[Former Member]

I would like to upgrade my DB but we use an localization add-on that developed by a SAP partner in Venezuela and unfortunately, their add-on is not still supporting the last version of SAPBO.

thank you.