on 09-30-2016 10:40 AM
Hi,
we have a production SQL server 2005 database rapidly running short of space as its due to hit the drive 2TB limit, we are planning DB compression and a move to 2008 R2.
However, I noticed the IDOCREL and SRRELROLES tables are huge (280G and 60G respectively). I have executed RSRLDREL2 to delete entries but it seems to be running incredibly slowly, in this case (even with the DB switched to SIMPLE mode) its deleting about 6k rows per hour (6M of data). Does anyone know what the issue might be, is it full table scanning while doing the deletes ?
Any idea on a workaround ?
Regards Tony
Did you take a ST05 trace to follow up the database performance?
I/O can be a bottleneck also. Follow up the IO performance of the system during the execution:
Check also the "Real Time Performance Analysis" with DBACockpit presentation:
https://wiki.scn.sap.com/wiki/x/8Cm7Gg
Best regards,
Luis Darui
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Well it looks like you database face a automatic re-org job long time back. So an offline re-org job can show some improvements here.
Thanks,
Kaushik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Tony
Check below sap notes on
1978689 - RSRLDREL: Package Size for Updates
https://launchpad.support.sap.com/#/notes/1978689/E
908194 - Performance of RSRLDREL2
https://launchpad.support.sap.com/#/notes/908194
Hope that helps
Regards
Prithviraj
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.