Loading
Snow Inventory Garbage Collection - Slow user deletion

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,


  • Community Manager (Flexera Software)

    • Thanks for posting your question on Snow Globe. I’ve reviewed it for you but from my experience I am not sure that we will be able to successfully help you via Snow Globe because I believe we will need to review diagnostics or setup. If you have a direct contract with Snow Support have you contacted them to raise a support case? If you have not done so already you can do this directly via the Snow Globe Support Portal here and the Support team will be in contact.

     

    Expand Post
    • 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.

      Expand Post

Related  Product Forums


                     → Flexera One



                      → Snow Atlas



                      → FlexNet Manager



                      → Snow License Manager



                       → App Broker


       Need help finding an answer?


        Ask a Question →


Loading
Snow Inventory Garbage Collection - Slow user deletion