Hi Guru's
We started Archiving in ECC system last week. How can we capture the performance improvement or any way to check the performance improvement before and after archiving?
Thanks
Geeth
Data archiving
Moderators: Snowy, thx4allthefish
Re: Data archiving
Start collecting database performance records (before & during archiving).
After archiving project is completed, a database reorg is needed to get full benefits.
Then compare the performance (including backup runtime).
BT
After archiving project is completed, a database reorg is needed to get full benefits.
Then compare the performance (including backup runtime).
BT
Re: Data archiving
Hello,
I suggest to measure the runtime of key select commands on the relevant tables. To have some exact data you can check also execution plan and cost estimation.
My personal opinion is that archiving will cause only minor performance increase if the SAP system was properly tuned.
... well ... it is adviced to reorganize the tables after archiving ... so after reorganization you could have measurable performance increase.
Regards,
Zav
PS: please share your experience when the archiving is finished.
I suggest to measure the runtime of key select commands on the relevant tables. To have some exact data you can check also execution plan and cost estimation.
My personal opinion is that archiving will cause only minor performance increase if the SAP system was properly tuned.
... well ... it is adviced to reorganize the tables after archiving ... so after reorganization you could have measurable performance increase.
Regards,
Zav
PS: please share your experience when the archiving is finished.