Comprehensive data protection for all workloads
Post Reply
Posts: 130
Liked: 24 times
Joined: Mar 08, 2010 4:05 pm
Full Name: John Borhek

Veeam KB 1885 - Slow SQL cleanup Warning Will Robinsom!

Post by unsichtbarre » May 14, 2015 6:58 pm

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!
-The Invisible Admin-

Posts: 635
Liked: 172 times
Joined: Jun 18, 2012 8:58 pm
Full Name: Alan Bolte

Re: Veeam KB 1885 - Slow SQL cleanup Warning Will Robinsom!

Post by alanbolte » May 15, 2015 4:04 am

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.

Post Reply

Who is online

Users browsing this forum: Bing [Bot], mkretzer, Motty and 49 guests