Skip to Content

RSRLDREL2 - very slow running

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 30, 2016 at 10:39 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Thanks Prithviraj

      SAP also sent me this note, so will check them all out and update the thread if I have success thanks

      The tabke index statistics are also well out of date so I am planning on updating thiose after hours tonight.

      #1589406 - SREL: Performance for object relationships

      Tony

  • Oct 03, 2016 at 04:21 PM

    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:

    https://blogs.msdn.microsoft.com/saponsqlserver/2010/05/04/monitoring-sql-server-io-performance-with-sap/

    Check also the "Real Time Performance Analysis" with DBACockpit presentation:

    https://wiki.scn.sap.com/wiki/x/8Cm7Gg

    Best regards,

    Luis Darui

    Add comment
    10|10000 characters needed characters exceeded