One query used in an alert was failing for some reason. And it was being called every minute. Not sure why because we had set it to run only one time each day. We ran some sql queries to know what was running inside sql when CPU usage went to 100%. We found that alert query and disabled it and CPU usage immediately became normal and SBO clients also became normal and problem fixed.
Add comment