SQL Server restarts automatically

  • Hi,

    One of the servers gets restarted automatically. I found the below error message in error log

    "The client was unable to reuse a session with SPID XX, which had been reset for connection pooling. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message."

    I also see lots and lots of login failures after which the server restart. Any idea why this happens? Its a SQL Server 2008 box and has 16 CPU's with 32 GB of RAM. AWE is enabled

    Any help is appreciated...

  • karthik -450760 (4/6/2010)


    Hi,

    One of the servers gets restarted automatically. I found the below error message in error log

    "The client was unable to reuse a session with SPID XX, which had been reset for connection pooling. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message."

    I also see lots and lots of login failures after which the server restart. Any idea why this happens? Its a SQL Server 2008 box and has 16 CPU's with 32 GB of RAM. AWE is enabled

    Any help is appreciated...

    Question: Is it a 32 or 64 bit version of SQL. If it's 64, AWE is ignored. A 64 bit OS and SQL can natively address a larger memory space.

    Login failures are common during startup, if the default database for the user is not ready to accept connection, the account will fail to login. You will probably notice that the login failures stop after the database has completed recovery.

    /* ----------------------------- */
    Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

  • thanks for the reply... Its a 32 Bit.. and the login failures happens after the database is restored.. Application users complain that their job gets disconnected in b/w and all i can see are login failures... Any ideas on the connection pooling error?

  • Why does the server get restarted automatically?

    /* ----------------------------- */
    Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!

  • What do the windows logs say? Are there any logs around the times before the server shuts down that can shed any light as to why the server could be rebooting?

    Joie Andrew
    "Since 1982"

  • All these messages are perfectly normal, and just reflect the fact that the database is being recovered and brought online.

Viewing 6 posts - 1 through 5 (of 5 total)

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