Skip to Content
author's profile photo Former Member
Former Member

SAP Business One Performance

Hi Experts,

We are using SAP Business One with iVend Retail SAP Add-on a product of (CitiXsys) from last 3.5 years. In Retail (supermarket) industry our current database size of SAP B1 is 615 GB from long time we are facing slowness in our application. I tried to do Data Archiving in test environment but it is just reducing 11% of our data size which will not help us to get desire performance. We have already logged this problem to SAP Support eight months back but still didn’t get any solution as they are still working on it and analyzing the root cause of problem. I would really appreciate your expert views or opinion on below questions;

  1. What is the maximum database size which SAP B1 can support?
  2. Will it advisable to create a same copy company with same master data and opening balances and start fresh operation without any transactional data?
  3. Some of our consultants recommend us to move to SAP A1. But my question is if SAP B1 is for small and mid-size company then why we invest on SAP A1.
  4. Is there any standard matrix available of SAP from which we can find in which category our business stands? Like Small, Mid or Large

However, for your kind information that Data archiving is running on simulation mode when you try to execute it there is a pre-requisite which is Inventory Valuation Check IVI. And it is not running on such huge data like we have, SAP Support is working of this as well.

Furthermore, before getting to any conclusion or comments please keep in mind that. This DB is not corrupted and all maintenance tasks been run on regular basis.

Regards,

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • Posted on Dec 30, 2013 at 09:16 AM

    Hi,

    1. Please refer below link for system and hardware requirements:

    http://www.columbus-systems.de/cs-wAssets/docs/SAP_Business_One_Systemvoraussetzungen.pdf

    3. For comparison between A1 & B1, please refer thread

    4. Compare Solutions | SME Business Management Software | SAP

    Hope helpful.

    Thanks & Regards,

    Nagarajan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 30, 2013 at 05:29 PM

    Hi,

    It is amazing B1's database can be run on the size of 615GB. There is no hard limit maximum for B1 db. However, I believe you have already got over the comfortable zone for B1.

    It should work for your 2nd option: to create a same copy company with same master data and opening balances and start fresh operation without any transaction data.

    B1 is mainly for small business. To include medium size here because some of them do not have huge transactions per day like you.

    Could you tell us how many (concurrent) users you have? How big is the db with master data only?

    Thanks,

    Gordon

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 22, 2015 at 01:18 AM

    Hello Waqas

    Iam facing a similar issue, have you been able to solve it??

    Regards

    Jacobo

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 22, 2015 at 01:56 PM

    Hi Waqas,

    Have you already thought about migrating your landscape from SQL to SAP HANA?

    Ask your SAP Partner about SAP Business One, version for HANA

    Regards,

    Darius

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 22, 2015 at 05:55 PM

    If possible, please post your hardware setup.

    From my understanding, your system will need a very fast storage subsystem to support that due to high I/O on writing.

    I would estimate a ssd raid will be required.

    Frank

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 12, 2015 at 09:02 AM

    Hi Waqas,

    even one of our customer is using SAP + iVend ans we are facing the same issue of perfomance at th supermarket POS and the SAP client.

    Our DB is about 90GB.

    Please let us know if you found any solution for this.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.