One of my clients servers is hanging every day or so and explorer.exe and other processes are shutting down. It is still possible to ping its NIC but it does not respond to any mouse, keyboard or remote control functions. Only the backgroud blue wallpaper is displayed when you look at the monitor.
Further investigation using the event log has given me clues to what is happening. It seems to be a problem with the SQLSERVERAGENT.
I have collated a number of screenshots to show what is happening:
The following 3 are the unexpected shutdown errors - all around 8:00pm at night:
The screen shot below shows the application log with a filter inplace removing all the 'information' entries:
Finally the link for the System log to show all the main errors that have happened:
If you look at the shutdown times then look at the application screenshot you will see that there is a link. The warnings regarding the SQLSERVERAGENT happen nearly every hour on thr hour and each time they stop at 7:00pm and the shutdowns happen at 8:00pm.
It is a new server with Windows Server 2003 with all the latest updates. Checked and there are no available updates from Microsoft update for server 2003 or SQL.
It has Mcafee anti-virus install and there is a full server backup using Acronis True Image that happens every night at 11:00pm.
Any help rgarding this would be much appreciated.