Data collection bad SQL

Real-time performance monitoring and troubleshooting

Data collection bad SQL

Veeam Logoby afidel » Mon Dec 05, 2011 9:11 pm

My SQL Express volume filled up so I moved the database to a full SQL Enterprise instance, however now whenever I start up the data collector my server maxes its CPU within about 3-5 minutes. The offending SQL is summarazied as:

"IF EXISTS( SELECT * FROM VwEvent WHERE ABS( DATEDIFF( ms, time, @i_Time) ) < 5 AND @i_HostId = host_id AND internal_id = @i_InternalId )"

This is running thousands and thousands of times in just a few minutes generating millions of logical SQL reads. Any clue on why the data collector would be trying to poll for events every 5ms?
afidel
Lurker
 
Posts: 2
Liked: never
Joined: Thu Jul 29, 2010 9:17 pm

Re: Data collection bad SQL

Veeam Logoby Vitaly.Mzokov » Mon Dec 05, 2011 9:19 pm

I haven't heard this issue reported before, so please open a support ticket to investigate this behavior, as most likely we would need to take a closer look at your SQL database via WebEx sessions. Thank you!
Vitaly.Mzokov
Expert
 
Posts: 173
Liked: 25 times
Joined: Mon Aug 23, 2010 8:30 am
Full Name: Vitaliy Mzokov


Return to Monitoring



Who is online

Users browsing this forum: No registered users and 2 guests