cancel
Showing results for 
Search instead for 
Did you mean: 

RSRLDREL2 - very slow running

0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

luisdarui
Active Contributor
0 Kudos

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...

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

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

Best regards,

Luis Darui

kaus19d
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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

0 Kudos

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