SQLSERVER high 100% CPU Usage

Real-time performance monitoring and troubleshooting

SQLSERVER high 100% CPU Usage

Veeam Logoby scottmattingly » Mon 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!
scottmattingly
Novice
 
Posts: 7
Liked: never
Joined: Wed Jul 29, 2009 3:19 am

Re: SQLSERVER high 100% CPU Usage

Veeam Logoby Gostev » Mon 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.
Gostev
Veeam Software
 
Posts: 21396
Liked: 2350 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: SQLSERVER high 100% CPU Usage

Veeam Logoby scottmattingly » Mon 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!
scottmattingly
Novice
 
Posts: 7
Liked: never
Joined: Wed Jul 29, 2009 3:19 am

Re: SQLSERVER high 100% CPU Usage

Veeam Logoby Gostev » Mon Dec 07, 2009 1:55 pm

Also, if you are running SQL in a VM, give it 2 or 4 vCPUs.
Gostev
Veeam Software
 
Posts: 21396
Liked: 2350 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland


Return to Monitoring



Who is online

Users browsing this forum: Bing [Bot] and 3 guests