Real-time performance monitoring and troubleshooting
Post Reply
scottmattingly
Novice
Posts: 7
Liked: never
Joined: Jul 29, 2009 3:19 am
Contact:

SQLSERVER high 100% CPU Usage

Post by scottmattingly » Dec 07, 2009 11:53 am

We are having issues with the CPU on our monitor server pegging at 100%. Seems like SQLSERVER and VEEAMDCS are the highest processes. Mostly it is SQLSERVER at 80 - 90% we have 110 hosts monitoring and are running 4.5 We have had this issue in 4.0, 4.01, and now 4.5. We see the issue in Typical or Advanced collection modes. I saw some posts on this being fixed in 4.01, but we still have such a high CPU usage. Any ideas on what we can do to get this to be useable for us?

Thanks!

Gostev
SVP, Product Management
Posts: 24017
Liked: 3254 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQLSERVER high 100% CPU Usage

Post by Gostev » Dec 07, 2009 12:18 pm

Scott, this is because of the size of you environment. We recommend using standalone SQL server for large environments, instead of running local SQL Express installation on Veeam Monitor server.

scottmattingly
Novice
Posts: 7
Liked: never
Joined: Jul 29, 2009 3:19 am
Contact:

Re: SQLSERVER high 100% CPU Usage

Post by scottmattingly » Dec 07, 2009 1:52 pm

OK, I can try that. I'll bring up a new SQL server and see if that helps.

Thanks!

Gostev
SVP, Product Management
Posts: 24017
Liked: 3254 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQLSERVER high 100% CPU Usage

Post by Gostev » Dec 07, 2009 1:55 pm

Also, if you are running SQL in a VM, give it 2 or 4 vCPUs.

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest