SQL CPU Usage Maxed out

Real-time performance monitoring and troubleshooting

SQL CPU Usage Maxed out

Veeam Logoby MP3 » Thu May 07, 2009 12:27 pm

In testing VEEAM on a VM with a 1.5Ghz processor and 512MB Ram. The combination of VEEAM and SQL are using 100% of the CPU thus making the use of the program ineffective. Even when adjusting the CPU to as high as 3Ghz, it is consistently using 100% of the CPU.

Has anyone else had or seen this problem? If so, what changes did you make to avoid such high CPU usage?
MP3
Lurker
 
Posts: 2
Liked: never
Joined: Thu May 07, 2009 12:22 pm
Full Name: MPete Three

Re: VEEAM CPU Usage Maxed out

Veeam Logoby Gostev » Thu May 07, 2009 1:11 pm

What process causes this load according to Windows Task Manager on that VM?
Gostev
Veeam Software
 
Posts: 21396
Liked: 2349 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: VEEAM CPU Usage Maxed out

Veeam Logoby MP3 » Thu May 07, 2009 2:04 pm

The primary usage is coming from sqlsrvr.exe. It runs at 85-95% with Veeam occasionally pulling 5-8% and maxing out the CPU. Is there a setting within VEEAM that would cause this?
MP3
Lurker
 
Posts: 2
Liked: never
Joined: Thu May 07, 2009 12:22 pm
Full Name: MPete Three

Re: VEEAM CPU Usage Maxed out

Veeam Logoby Gostev » Thu May 07, 2009 2:56 pm

Changing scalability mode to "Advanced" should reduce frequency and amount of data gathered by Veeam Monitor and stored in SQL, so this should help with SQL server load. Overall, real-time monitoring of decently sized environments in "typical" scalability mode does result in large amounts of performance data that needs to be processed, so if your SQL is running inside of the VM, high load is expected.

We have also made numerous optimizations in upcoming Monitor 4.0, so that should help to reduce load as well.
Gostev
Veeam Software
 
Posts: 21396
Liked: 2349 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: VEEAM CPU Usage Maxed out

Veeam Logoby tomrowan » Wed Jun 03, 2009 4:14 pm

I have exactly the same issue with the SQL server executable --> and I've got Monitor v4.0.
I am running in typical mode.
tomrowan
Novice
 
Posts: 3
Liked: never
Joined: Wed Jun 03, 2009 3:29 pm
Location: Bracknell, UK
Full Name: Tom Rowan

Re: VEEAM CPU Usage Maxed out

Veeam Logoby Gostev » Wed Jun 03, 2009 7:04 pm

We are working on one experimental mod to reduce CPU load on SQL server, if anyone having this problem is interested in beta testing please PM me.
Gostev
Veeam Software
 
Posts: 21396
Liked: 2349 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: VEEAM CPU Usage Maxed out

Veeam Logoby tomrowan » Thu Jun 04, 2009 9:49 am

PM Sent
tomrowan
Novice
 
Posts: 3
Liked: never
Joined: Wed Jun 03, 2009 3:29 pm
Location: Bracknell, UK
Full Name: Tom Rowan

Re: VEEAM CPU Usage Maxed out

Veeam Logoby Gostev » Thu Jun 11, 2009 7:33 pm

Beta build is now available. It should significantly lower SQL CPU usage, and also increase performance data refresh frequency significantly for large environments (100+ ESX hosts). If anyone is interested in beta test, please PM me. Thank you!
Gostev
Veeam Software
 
Posts: 21396
Liked: 2349 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: SQL CPU Usage Maxed out

Veeam Logoby Gostev » Wed Jul 08, 2009 10:25 pm

Just a little update. The beta build was tested by a couple of volunteer beta testers from our community (thanks again) and both confirmed that SQL server usage is barely noticeable now. We will be releasing this and a few other fixes as a part of maintenance release around the end of July, after we complete the testing (fix will require some database data updates, so upgrade procedure will require some heavy testing). Thanks.
Gostev
Veeam Software
 
Posts: 21396
Liked: 2349 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland


Return to Monitoring



Who is online

Users browsing this forum: No registered users and 2 guests