Hi guys,
To try to improve some performance issues with our SDP instance I've cleanup up the old system notifications using the query:
- 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