on 10-31-2011 11:05 AM
Friends,
SAP SNC Portal DCM screen performance is very slow and times out when user trying to pull data using customer location
What are the cleanup activites we can do to improve the overall SNC performance ?
We did open OSS message but so far no reply from SAP , Is there any one faced performance issue ?
User/vendor is complaining about slowness , query is standard SAP and its taking more time .(table - /LIME/NTREE) , It looks like number of data are huge causing this problem related to LIME/NTREE table. What are the options to improve the performance ?
Thanks in Advance
Hanuman Choudhary
hi Team,
Pls . note the advise from SAP below, IS there any have experiance of archiveing /LIME records ?
Please advise how to start & what the steps in archiving ?
Thanks in advance
I had a look at the DCM query performance in PH1 system and figured out
that most of the time is spent at the LIME layer of database. The
following LIME tables are having far too many entries and is causing
the bottleneck during the query execution.
/LIME/NLOG_QUAN - 38,165,467
/LIME/PN_ITEM - 19,116,518
/LIME/PN_ITEM_TB - 19,154,124
These tables are storing the historical information about LIME(stock)
updates. Since these table grow with each change/update of stock
information, it will slow down the performance of the system over a
period of time. And to avoid the slow responses, the tables should
ideally be archived on a periodic basis to keep the data volume as
minimal as possible. You may have to discuss with the Business to
determine the number of days of LIME record you would want to retain
in the system. I would strongly recommend you to consider the LIME
archival retaining the minimum days (<=60 days) of historical
information. You can find more information about the Lime Archival
in the Sap Help link:
http://help.sap.com/saphelp_scm2007/helpdata/en/44/2a83121dde23d1e10000000a1553f7/frameset.htm.
Kindly get in touch with your BASIS consultant for the LIME archival.
The application performance should definitely improve after the LIME
archival. Please do not hesitate to get in touch with me in case you
require any further clarification in this regards.
Best Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
15 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.