Veeam One database spike at 3 am

Monitoring and reporting for Veeam Backup & Replication, VMware vSphere and Microsoft Hyper-V

Veeam One database spike at 3 am

Veeam Logoby EricIsCool » Wed Sep 17, 2014 4:02 pm

I am currently using the Veeam One free edition (7.0.0.919). I have it configured to use a standalone SQL Server database rather than SQL Express.

I am running into an issue that occurs every night at 3 am on the database server. Each night at 3 am a SQL query gets executed that causes all of the CPU cores to max out at 100%. The query runs until I reboot the Veeam One application server (around 8 am).

I am not exactly sure if this is a setting that can be adjusted or if it is a nightly process that is built into the product. If it helps I can review/submit any log files or even submit the SQL query that is running at the time of the CPU spike. Any help or insight on this would be great!

Thanks!
EricIsCool
Lurker
 
Posts: 2
Liked: never
Joined: Wed Sep 17, 2014 3:49 pm
Full Name: Eric

Re: Veeam One database spike at 3 am

Veeam Logoby Vitaliy S. » Wed Sep 17, 2014 4:14 pm

What time does your data collection job stats in Veeam ONE Reporter? Can you please check that?
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Veeam One database spike at 3 am

Veeam Logoby Vitaliy S. » Wed Sep 17, 2014 6:29 pm

Eric, I have discussed your issue with the dev team and they would like to see the debug logs on the issue. Can you open the case and let me know your ticket number?
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Veeam One database spike at 3 am

Veeam Logoby EricIsCool » Wed Sep 17, 2014 10:04 pm

Thank you for the quick reply!

I just checked the Veeam ONE Reporter and saw these 2 session logs that might be of interest. Is it possible there is a resource conflict since both jobs start at 3 am? I will work on getting a ticket opened as well.
EricIsCool
Lurker
 
Posts: 2
Liked: never
Joined: Wed Sep 17, 2014 3:49 pm
Full Name: Eric

Re: Veeam One database spike at 3 am

Veeam Logoby Vitaliy S. » Thu Sep 18, 2014 7:56 am

Hi Eric,

There should be no issues with two jobs scheduled at the same time, so let's see what our support team can find out after reviewing your log files.

Thanks!
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov


Return to Veeam ONE



Who is online

Users browsing this forum: No registered users and 2 guests