Comprehensive data protection for all workloads
- Posts: 111
- Liked: 21 times
- Joined: Mar 08, 2010 4:05 pm
- Full Name: John Borhek
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
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.
Users browsing this forum: Baidu [Spider] and 29 guests