Veeam 9 Strange SQL-DB Performance Changes

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

Veeam 9 Strange SQL-DB Performance Changes

Veeam Logoby mbietz » Mon Feb 15, 2016 7:12 pm

Hello,

since I upgraded to Veeam 9, there is much more stress on the SQL-Server which is hosting the veeam-database.

With Veeam 8 the performance counter for "SQL Database - DB Transactions/sec" for the veeam-database is averaged by 1, with a little spike at 01:15 am.
Now with Veeam 9 the performance counter is now averaged by 11 and with high spikes at 01:15 which goes up to 60.

Also the CPU of the SQL-Server is now going high at 01:15 and 3:15, and there is a high write I/o to the sql-sever disk at 01:15, with massive write throughput to disk.

All this started, since I upgraded to Veeam 9.

Do you know what is going on there?

Thank You.

Michael
mbietz
Influencer
 
Posts: 21
Liked: 3 times
Joined: Fri Jul 10, 2015 9:18 am

Re: Veeam 9 Strange SQL-DB Performance Changes

Veeam Logoby Vitaliy S. » Mon Feb 15, 2016 7:54 pm

Michael,

How many objects do you monitor in the infrastructure? Are you using typical or advanced mode?

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

Re: Veeam 9 Strange SQL-DB Performance Changes

Veeam Logoby Vitaliy S. » Tue Feb 16, 2016 12:48 pm

Michael, I have discussed your question with our dev team. Higher load is expected at the initial time, when database is upgraded and re-indexed. Depending on the infrastructure size it can take some time. Can you please answer my previous question and let us your current DB performance?
Vitaliy S.
Veeam Software
 
Posts: 19545
Liked: 1099 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Veeam 9 Strange SQL-DB Performance Changes

Veeam Logoby mbietz » Tue Feb 16, 2016 1:32 pm

Hello Vitaliy,

well, I monitor following objects

12 ESXi Hosts.
80 Datastores.
320 Virtual Machines.

I am using "typical"

I also see a permanent write access on the Veeam-One Server in the directory c:\users\...\appdata\local\veeam\veeam one monitor\perfcache since the update to Version 9

Regards

Michael
mbietz
Influencer
 
Posts: 21
Liked: 3 times
Joined: Fri Jul 10, 2015 9:18 am

Re: Veeam 9 Strange SQL-DB Performance Changes

Veeam Logoby Vitaliy S. » Tue Feb 16, 2016 1:44 pm

You can specify a different folder for performance data cache (the directory you're seeing permanent writes to). Our support team can assist you with this setting. Please reference this thread, so that they can quickly understand what option you need to change.
Vitaliy S.
Veeam Software
 
Posts: 19545
Liked: 1099 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Veeam 9 Strange SQL-DB Performance Changes

Veeam Logoby mbietz » Tue Feb 16, 2016 2:19 pm 1 person likes this post

I opened a case for that, and attached a detail graphs, where you can see the changed behaviour.
# 01700221

Thank You

Michael

P.s. I have two more minor bugs found in Veeam-One 9, for which I will also create cases.
mbietz
Influencer
 
Posts: 21
Liked: 3 times
Joined: Fri Jul 10, 2015 9:18 am

Re: Veeam 9 Strange SQL-DB Performance Changes

Veeam Logoby Vitaliy S. » Thu Feb 18, 2016 10:13 am

Here is the KB article on how to change the location of performance data cache directory: https://www.veeam.com/kb2100
Vitaliy S.
Veeam Software
 
Posts: 19545
Liked: 1099 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 6 guests