Comprehensive data protection for all workloads
Post Reply
dlieshout@client.nl
Service Provider
Posts: 43
Liked: 14 times
Joined: Dec 15, 2009 12:41 pm
Full Name: DaLi
Contact:

GUI extremely slow

Post by dlieshout@client.nl » Apr 22, 2015 6:55 am

Case 00884374 - Did have a v7 physical backup server with Veeam B&R. GUI was extremely slow. What was slow? Well, first the startup of the GUI can take a lot of minutes. But not the Backup Job itselves but clikcing around in the GUI. Click on Jobs, Backup and can wait 10 seconds until some minutes. Then click on Jobs, Replica and the same happens. Also go to the Repostiries etc. All very very slow. That with only about 15 Backup Jobs and 10 Replica Jobs. On the local SQL Express. First shot was updating to v8 + Update 1 with no luck. Same issue.
Now they had too little storage so a brand new HP-server installed and Import, Migrate the database. But the GUI is still very slow. My first conclusion is that the database must contain "something" which causes this slowness.
Don't know what we can do about the database or what else if it should be another thing.

Vitaliy S.
Product Manager
Posts: 23619
Liked: 1708 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: GUI extremely slow

Post by Vitaliy S. » Apr 22, 2015 10:32 am

Have you tried removing job sessions from the database with the help of our support team? What is the retention policy for your Veeam backup database?

dlieshout@client.nl
Service Provider
Posts: 43
Liked: 14 times
Joined: Dec 15, 2009 12:41 pm
Full Name: DaLi
Contact:

Re: GUI extremely slow

Post by dlieshout@client.nl » Apr 22, 2015 11:16 am

Got from Support: In rare cases the VeeamBackup SQL DB can have many thousands of previous task sessions which cause queries run by the console to be delayed. Here is an article which describes steps to troubleshoot the issue:
http://www.veeam.com/kb1995, I am installing the Studio Express right now.
Session history retention is 25 weeks.

Vitaliy S.
Product Manager
Posts: 23619
Liked: 1708 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: GUI extremely slow

Post by Vitaliy S. » Apr 22, 2015 2:02 pm

Please let us know the results after adjusting the number of stored job sessions. BTW, if you need to have historical reporting you can use Veeam ONE (part of Availability Suite) that provides reach reporting capabilities for Veeam backup.

dlieshout@client.nl
Service Provider
Posts: 43
Liked: 14 times
Joined: Dec 15, 2009 12:41 pm
Full Name: DaLi
Contact:

Re: GUI extremely slow

Post by dlieshout@client.nl » Apr 22, 2015 6:38 pm 2 people like this post

I did the KB1995. In short: stop all Veeam-services, then run the script

Code: Select all

USE [VeeamBackup]
GO
DECLARE	@return_value int
EXEC	@return_value = [dbo].[DropStoppedOldJobSessions]
		@retain_days = 30
SELECT	'Return Value' = @return_value
GO
Start all Veeam-services

It took about 1,5 hours to complete for this relative small database of 2GB. But after that ... all the GUI seems quick again like never before. Just wait for another day if the slowness has realy gone now.
Thank you Veeam Support.

dlieshout@client.nl
Service Provider
Posts: 43
Liked: 14 times
Joined: Dec 15, 2009 12:41 pm
Full Name: DaLi
Contact:

Re: GUI extremely slow

Post by dlieshout@client.nl » Apr 23, 2015 12:23 pm

Yep, also after one day the speed is still there. I guess it is fixed now. Wandering why the old records didn't clean up itself.

Vitaliy S.
Product Manager
Posts: 23619
Liked: 1708 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: GUI extremely slow

Post by Vitaliy S. » Apr 23, 2015 9:00 pm

Old records/sessions are kept and cleaned up according to your job session retention policy settings.

Post Reply

Who is online

Users browsing this forum: Bing [Bot], Google [Bot], kevlahau, MSN [Bot] and 27 guests