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

TREX Alerts on unloaded indexes

Hello,

I recently got several alerts from TREX containing the following message :

hpa_1 : unloads
Returns any index that was unloaded from memory

>Decrease the number of loaded indexes

followed by the list of BIA appliance hosts w/ list of indexes.

What does this kind of alert mean and in which ways can i correct this ?

Thanks,

Ben

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 10, 2007 at 10:54 AM

    Hello Ben,

    this means that your sizing doesn't fit your current amount of data in BIA for the number of users who use BIA.

    You need more hardware resources.

    Kind regards,

    Michael

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 03, 2007 at 01:49 PM

    Hi,

    I agree Mikael's reply. You need to ensure that you donot overload the BIA with more indexes. This might bring the blade down very often and make BIA unstable.

    1. You need to know how much capacity you have on BIA. Generally each blade has either 8 or 16 GB capacity. However, you can use only half of it for indexes and rest is used by SAP for processing purposes.

    2. Now you can know the size of cube and its dimension tables from DB02. put cubename (so that it includes E, F and D tables).

    3. You can approximate the master data tables sizes. Since it is shared, there is not perfect way of estimating its size.

    4. So if you have an infocube of size 10GB (E, F, D and S, X, Y tables) and let say you have 3 blades fo 8 GB capacity. You can put it without any issues. However, let say you have 2 blades, so total usable is 8GB, 2gb exceeds, you can still put it on BIA, but you will see the memory overflow problem and blade goes down when there is huge reporting activity.

    5. Also you can ZZ_BIAMEMCONSUMPTION programs as given in the SAP note 917803 to do capacity planning for BIA.

    Thanks,

    Srikanth.

    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.