In our operating mode of validation system refresh, we use an export of users+profiles (SCC8 and SAP_USER profile) made on pre-refresh step ... And the we import this "SAP_USER" export with STMS (and the post import with SCC7 transaction).
We have 8300 users ...
Import with STMS take 02h30
Post import (SCC7) take 00h30
The export of the client is very quick ...
It will be very usefull for us if the import could be faster ... Is there a problem with this duration ?
Is there some actions that can improve performance ?
Thanks by advance for any helps,
I agree with Orkun Gedik.
You should check the copied tables and the select statements. Maybe you can find where-clauses where no index is defined. Additional you should create statistics for the copied tables.
If you are copying the user data very often, it can happen that the tables and indexes are fragmented. In this case you can do (online) reorgs of these tables.
I assume that your are running on Oracle RDBMS. Please check the items, below;
1) Missing indexes: Actually, it may lead performance problems while reading the data, but in this case, you should check it,
2) Number of customer indexes: If a table has many more indexes, it may lead long runtimes for DML statements. For the instance, you may face with a performance problem, while updating indexes. Under this circumstance, you may check which table is causing long run-time, during your import process,
3) Wrong statistics on your tables,
4) Small rollback segments.
As an additioanl info, you can check "Note 68896 - R3trans: Performance problems and cluster" on SAP Marketplace.
Senior SAP Netweaver and Development Consultant
SAP Technical Architect
i have facing poor performance problem in sql 2000, during the client import process. log size increase very rapidly and db server not able to backup and truncate these logs in time. do to this problem log partition fill up and import process fails. i also tried to put db in simple recovery model but in this logs are increasing.
here also same situation arose, i also tried to shrink logfile but it not help too much.
Can i import the sap profiles in several time despite the importing the SAP_ALL in once without loosing the data in target client.
Please check notes:
Note 86535 - tp/R3trans: Splitting large exports
The 2nd note describes, how Import performance can be improved by preemptively deleting selected data from target client before import starts.
One key point described in SAP Note 68896 is the following:
"When importing, R3trans attempts to merge the table entries transported with the existing ones in memory and to only write the changed table entries. To do this, all entries from the logical tables must be read and expanded, requiring considerable resources. The strategy of only writing back changed records, in order to avoid database accesses is less effective for cluster tables, as a change to the logical table entry suffices to force the physical table entry to be written back to the database. A previous deletion of the physical clusters can significantly improve the speed of this."
Hope that helps.