on 12-15-2009 10:57 AM
Hi
I am Facing a problem in ECC.6 Server.
Error :
In SAP Management Console, Database in Yellow Showing with below message in process list ( disp+work.EXE)
dis+work.EXE(Dispatcher) Running, Message Server Connection Ok, Dialog Queue Time : 0.00 sec, J2EE status info unavailable.
Msg_Server.EXE & igswd.EXE are in Green Light only dis+work.EXE in Yellow light.
-
In the Event System :
-
Windows successfully diagnosed a low virtual memory condition. The following programs consumed the most virtual memory: sqlservr.exe (2032) consumed 18475802624 bytes, dispwork.exe (5404) consumed 232153088 bytes, and dispwork.exe (5412) consumed 229113856 bytes.
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Anybody help to comeout from this problem
OS : MS2008 Server Itanium Based
DB : SQL 2005
Any body help to comeout from this problem.
Thanks.
How much memory do you have?
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Checked dispatcher log?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
yes.
Daybefore i try to login remotely it gaveup error message "Your System is running low on resources.You cannot log on as a new user.Please use an account that has already been logged on".
i login with local admin and check that memory have taken 22 gb memory full. i restart the sql service it came and work normally, but database become yellow in dis+work.EXE service process.
> i login with local admin and check that memory have taken 22 gb memory full. i restart the sql service it came and work normally, but database become yellow in dis+work.EXE service process.
So if you hvae 42 GB physical memory (not swap) it's very weird that this error message is coming.
Markus
Yes, you said that already.
So it seems something does not work as expected.
I would:
- increase the swap memory to 20 GB (as recommended)
- check ST06 and ST02 when this low memory condition occurs and check which of the processes is using most of the memory
- set the database memory to a fixed allocation of 20 GB.
Markus
See the details In ST02
-
System: ERP-SBX_FSB_00 Tune summary
Date + Time of Snapshot: 15.12.2009 15:35:22 Startup: 14.12.2009 17:45:49
Buffer HitRatio % Alloc. KB Freesp. KB % Free Sp. Dir. Size FreeDirEnt % Free Dir Swaps DB Accs
Nametab (NTAB) 0
Table definition 99,09 6.799 2.190 38,40 20.000 7.680 38,40 0 13.351
Field definition 97,08 31.563 4.691 15,64 20.000 15.846 79,23 22.479 29.853
Short NTAB 98,22 3.625 2.853 95,10 5.000 4.580 91,60 0 420
Initial records 36,32 6.625 1.259 20,98 5.000 2.816 56,32 19.052 21.236
0
program 99,01 300.000 1.389 0,48 75.000 68.208 90,94 44.017 152.535
CUA 99,59 3.000 670 27,26 1.500 1.380 92,00 17.777 652
Screen 99,26 4.297 583 14,24 2.000 1.732 86,60 182 1.304
Calendar 100,00 488 266 55,65 200 95 47,50 0 105
OTR 100,00 4.096 3.375 100,00 2.000 2.000 100,00 0
0
Tables 0
Generic Key 98,30 29.297 1.014 3,66 5.000 827 16,54 154 135.197
Single record 80,82 10.000 377 3,84 500 416 83,20 57 191.036
0
Export/import 71,07 4.096 118 3,50 2.000 1.289 64,45 25.888
Exp./ Imp. SHM 85,31 4.096 3.341 98,99 2.000 1.999 99,95 0
SAP Memory Curr.Use % CurUse[KB] MaxUse[KB] In Mem[KB] OnDisk[KB] SAPCurCach HitRatio %
Roll area 1,22 3.197 4.192 262.144 0 IDs 100,00
Page area 1,36 3.569 23.376 131.072 131.072 Statement 100,00
Extended memory 1,72 794.624 1.138.688 46.100.480 0 0,00
Heap memory 0 0 0 0 0,00
Call Stati HitRatio % ABAP/4 Req ABAP Fails DBTotCalls AvTime[ms] DBRowsAff.
Select single 83,88 1.751.447 437.948 154.398 0 1.313.499
Select 82,95 2.180.801 0 4.388.068 0 3.799.699
Insert 0,00 6.454 3.543 12.938 0 10.701
Update 0,00 748 374 1.496 0 748
Delete 0,00 7.417 5.076 14.834 0 7.417
Total 83,42 3.946.867 446.941 4.571.734 0 5.132.064
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.