I've been having an ongoing issue with sqlserver.exe eating up all available CPU on the Zenworks server every day at about 10am and lasting between 10 and 20 minutes. My only saving grace thus far is that my DBA has limited that amount of memory and CPU that sql can use, therefore when the problem now occurs CPU utilization peaks at 50% instead of 100%. What exactly is happening is still a mystery.

I've poured through the ZCC to find anything that has a regular schedule and haven't found anything. I was able to run a sql trace, but the queries aren't anything intelligble to me. The file size is too big for the forums even zipped. If anyone is interested in the content I will post some of the lines from the trace in another post.