I am having a problem with MS SQL Server 2008 where some of the jobs stopped but I could not find out who or what might be causing it because the server timed-out. I also checked the CPU to see if there is high CPU usage but it seems to be running fine. How can I find out who or what could have stopped some jobs and what are the possible ways I can prevent it from happening again?
Hy
It may happen for run multiple programs in same time. If you run multiple programs in same them then your CPU usage will increase and it may occurs this type of problem which you mentioned above. Sometimes applications or programs are run automatically in computer for auto start up function. You can disable auto start up for all applications of your computer. It will prevent your high CPU usage.
To disable auto startup select start button and then select run option and then write msconfig in that text field. Now press enter and then you will get a new window and then click startup tab form that window. Finally select disable all and then restart your computer.
Â
Thanks
