?
Solved

Windows 2003Server hanging, info points to SQLSERVERAGENT

Posted on 2007-07-23
6
Medium Priority
?
285 Views
Last Modified: 2012-06-21
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





0
Comment
Question by:ocdteam
  • 2
  • 2
5 Comments
 
LVL 11

Expert Comment

by:deroby
ID: 19546070
Actually, the first 3 screenshots all show that "the previous shutdown was unexpected". What happens here is that the Evenlog notices that the machine is coming back online, but that there is no 'previous shutdown' record to be found in the log. Meaning, the machine was hard-reset or hard-shutdown somewhere before 8:00.
Looking at the other screenshots, I don't see much other info that would point in me in this or such direction.

The warnings on SQLAgent are most likely NOT the cause of your error. It's probably a good idea to look into them, but if there's a warning that often without serious problems, why would they cause the machine to hang once in a while ??

IMHO you will have to look else where. To me it looks like the machine is hung do to some OS problem, I very much doubt sql-agent (or sql-server) would be the cause of this.
0
 

Author Comment

by:ocdteam
ID: 20184937
Just found this issue still open.

Issue was SQL. The company that installed it had setup multiple backups inside sql and two conflicted with times that they ran somehow causing server to freeze.

Thanks for input anyway
0
 
LVL 11

Expert Comment

by:deroby
ID: 20214732
Strange, but good it's solved =)
0
 

Author Comment

by:ocdteam
ID: 20813582
Issue was SQL backups running at same time
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 21091566
PAQed with points refunded (500)

Computer101
EE Admin
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

While rebooting windows server 2003 server , it's showing "active directory rebuilding indices please wait" at startup. It took a little while for this process to complete and once we logged on not all the services were started so another reboot is …
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question