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

SAP Parameters setup

Hi All,

We have recently added 32 GB memory to our SAP system as new dataload activities are going to start in it So we have been asked to tune SAP systems to use this memory so that we do not face any memory issue during data load activites.

Please suggest which paramaters we should target to use this memory.

Shivam Mittal

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Aug 17, 2011 at 05:33 AM

    Hi,

    According to me, you should plan to adjust your memory in two areas, i) DB parameters ii) SAP parameters.

    (1) If your DB is Oracle then of course, sga_max_size and shared_pool_size should be main focus.

    (2) For SAP I would recommend to increase you total number of work processes specially background ones. Apart from this, better SAP Note should be followed.

    (3) [Note 192658 - Setting parameters for BW systems|https://service.sap.com/sap/support/notes/192658]

    Caution: Sometime increasing the parameters thoughtlessly may put you in problem.

    One should carefully analyze previous performance issues and scenarios to catch the area where memory increment will help

    Thanks.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 17, 2011 at 08:30 AM

    Hi

    For dataload activities , you need to consider the amount of data and the plan of loading ( parallelism ) to determine your memory parameters .

    For DB Level : Please see this Note :

    830576 Parameter recommendations for Oracle 10g

    For SAP Level :

    There is no clear cut defination of data load memory parameters.

    But if you are performing some test loads in your Quality and Dev system , then you are get a fair idea of the type of load under which your Production system is going to come under the actual data load.

    Depending on errors/problems received at test load phase , you can plan a comprehensive parameter list.

    Let us know your plan of action

    Thanks

    Rishi Das

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 17, 2011 at 03:33 PM

    you forgot to give us`:

    OS version

    SAP version

    DB version.

    any answer earlier is just a wild guess...

    Shivam, you have been a member here for years now, you should know what info to supply when asking questions.

    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.