commonly used UPC slow when entering in a marketing document

[jbrotto]

I have a few upcs and when we enter them in a marketing document the system hangs before we can proceed to the next line. Is there a way to speed it up? I am running 8.82 with a 7 year old DB.

[Former Member · Accepted solution]

Hi Jonathan,

How much the database size?

You can archive old data and keep few years data.

Also keep in mind server configuration and network set up.

Regards,

Chintan

[jbrotto · Accepted solution]

As of April it will be seven years of production use. We had the same server since we were running business one 2005 which went 2007 to 8.81 to 8.82. The database is about 10 gigs and it only one upc that is the issue as we have used it about half of the 200,000 marketing documents made. We use a weighted average cost for our inventory.

[frank_wang6 · Accepted solution]

As I replied in another thread, please add more memory and enable PAE for your SQL server.

Frank

[jbrotto · Accepted solution]

I thought PAE would be useful for data center edition as I am running on standard

[Former Member]

Hi,

Due to the size of your db and history, you may check archive function. Also reduce the number of the logs would help too.

If you can upgrade your hardware, that will have positive impact. The slowness is only the beginning, if you don't take any steps above, the system would have more troubles.

Thanks,

Gordon

[jbrotto]

Even with a system running on 15K drives as I thought the biggest performance issue would be disk speed. At the moment we use around 1.5 - 2 GB for the SQL server. Maybe I can reinstall the SBO-Common file from scratch as it is slightly less than 2GB just for the mdf. You being the SAP B1 SQL master would this affect anything in B1?

[frank_wang6]

Using AWE

just follow this, and increase SQL server memory allocation after you install new memory on the server.

The reason why you SQL only consume 1 to 2G is because you only have 4G memory in system, there is an option to limit SQL to access more.

Frank

[jbrotto]

Did it. Nothing has changed yet but wait to see it in action with production data running.

[Former Member]

It is not very clear how big your B1 db is. Is it >10G? If yes, RAM is the main issue. Not the disk speed.

[frank_wang6]

Migrate your server to a newer one.

Frank

[jbrotto]

Planning to do so but it is going through a whole budget committee and I thought for the next few months before the box fails there could be a solution.

[Former Member]

Hi,

Up gradation of server is must in your case. Try to shrink log file on SQL

Also make sure server has only one network card. Some time it severely affect performance if two network working parallel on SAP server.

[jbrotto]

This was done on the first day to have one the single network card active. The log file is about 1 MB.