Monitoring and reporting for Veeam Backup & Replication, VMware vSphere and Microsoft Hyper-V
Post Reply
mbietz
Influencer
Posts: 23
Liked: 3 times
Joined: Jul 10, 2015 9:18 am
Contact:

Veeam 9 Strange SQL-DB Performance Changes

Post by mbietz » 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

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

Re: Veeam 9 Strange SQL-DB Performance Changes

Post by Vitaliy S. » 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.
Product Manager
Posts: 22777
Liked: 1526 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Veeam 9 Strange SQL-DB Performance Changes

Post by Vitaliy S. » 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?

mbietz
Influencer
Posts: 23
Liked: 3 times
Joined: Jul 10, 2015 9:18 am
Contact:

Re: Veeam 9 Strange SQL-DB Performance Changes

Post by mbietz » 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

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

Re: Veeam 9 Strange SQL-DB Performance Changes

Post by Vitaliy S. » 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.

mbietz
Influencer
Posts: 23
Liked: 3 times
Joined: Jul 10, 2015 9:18 am
Contact:

Re: Veeam 9 Strange SQL-DB Performance Changes

Post by mbietz » 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.

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

Re: Veeam 9 Strange SQL-DB Performance Changes

Post by Vitaliy S. » 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

Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests