Post reply

Server Hang

  • July 16, 2007 at 2:20 am

    #196858

    SQL Server 2005 was installed some 3 months ago and we have had no problems with the 3 databases we have created.

    On Saturday the server hung and was re-started (by a colleague).

    At the time of the 'hang' a user was logged in via the front end app using remote desktop (which he does every weekend normally with no problems!)

    I have looked at the error logs and cannot find anything there, all backups/transaction logs up to the point of 'hang' completed sucessfully - I am really struggling to identify what caused the problem.

    Must add that I am fairly new to SQL Server. Could anyone point me in the direction for trying to determine why this happened?

    Looking at the Activity Monitor first thing Monday morning did have a suspended process (Database Mail delete command - BROKER_RECEIVE_WAITFOR) but that has now cleared. And everything seems to be running OK again.

    Thanks in advance for any assistance provided.

    Mark

     

     

  • July 16, 2007 at 3:57 am

    #719605

    Looking at the Activity Monitor first thing Monday morning did have a suspended process (Database Mail delete command - BROKER_RECEIVE_WAITFOR) but that has now cleared. And everything seems to be running OK again.

    Your processes would have got disconnected and new process added to sql server once restarted. SWo you will not be able t use the current status to diagonis issue that happened on saturday. The best resources to find would be event viewer, sql server error log and the application log file. look into that to see what had happened.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • July 18, 2007 at 1:57 am

    #720294

    Thanks for advice.

    sql server log had no entries, to cut a long story short the culprit appears to be the ups - which shut the server down. This is currently being looked at by one of our electricians.

    Been running Ok since, I have also set up a number of alerts in sql server agent to keep me more informed of events.

    Cheers.

  • July 19, 2007 at 4:13 am

    #720670

    Also set up and alert when the sql service goes down so that you know your service is down and can do something

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply