Real-time performance monitoring and troubleshooting
Post Reply
afidel
Lurker
Posts: 2
Liked: never
Joined: Jul 29, 2010 9:17 pm
Contact:

Data collection bad SQL

Post by afidel »

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?
Vitaly.Mzokov
Expert
Posts: 173
Liked: 25 times
Joined: Aug 23, 2010 8:30 am
Full Name: Vitaliy Mzokov
Contact:

Re: Data collection bad SQL

Post by Vitaly.Mzokov »

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!
Post Reply

Who is online

Users browsing this forum: No registered users and 6 guests