
ColinHardie asked a question.
Hi,
I recently configured the <ApiEndpoint> setting of Snow Inventory after reading the helpful posting here. This had the effect of fixing my Inventory Service in SLM. Prior to this, it was failing due to a certificate issue, now it's communicating successful.
All good you might think, except during the time it wasn't working, quarantine management in SLM had deleted 200K+ users. Now those users have been marked for deletion in Snow Inventory. Garbage collection has kicked in and the procedure to delete them inv.DeleteUser is running. This is SLOW and is causing excessive CPU load, I think the main offender is it's trying to delete records from inv.CloudMeteringIntervalHits which is a big table. I can see the logic takes the users marked for deletion from the table inv.UsersForDeletion and calls inv.DeleteUser that will perform the delete from various tables and updates columns of others.
Are there any clean-up scripts that would allow me to remove these records without relying on Snow Inventory garbage collection...or indeed any configuration settings to control the user garbage collection?
I am currently running v6.6.1 of Snow Inventory,
Thanks Jason. I ended up just taking a backup of the contents of inv.UsersForDeletion table and then truncating it. I'll live with the records in SnowInventory just now. I did note from the release notes between my current v6.6.1 and latest release that some work has been done in the performance of garbage collection so I'll revisit it when I have upgraded. I can easily re-add the UserId's back to the table to see if deletion performance has improved any.