Comprehensive data protection for all workloads
Post Reply
Zew
Veteran
Posts: 365
Liked: 80 times
Joined: Mar 17, 2015 9:50 pm
Full Name: Aemilianus Kehler
Contact:

Local SQL resource Usage

Post by Zew »

I've noticed the CPU usage hovering rather high even for idle on the Veeam server.
Checking the resources shows to be the local sql instance.
For fun I tried to stop the instance to see what would happen (yeah Veeam BR app didn't like that).

Why does the local SQL have such a high idle load?
PetrM
Veeam Software
Posts: 3264
Liked: 528 times
Joined: Aug 28, 2013 8:23 am
Full Name: Petr Makarov
Location: Prague, Czech Republic
Contact:

Re: Local SQL resource Usage

Post by PetrM »

Hello,

There are many possible reasons, maybe some background tasks query Veeam database extensively and it results in high CPU usage. You may try to check most expensive queries, it might help to understand what kind of activity represents a "hot spot".

Since we're talking about technical issue, I strongly recommend to contact our support team and share the support case ID with us. The posts about technical issues without case number can be removed by moderator according to forum rules.

Thanks!
Zew
Veteran
Posts: 365
Liked: 80 times
Joined: Mar 17, 2015 9:50 pm
Full Name: Aemilianus Kehler
Contact:

Re: Local SQL resource Usage

Post by Zew »

This was more a general question. Will eventually try SQL resource hunting soon and will blog when time permits. Will also validate this usage compared to my home lab running CE
Thanks.
Post Reply

Who is online

Users browsing this forum: Google [Bot] and 105 guests