Veeam KB 1885 - Slow SQL cleanup Warning Will Robinsom!

[unsichtbarre]

I am cleaning my veeam database in response to a slow console and KB 1995.

I expected the process to take 5-10 Minutes. It is 3 hours and counting!

Do not undertake KB 1995 unless you have a significant maintenance window!

[alanbolte]

How long it takes can vary quite a bit depending on performance of the underlying hardware and how many records there are to clean up - I've seen less than 5 minutes and I've seen over 24 hours. The DropStoppedOldJobSessions stored procedure is moderately complex because it has to go through several tables and delete only those rows that are older than @retain_days. Generally before I execute that procedure I check each of the sessions tables to make sure they are only moderately large and not truly enormous, like a million rows. If there is a really big table like that, you don't mind losing all of your session history, and scheduling a maintenance window isn't practical, it can be a lot faster to just use TRUNCATE TABLE.

Always back up your configuration database before making any changes, and always contact Veeam Support if you have even the slightest doubt about what you're doing when it comes to the configuration database.