Results 1 to 8 of 8
  1. #1
    Join Date
    May 2009
    Posts
    13

    Unanswered: SQL Server 2005 terminating unexpectedly

    We're having to start up the SQL Service (sql server 2005 64bit, sp3) frequently after it quits with only this error in the System log:

    "The SQL Server (MSSQLSERVER) service terminated unexpectedly. It has done this 2 time(s)"

    This is happening on nearly a weekly basis. I have nothing unusual in either the SQL logs, or the Windows event logs, or the default trace.

    Any idea on how to troubleshoot?

  2. #2
    Join Date
    May 2009
    Posts
    13
    Other platform info: Winddows Server 2003 Enterprise sp2 (64 bit). SQL Server version is standard.

  3. #3
    Join Date
    Dec 2009
    Posts
    8

    AKAROUCHE Mohamed

    hi,
    re-install sql server 2005 or repair it.
    make a trace logs with the profiler on specifics parameters forecasted to troobleshoot sql server engine

    --------
    AKAROUCHE Mohamed

  4. #4
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    srsly, if your sql service is shutting off and on by itself and your server is not, and you do not have the professionals onsite to troubleshoot, I would use the support that comes with your processor liscence and call microsoft product support. especially if you spent the green on 64 bit.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  5. #5
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    barring that. have you took a look at the windows event viewer and sql server error log?
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    bullsheet

    It's a miracle

    Allah...Allah....Allah

    Allah - Wikipedia, the free encyclopedia
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  7. #7
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Check to make sure that SQL Server has a fixed amount of memory for the max server memory parameter. the 64 bit version of SQL Server is not as good at managing memory as the 32 bit version.

  8. #8
    Join Date
    May 2009
    Posts
    13
    I appreciate the replies. Unfortunately, the security, event, and system logs show nothing at the time of the terminiation. Also, nothing in the default trace file.

    We have a fixed max amount of 14GB (of 16GB of RAM). The machine has 4 quad core processors and is our workhorse for several thousand transactions per minute.

    I hate going to our Microsoft rep. He's more of a product advisor than a technical specialist and I'm going to get a lot of crap for not clustering before (and if) I get a useful reply.

    As a band-aid, we just made the service restart after one minute. We're waiting for the next failure and I was hoping someone would know of a good event class to trace for.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •