on 02-08-2012 7:34 AM
hi Dear,
I am getting issue performance issue one new server while the system specs is:
*Processor 2 * x3690 X5, Xeon 8C E7-2820 105W 2.00GHz
Cache 18MB L3
Memory (Installed) 32 GB PC3L-10600 CL9 ECC DDR3 1333MHz
Instance Profile
Parameter Name Parameter value
em/initial_size_MB 12288
ztta/roll_extension 2000683008
abap/swap_reserve 20971520
abap/heaplimit 40894464
abap/heap_area_total 15204352000
abap/heap_area_nondia 0
abap/heap_area_dia 2000683008
rdisp/PG_MAXFS 32768
rdisp/PG_SHM 16384
rdisp/ROLL_MAXFS 32768
rdisp/ROLL_SHM 32768
ztta/roll_area 3000320
ztta/roll_first 1024
rsdb/ntab/sntabsize 9631
rsdb/ntab/irbdsize 19261
rsdb/ntab/ftabsize 96305
rsdb/ntab/entrycount 64167
zcsa/presentation_buffer_area 14640128
rsdb/cua/buffersize 8000
rtbb/buffer_length 90000
zcsa/table_buffer_area 30000000
abap/buffersize 1500000
PHYS_MEMSIZE 18432
login/no_automatic_user_sapstar 1
login/password_history_size 5
login/fails_to_user_lock 5
rsdb/obj/buffersize 40000
rdisp/wp_no_dia 12
rdisp/wp_no_btc 3
rdisp/wp_no_enq 1
rdisp/wp_no_vb 2
rdisp/wp_no_vb2 1
rdisp/wp_no_spo 2
rsdb/obj/max_objects 2500
rdisp/max_wprun_time 2400
would you give me your expert Suggestion with respect to system Specs(Processor_8C and RAM_32gb)
Regards,
Hi,
Refer SAP Notes 116042,88416 for Memory relevent recommandations.
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear,
following dump is occurring when I execute tcods (MB51, QA32 etc) to get 6 month data.
TSV_TNEW_OCCURS_NO_ROLL_MEMORY
Each transaction requires some main memory space to process
application data. If the operating system cannot provide any more
space, the transaction is terminated.
TSV_TNEW_PAGE_ALLOC_FAILED
No more storage space available for extending an internal table.
DATA_LENGTH_0
CX_SY_RANGE_OUT_OF_BOUNDS
Invalid partial field access: Length 0
would anyone give me suggestion about following parameters w.r.t RAM.
Roll, extended and heap memory EXTM
ztta/roll_area 3000320 Byte
ztta/roll_first 1024 Byte
ztta/short_area 3200000 Byte
rdisp/ROLL_SHM 32768 8 kB
rdisp/PG_SHM 16384 8 kB
rdisp/PG_LOCAL 150 8 kB
em/initial_size_MB 12288 MB
em/blocksize_KB 4096 kB
em/address_space_MB 4096 MB
ztta/roll_extension 2000683008 Byte
abap/heap_area_dia 2000683008 Byte
abap/heap_area_nondia 0 Byte
abap/heap_area_total 15204352000 Byte
abap/heaplimit 40894464 Byte
abap/use_paging 0
or I have to configure the zero administration memory management.
Regards,
Hi Experts,
I am getting following dump
"TSV_TNEW_PAGE_ALLOC_FAILED" " "
"SAPLSRTT" or "LSRTTU07"
"SRTT_GET_DATA"
The amount of storage space (in bytes) filled at termination time was:
Roll area...................... 2718352
Extended memory (EM)........... 2002756912
Assigned memory (HEAP)......... 4000044160
Short area..................... " "
Paging area.................... 147456
Maximum address space.......... " "
while the current value of Extended & Heap Memory parameters are:
ztta/roll_area 3000320 Byte
ztta/roll_first 1 Byte
ztta/short_area 3200000 Byte
rdisp/ROLL_SHM 32768 8 kB
rdisp/PG_SHM 16384 8 kB
rdisp/PG_LOCAL 150 8 kB
em/initial_size_MB 16384 MB
em/blocksize_KB 4096 kB
em/address_space_MB 4096 MB
ztta/roll_extension 2000683008 Byte
abap/heap_area_dia 4000000000 Byte
abap/heap_area_nondia 4000000000 Byte
abap/heap_area_total 15204352000 Byte
abap/heaplimit 40894464 Byte
abap/use_paging 0
would any oracle Expert suggest me the suitable values of above parameters w.r.t (RAM 32 GB DDR3 1333MHz).
Regard,
Hi Mate,
Have you problem resolved , If not please provide me the following :-
1) When this dump occurs , ( during specific activity or anytime).
2) When ever the dump occured go to ST02 and History ( by Shift+F6) and provide the screenshot of last table in that page.
Please increase the ztta/roll_extension to 4GB i.e 4294967296.
If the issue still persists provide the answer of above two questions so that we can provide you the values for memory.
Thanks and regards
Gaurav
hi Gaurav,
1) When this dump occurs , ( during specific activity or anytime).
Dump is occurring against specific transaction when users are executing tcode with big selection criteria.
System: PRDSAP_PRD_00 Tune summary
Date + Time of Snapshot: 21.02.2012 09:37:21 Startup: 19.02.2012 22:05:14
Buffer HitRatio % Alloc. KB Freesp. KB % Free Sp. Dir. Size FreeDirEnt % Free Dir Swaps DB Accs
Nametab (NTAB) 0
Table definition 86.81 21,809 64,167 127,586 192,179
Field definition 77.90 101,318 45,098 46.83 64,167 50,613 78.88 109,591 123,279
Short NTAB 98.44 11,636 8,958 93.01 16,041 13,391 83.48 0 2,650
Initial records 0.99 21,266 14,669 76.16 16,041 2,860 17.83 53,460 66,641
0
program 96.73 1,500,000 795,367 57.04 375,000 305,187 81.38 0 209,493
CUA 99.30 8,000 3,129 47.71 4,000 3,754 93.85 0 252
Screen 99.59 14,297 9,503 67.43 2,000 1,731 86.55 0 275
Calendar 100.00 488 366 76.57 200 48 24.00 0 152
OTR 100.00 4,096 3,375 100.00 2,000 2,000 100.00 0
0
Tables 0
Generic Key 99.73 29,297 2,399 8.65 5,000 1,611 32.22 39 14,181
Single record 88.77 90,000 51,599 57.45 500 403 80.60 0 72,187
0
Export/import 92.43 40,000 34,517 88.28 2,500 975 39.00 0
Exp./ Imp. SHM 53.57 4,096 3,203 94.90 2,000 1,999 99.95 0
SAP Memory Curr.Use % CurUse[KB] MaxUse[KB] In Mem[KB] OnDisk[KB] SAPCurCach HitRatio %
Roll area 0.12 325 3,488 262,144 0 IDs 98.77
Page area 0.25 666 94,624 131,072 131,072 Statement 93.00
Extended memory 4.03 675,840 6,881,280 16,773,120 0 0.00
Heap memory 0 1,084,762 0 0 0.00
Call Stati HitRatio % ABAP/4 Req ABAP Fails DBTotCalls AvTime[ms] DBRowsAff.
Select single 99.84 1,755,375 267,018 9,898 0 1,488,357
Select 1.53 1,471,444 0 561,166 0 5,708,457
Insert 0.00 225,271 5,926 58,267 0 4,146,957
Update 0.00 497 25 572 0 507
Parameters of SWAP entries
Efficiency HITRATIO % 87
HITS 1,264,801
REQUESTS 1,456,982
DB access quality % 87
DB access 192,179
DB access saved 1,264,787
Reorgs 0
Size Allocated KB 21,809
Available KB 18,297
Used KB 18,297
Free KB 0
Free KB 0
Directory entries Available 64,167
Used 64,167
Free 0
Swaps Objects swapped 127,586
Frames swapped 0
Resets Total 0
you can check the starting date of above server while there are some users are login on this server for data testing.
would you suggest me the value of above parameters?
Regards,
Regards,
Dear,
now the value of Roll area, Extended and Heap Memory is:
Roll Area
ztta/roll_first 1 Byte
ztta/roll_area 3000320 Byte
rdisp/ROLL_SHM 32768 8 kB
rdisp/ROLL_MAXFS 32768
rdisp/PG_SHM 16384 8 kB
Roll Area parameters value are OK?
here is default value of ROLL_SHM & MAXFS, how can i calculate the value of these parameter?
Extended Memory
em/initial_size_MB 16384 MB
em/blocksize_KB 4096 kB
ztta/roll_extension 4294967296 Byte
em/address_space_MB 4096 MB
here value of above Parameters are OK with respect to 32GB.
Heap Memory
abap/heap_area_dia 4000000000 Byte
abap/heap_area_nondia 4000000000 Byte
abap/heap_area_total 15204352000 Byte
abap/heaplimit 40894464 Byte
here I am bit confuse about abap/heap_area_total because dia and nodia have 4GB respectively while total parameters have big value 14GB.
Regards,
Hi,
"TSV_TNEW_PAGE_ALLOC_FAILED" " " The amount of storage space (in bytes) filled at termination time was: Roll area...................... 2718352 Extended memory (EM)........... 2002756912 Assigned memory (HEAP)......... 4000044160
So you program already allocated 6GB of memory before it runs out of storage.
Now this is the point to step back and ask yourself: Does it really have to do it?
The answer should be NO in 85% of the cases. In this case you have to redesign your program to
use less memory or use selection criteria, that do a limitation on the amount of selected data.
If the answer is YES (and correct), the next questions have to be:
How many users have to use it at the same time?
How much memory is really needed for one session?
Where is my training documentation about how a SAP process allocates memory?
A process allocates a small roll aera first and then allocates EM up to a max. of ztta/roll_extension
or available memory, whichever is first. It tries then to allocate HEAP up to heap_aerea_(non)dia.
Your process gets it all and dies with the maximum of allocated memory as to your parameters.
If you assume, your process will have allocate 10GB of memory to work correctly, and you will
likely have TWO of these that like to do this action, you should provide more memory for starters.
Might be SWAP in the beginning and if performance sucks, change it to RAM later.
Bringing down the HEAP to 4GB for bumping up EM is ok (to avoid processes go PRIV),
but you need to increase EM-max to ~24GB roll_extension to say 8 or 9 GB,
so that each of the both candidates can allocate up to the 10GB needed (with the rest taken from the HEAP).
How the rest of life will go on in your system with these settings needs to be monitored.
Volker
BTW, since the processors are x86 -> Is this Windows or Linux ?
Edited by: Volker Borowski on Mar 6, 2012 9:11 PM
hi Volker,
Thanks for your explanation and now I understood the scenario.
Dear, simple is here, currently, users are executing their Tcode with big selection criteria to verify their data between Current PRD server and New Server(Before Live). if you have look on following memory statistics than you will observed the Max use(KB) which was reached (Ext Mem -13,852,672 , Heap-9,998,988 ) with big selection criteria but as you know that in future, users have no need to execute these tcode with this selection criteria at same time.
SAP Memory Curr.Use % CurUse[KB] MaxUse[KB] In Mem[KB] OnDisk[KB] SAPCurCach HitRatio %
Roll area 0.45 1,192 8,656 262,144 0 IDs 99.87
Page area 0.18 472 95,712 131,072 131,072 Statement 96.00
Extended memory 14.16 2,375,680 13,852,672 16,773,120 0 0.00
Heap memory 0 9,998,988 0 0 0.00
current parameter is:
Roll, extended and heap memory EXTM
ztta/roll_area 3000320 Byte
ztta/roll_first 1 Byte
ztta/short_area 3200000 Byte
rdisp/ROLL_SHM 32768 8 kB
rdisp/PG_SHM 16384 8 kB
rdisp/PG_LOCAL 150 8 kB
em/initial_size_MB 16384 MB
em/blocksize_KB 4096 kB
em/address_space_MB 4096 MB
ztta/roll_extension 4294967296 Byte
abap/heap_area_dia 4000000000 Byte
abap/heap_area_nondia 4000000000 Byte
abap/heap_area_total 15204352000 Byte
abap/heaplimit 40894464 Byte
abap/use_paging 0
System Specs (PRD DB):
Processor 2 * x3690 X5, Xeon 8C E7-2820 105W 2.00GHz
RAM 32 GB
ECC 6 with Oracle 10.2.0.5 on Window Server 2008 SP2.
FYI.... Production server will consist on PRD_DB and PRD_APP server and each server on separate machine. I am asking about PRD_DB server.
How the rest of life will go on in your system with these settings needs to be monitored
then...what is your expert recommendation for Role, Extended and Heap Mem parameters?
Regards,
Edited by: majamil on Mar 7, 2012 7:05 PM
> How the rest of life will go on in your system with these settings needs to be monitored
then...what is your expert recommendation for Role, Extended and Heap Mem parameters?
Ha ha
I have no idea, because I do not know anything about the rest of action in your system.
I do not know, why your system has such a big heap, esp. on a windows system.
So if someone did set that for a reason, my advice might be well completely wrong.
I'd do (as for best guess, not knowing WHY you have 16G of Heap !!!):
heap dia/nondia = 2GB
heap total = 4 GB (to give any 2 procs the chance to allocate 2G) and to avoid early PRIV modes
em/max_size_MB probably 30GB, depending on what initial_MB is has now and taking into account
that reducing heap_total will give you 11GB back.
With these settings, your system is already configured deep into SWAP when on the edge, so provide enough SWAP.
In real life, you would always try to avoid this. So consider this just to be a setup to investigate, how much space
your guys really need.
Not sure how em_address_space_MB is handled in W2K8. Crosscheck the Defaults,
may have need to increase to em_max + 10%
may have need to increase to roll_extension + 10%
ztta/roll_extension... Humm. I'd give it a try with 8GB, just to see, how much space your application guys like to have.
If this is not enough, there might be need to seriously reconsider other strategies.
But to be honest, I have no idea if this will work for you.
Make Backup copies of your SAP-profiles before you apply these changes.
It might be possible, that your system is not starting any more when there is some memory shortage anywhere,
so you will need these copies to back out in worst case.
Volker
Edited by: Volker Borowski on Mar 7, 2012 10:01 PM
corrected em_max to roll_extension after re-reading
Dear Volker,
last one
thx for above recommendation for Roll and Extended Parameters.
as you know. Generally, we will assign RAM to DB,SAP and OS.
With 32 GB
For DB: (32 * 40) / 100 = 13GB
For SAP: (32 * 55) / 100 = ~18GB
For OS: ~3 to 4 GB
how can i distribute the RAM to DB and SAP Parameters respectively.
Oracle Parameter 13GB
db_cache_size=
shared_pool_size=
pga_aggregate_targe=
SAP Parameter 18GB
PHYS_MEMSIZE=
abap/buffersize =
em/initial_size_MB
Thanks man for sharing your knowledge and suggestion.
Thanks and Regards,
Dear Volker,
> last one
never promise things you can't keep
> thx for above recommendation for Roll and Extended Parameters.
> as you know. Generally, we will assign RAM to DB,SAP and OS.
> With 32 GB
> For DB: (32 * 40) / 100 = 13GB
> For SAP: (32 * 55) / 100 = ~18GB
> For OS: ~3 to 4 GB
Works for me in general, but if you have requests for big EM,
you might need to go swap and save a bit on DB.
So possibly:
db_cache_size= 8,5GB
shared_pool_size= 1 GB
pga_aggregate_targe= 1,5 GB - 2,0GB
SAP Parameter 18GB+swap
PHYS_MEMSIZE=15G
abap/buffersize = 1 GB
em/initial_size_MB = 6-10GB
rest as discussed above, depending on swap. (Or seach E-Bay for more RAM
Volker
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.