Comprehensive data protection for all workloads
Post Reply
lando_uk
Expert
Posts: 302
Liked: 22 times
Joined: Oct 17, 2013 10:02 am
Full Name: Mark
Location: UK
Contact:

Veeam management server slow due to SQL

Post by lando_uk » Oct 08, 2014 10:15 am

Hi

Our Veeam Management server is getting slower and slower. The VeeamBackup.mdf is now 3.5GB, and clicking through various sections sometimes has long delays.

In the windows resource manager, under the Disk section, the Disk Queue goes up to 200+ when doing stuff inside the manager - obviously that's painfully slow.

Do we have to move the SQL to an external box? Or is there some local cleanup that can be performed?

Thanks

lando_uk
Expert
Posts: 302
Liked: 22 times
Joined: Oct 17, 2013 10:02 am
Full Name: Mark
Location: UK
Contact:

Re: Veeam management server slow due to SQL

Post by lando_uk » Oct 08, 2014 11:12 am

The server in question is Dell R720xd, c: is on 2 x 10K SAS and all the other slots are used for a repository - So not as easy as just moving the DB/Logs to different disks.

foggy
Veeam Software
Posts: 18021
Liked: 1530 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Veeam management server slow due to SQL

Post by foggy » Oct 08, 2014 11:14 am

Mark, slowness might be caused by the number of job session records in the configuration database. Btw, what SQL Server version are you running and what is the size of your backup environment? Anyway, I believe support will be able to assist you in database cleanup, if required. Have you already contacted them? Thanks.

lando_uk
Expert
Posts: 302
Liked: 22 times
Joined: Oct 17, 2013 10:02 am
Full Name: Mark
Location: UK
Contact:

Re: Veeam management server slow due to SQL

Post by lando_uk » Oct 08, 2014 12:17 pm

Hi Foggy
I have 13 Backup jobs and 17 Backup Copy Jobs, about 300 VM's.
4 Proxies and 7 Repositories.
10.50.2500.0 SP1 Express Edition (64-bit)

foggy
Veeam Software
Posts: 18021
Liked: 1530 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Veeam management server slow due to SQL

Post by foggy » Oct 08, 2014 3:48 pm

Databases of this size are considered relatively large, so probably you need to purge some historical data to make it smaller. I recommend contacting support.

dellock6
Veeam Software
Posts: 5683
Liked: 1603 times
Joined: Jul 26, 2009 3:39 pm
Full Name: Luca Dell'Oca
Location: Varese, Italy
Contact:

Re: Veeam management server slow due to SQL

Post by dellock6 » Oct 11, 2014 7:44 pm

Also remember the SQL Express is limited not only on data size but most of all to cpu, it can only use a single core. Check also the cpu usage of the SQL process to see if also cpu is a limit there. IF it's the case, then yes upgrading to SQL standard is a reccommended practice.
Luca Dell'Oca
Principal EMEA Cloud Architect @ Veeam Software

@dellock6
https://www.virtualtothecore.com/
vExpert 2011 -> 2019
Veeam VMCE #1

Post Reply

Who is online

Users browsing this forum: Bing [Bot], Nnarkozz and 23 guests