Ranger GUI becomes slow due to excessive number of old savepoints.
Ranger never physically deletes records in vRangerPro DB. Over the time DB can accumulate thousands (for bigger environment) of logically deleted SPs, metadata files (SavePointXml table) and associated jobs and tasks.
T-SQL script will remove old savepoints and associated records in other tables.
Customers may observe decreased number of jobs/tasks in corresponding view.
Savepoints and jobs/tasks participating in current retention are preserved.
Script should be run in SQL Management Studio (free tool). Advanced customers can run it using sqlcmd.
On bigger DB (1.5+ GB) it may take up to 5-10 minutes to complete.
Follow below link to access script
Purge DB script on Dell Community
* If you have any questions about how to run this clean-up script, please consult your DBA.
