troubleshooting Question

Windows 2003Server hanging, info points to SQLSERVERAGENT

Avatar of ocdteam
ocdteam asked on
Operating SystemsMicrosoft SQL ServerWindows Server 2003
5 Comments1 Solution310 ViewsLast Modified:
Hi,

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:

http://img.photobucket.com/albums/v446/DK199/170707shutdown.jpg
http://img.photobucket.com/albums/v446/DK199/190707shutdown.jpg
http://img.photobucket.com/albums/v446/DK199/200707shutdown.jpg

The screen shot below shows the application log with a filter inplace removing all the 'information' entries:

ttp://img.photobucket.com/albums/v446/DK199/SQLSERVERAGENT.jpg

Finally the link for the System log to show all the main errors that have happened:

http://img.photobucket.com/albums/v446/DK199/Systemevents.jpg

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.

David





Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros