Data Collector Service spikes CPU on SQL server

Real-time performance monitoring and troubleshooting

Data Collector Service spikes CPU on SQL server

Veeam Logoby withanh » Mon Sep 12, 2011 8:58 pm

I'm just getting around to reinstalling/reconfiguring the Veeam Monitor. After installing, I noticed that the sqlservr.exe service on the remote SQL server is spiking up to 100%. I have positively determined it is the Veeam Data Collector Services. When I start the service on <serv1> the sqlservr.exe service on <sql01> spikes up, when I stop the Veeam DCS, the spike drops. I let it run for a bit thinking it was just sorting things out and doing an initial collection, but after about 15 minutes I started getting worried that it wasn't going to stop, so I killed the Veeam DCS.

Not sure if this matters or not, but there is also Veeam Business View and Veeam Reporter installed on the same (<serv1>) box.

Thanks!

Darhl
For every expert there is an equal and opposite expert - Arthur C Clarke's Fourth Law
withanh
Expert
 
Posts: 256
Liked: never
Joined: Tue Jul 21, 2009 3:19 pm
Location: Pacific Northwest
Full Name: Darhl

Re: Data Collector Service spikes CPU on SQL server

Veeam Logoby Vitaliy S. » Tue Sep 13, 2011 7:04 am

Hello Darhl,

Having Reporter and BV database on the same server cannot cause such misbehavior. I wonder what information is in Veeam Monitor log files, can you drop an email to our support team with the reference to this topic?

Thanks.
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Data Collector Service spikes CPU on SQL server

Veeam Logoby withanh » Tue Sep 13, 2011 1:55 pm

Will do Vitaliy, thanks!

*edit* Which logs should I send in?

d
For every expert there is an equal and opposite expert - Arthur C Clarke's Fourth Law
withanh
Expert
 
Posts: 256
Liked: never
Joined: Tue Jul 21, 2009 3:19 pm
Location: Pacific Northwest
Full Name: Darhl

Re: Data Collector Service spikes CPU on SQL server

Veeam Logoby withanh » Tue Sep 13, 2011 2:57 pm

Case # 5145911
For every expert there is an equal and opposite expert - Arthur C Clarke's Fourth Law
withanh
Expert
 
Posts: 256
Liked: never
Joined: Tue Jul 21, 2009 3:19 pm
Location: Pacific Northwest
Full Name: Darhl

Re: Data Collector Service spikes CPU on SQL server

Veeam Logoby Ubuntop » Wed Feb 22, 2012 4:10 pm

Was there ever a resolution to this? I have a similar issue.
sqlserver is 100% which can be tracked to the following query.
IF EXISTS( SELECT * FROM VwEvent WHERE ABS( DATEDIFF( ms, time, @i_Time) ) < 5 AND @i_HostId = host_id AND internal_id = @i_InternalId )

As soon as I stop the collector service, CPU goes back to averaging 2%.
Ubuntop
Lurker
 
Posts: 2
Liked: never
Joined: Sun May 02, 2010 5:01 pm

Re: Data Collector Service spikes CPU on SQL server

Veeam Logoby Vitaliy S. » Wed Feb 22, 2012 4:19 pm

Based on Darhl's support case, it appears that our latest hot-fix and database recreation did the trick, so please contact our support team for assistance wit this issue directly.
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: Data Collector Service spikes CPU on SQL server

Veeam Logoby withanh » Wed Feb 22, 2012 4:23 pm

I apologize for not posting that result, but Vitaliy is correct.

h
For every expert there is an equal and opposite expert - Arthur C Clarke's Fourth Law
withanh
Expert
 
Posts: 256
Liked: never
Joined: Tue Jul 21, 2009 3:19 pm
Location: Pacific Northwest
Full Name: Darhl


Return to Monitoring



Who is online

Users browsing this forum: No registered users and 3 guests