cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Business One with DI API integration MS SQL mdf data growth fast

0 Kudos

I am using SAP B1 9.0 PL 20 with MS SQL 2012, and i have a integrated program using SAP DI API.

I am trying to seek for help regarding with the fast grownth of the database specially my mdf file.

We started the integration not more than 1 year with 100MB only. But now we are having trouble with the growth of our database. Right now we have 200GB in mdf file database.

Can anyone help or explain what is the cause or what is the abnormality in this.

Accepted Solutions (0)

Answers (2)

Answers (2)

msundararaja_perumal
Active Contributor
0 Kudos

Base on which table, consider the date used before and after customization. If the table belongs to log file, disable them unless necessary.

msundararaja_perumal
Active Contributor
0 Kudos

Hello,

For initial analysis find out which tables has been be accumulating more space, from there you should be able to identify the cause, whether its due to customization or any default database growth.

From the SQL Server Studio, right click on the respective database, reports->standard reports-> Disk Usage by Top Tables.

Thanks.

0 Kudos

Thanks for the reply. But with this. How can we say that this growth is not because of the customize addon or not?