Skip to Content
0
Former Member
Apr 13, 2010 at 03:12 PM

GROWING OF TABLE SEVT in SBO-COMMON is UNMANAGEABLE

870 Views

Hello all,

This post is dedicated to a specific issue related to SBO 2007 and B1i components (packaged with BusinessOne since SBO 2007)

The story begins with performance issues on our production server, that forces us to call an SQL server specialist for an audit.

After some reconfiguration regarding the windows server to optimize its usage (dedicated to SQL server), the conclusion of the audit raise a weird behaviour around the table SEVT in the SBO-COMMON database.

It appears that about 95% of total readings are generated by the repeated execution of the following query:

SELECT T0.* FROM DBO.SEVT TO WHERE T0.OBJECTTYPE=(@P#) AND T0.SOURCEDB=(@P#) AND T0.FIELDNAMES=(@P#) AND T0.FIELDVALUE = (@P#) AND T0.STATUS<> (@P#) AND T0.USER_ID=(@P#)

SBO logs any insert/update to this table when you are running an Add-on, even if you have de-activated and uninstalled B1i components. if you do not run an add-on, the table SEVT is no more accessed.

In our case, this has generated more than 4 000 000 records over around 10 monthes, so the application performance were going down and down, because of this behaviour .

We had 4 webex session with SAP support on this subject, and each time, the SAP contact was surprised by this behaviour, and even if it can not be reproduced when not running an add-on, the last comment we had from them was:

"The SEVT table grooving is a normal system behavior as the SBO logs all the activities directly to this table."

For your information this system is used by around 30 users symultaneously (around 300 declared), so if you are running SBO with an add-on on a production system, you may have a look to this table because it can put your performance down. the only workaround proposed for the moment is to truncate the table on a regular basis.

We hope SAP will correct this in a next release, but for the moment we don't know anything about their intentions.

Edited by: Fabrice NANNI on Apr 13, 2010 11:18 AM