Database table cleanup

Database table cleanup

Hi guys,

To try to improve some performance issues with our SDP instance I've cleanup up the old system notifications using the query:

  1. delete from notification where (NOTIFICATIONDATE <= '1459429200000' and SENDERID = '1');
Which just deletes any system notifications older than April this year.

Seems to have made a noticeable difference.

Now that the notifications table is reduced, I can see the next three largest tables are:

  • SystemHotFixInfo
  • ErrorLog
  • HwAuditHistory

Is it possible to cleanup these tables also?

Thanks
                New to ADManager Plus?

                  New to ADSelfService Plus?