XenCenter CPU 100% at 11:30 every day

My Client is running XenServer 4.1 on 1 Host with Two Virtual Server Win2003. Every day at 11:30 one of the 2 VM's (that runs MSSQL) CPU goes to 100% and users application that connects to it fails with errors.. A ping test only return's a ping every 5th or 6th try. Needless to say users of the application that conencts to SQL are upset. i watched it today happen and It was so bad that I couldn't even get the task manager up to see what was running and taking up the resources.  So my question is; Is there a good app to monitor what applications are running and their CPU/memory usage that gets logged to view later?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

perfmon will do the job for you - or if it is that reproducable - every day at 11:30 : you may start Taskmanager at 11:29h (or before) and let it show the running processes ordered by cpu-usage.
Then you may see which process consumes the power...

fuvegesAuthor Commented:
The problem with Perfmon is you have to know what the offending process is..
I used process Laso with some success. it give you the Average CPU usage as well as some other info..  It turns out it was our Kaseya agent taking inventory!! I uninstalled it and things are fine now... thanks!!!

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
fuvegesAuthor Commented:
I tried the other solutions mentioned and although a good start, not what I was asking for...
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Server Apps

From novice to tech pro — start learning today.