• 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!