This website is not affiliated with, sponsored by, or approved by SAP AG.

Data archiving

Basis (Basis Technology Modules: Basis Component/System Administration, GUIs)

Moderators: Snowy, thx4allthefish

Data archiving

Postby Geeth » Fri Aug 07, 2015 5:03 am

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
Geeth
 
Posts: 69
Joined: Sun Mar 14, 2010 8:10 pm

Re: Data archiving

Postby blueteeth » Sun Aug 09, 2015 11:48 am

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
blueteeth
 
Posts: 499
Joined: Sat Apr 05, 2008 12:22 pm

Re: Data archiving

Postby Zavaros » Mon Aug 10, 2015 11:24 am

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.
Zavaros
 
Posts: 756
Joined: Thu Oct 24, 2002 10:50 pm
Location: Hungary


Return to Basis

Who is online

Users browsing this forum: Exabot [Bot] and 5 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.