buffer storage usage exceeds threshold in solution manager

[Former Member]

gurus ,

in alert monitor in our solution manager system it displays as ,

"sap buffer storage usage exceeds threshold "

and when i see in the buffer monitoring the value of ,

field definition & initial records buffer were displayed in red .

what does that mean ?

as a basis guy what should be my best step ?

hoping for your valuable results

[Valdecir · Accepted solution]

Hi Susin,

This post would best suited on the SAP Netwweaver forum.

Anyway, go to ST02 transaction on the affected system and double click the desired buffer.

On the next screen you will see several information. Basically, most of the buffers have two main definitions:

1- size of the overall buffer

2- max entris this buffer can handle

These two definitions have profile parameters which you can use to fix your system. Just click in the button "current parameters"

This will show you the current parameters for this buffer and its values.

Check if you need to change size or entries or both and then go to RZ10 and edit your profile as needed. After this, restart your instance.

Regards,

Valdecir

[Former Member · Accepted solution]

thanks for your response .

but what exactly i look to knew is this is a serious issue , or what are the effect this would cause .

because this has occured in the solution manager system , wont we need to stop all the systems in the landscape if we want to restart the solution manager ?

if i need to change the value what value should i set ?

[Former Member · Accepted solution]

For alerts under DATABASE how to find the threshold values or the profile parameters regarding that

[Valdecir · Accepted solution]

Hi Susin,

Basically ST02 is intended to show you possible performance bottlenecks regarding the SAP memory buffers, that is, as higher the number of swaps in a specific buffer, greater will be your performance problem. So, your goal is to maintain the column SWAPs as low as possible .

As rule of thumb, this column should not be greater then a few thousands.

Regards, on what you should change, please, send what you have in your ST02 and I can try to suggest the changes you may need.

Regards,

Valdecir

[Former Member · Accepted solution]

for field definition 'swaps' value is 4299

for initial records 'swaps' value is 11567

for program buffer 'swaps' value is 31909

for CUA buffer 'swaps' value is 9617

for screen buffer 'swaps' value is 17

for Generic Key buffer 'swaps' value is 73

for export/import buffer 'swaps' value is 19488

above are the values in 'red' colour in sto2 .

suggest me the values to change . also the importance of changing it..its hard for me to compromise my higher officer on changing the parameter values

[Valdecir · Accepted solution]

Hi Susin,

Let´s focus on the top 3 :

- program buffer

- export/import buffer

- initial records

Go to ST02 agains and double-click the name of each one. On the next screen you will see the details for them.

Please send the information on that screen for each of the buffers.

Also, from the second screen, click on the button "Current Parameters" and send it along with the data from previous step.

Thanks

Valdecir

[Former Member · Accepted solution]

Program buffer

Details

Efficiency HITRATIO % 99

HITS 76.568.954

REQUESTS 77.405.232

DB access quality % 100

DB access 436.794

DB access saved 125.716.350

Reorgs 0

Size Allocated KB 400.000

Available KB 384.932

Used KB 383.150

Free KB 1.782

Gaps KB 1.782

Directory entries Available 100.000

Used 9.800

Free 90.200

Swaps Objects swapped 125.838

Frames swapped 0

Resets Total 0

Current parameters

program buffer pxa

abap/buffer size 400000kb

abap/pxa shared

Export/import buffer

Details

Efficiency	HITRATIO %	77
	HITS	1.404.619
	REQUESTS	1.818.739
	DB access quality %	100
	DB access	0
	DB access saved	0
	Reorgs	0
Size	Allocated KB	10.000
	Available KB	6.404
	Used KB	5.661
	Free KB	127
Directory entries	Available	10.000
	Used	1.833
	Free	8.167
Swaps	Objects swapped	32.666
	Frames swapped	464.589
Resets	Total	0

-

---

current parameters

Export/import buffer EIBUF

|rsdb/obj/buffersize 10000 kB

|rsdb/obj/max_objects 10000

|rsdb/obj/large_object_size 8192

rsdb/obj/mutex_n 0 Initial record buffer details	Efficiency	HITRATIO %	77
	HITS	161.198
	REQUESTS	209.593
	DB access quality %	77
	DB access	48.334
	DB access saved	161.198
	Reorgs	0
Size	Allocated KB	6.625
	Available KB	6.000
	Used KB	1.550
	Free KB	4.450
Directory entries	Available	5.000
	Used	4.188
	Free	812
Swaps	Objects swapped	44.093
	Frames swapped	0
Resets	Total	0

-

---

current parametrs

initial record buffer IRBD

rsdb/ntab/irbdsize 6000 kb

rsdb/ntab/entrycount 20000

[Valdecir · Accepted solution]

Hi Susin,

I suggest you to change the parameters as following:

- Program Buffer

The data shows that you have defined 400Mb for program buffer.

It also shows you have only 1,8Mb of this area free.

You have enough dir entries free.

Increase profile parameter ( Via Rz10 ) abap/buffersize to higher value, let´s say around 900Mb

- Export / Import buffer

Again, the size is showing you have not enough space, only 127Kb free. dir entries seems to be ok.

increase profile parameter rsdb/obj/buffesize to a higher value, let´s say around 20000 Kb

- Initial record buffer

This buffer has the opposite situation. The size seems to be enough and not enough free dir entries.

increase profile parameter rsdb/ntab/entrycount to a higher value, let´s say around 40000

After changind the values, save the profile, activate the new version and restart you SAP instance.

You will need to work with the system for a few days in order to confirm that those changes were enough.

Best regards

Valecir

[Former Member · Accepted solution]

Thanks a lot for your valuable response .

but it would be also of great help to me if i know what for these parameters stand for .

would you provide me with any guide or url which speaks on these parametrs individually .

for eg; u say about directory entries . but i dont know what is it's exacy use ..

i would like to explore that .

i would be greatful if u help me on this

[Valdecir · Accepted solution]

Hi Susin,

You can find more info about memory buffers in the SAP help:

http://help.sap.com/saphelp_nw70/helpdata/en/02/96253c538111d1891b0000e8322f96/content.htm

Hope this can help you.

Regards

Valdecir