<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 7,2000
»
In The Enterprise
»
SQL Server restarts automatically
SQL Server restarts automatically
Rate Topic
Display Mode
Topic Options
Author
Message
karthik -450760
karthik -450760
Posted Tuesday, April 06, 2010 4:18 PM
SSC Rookie
Group: General Forum Members
Last Login: Monday, May 31, 2010 1:05 PM
Points: 44,
Visits: 245
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...
Post #897990
GregoryF
GregoryF
Posted Tuesday, April 06, 2010 4:22 PM
SSC Eights!
Group: General Forum Members
Last Login: Today @ 6:45 AM
Points: 961,
Visits: 795
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!
Post #897992
karthik -450760
karthik -450760
Posted Tuesday, April 06, 2010 4:24 PM
SSC Rookie
Group: General Forum Members
Last Login: Monday, May 31, 2010 1:05 PM
Points: 44,
Visits: 245
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?
Post #897994
GregoryF
GregoryF
Posted Tuesday, April 06, 2010 4:26 PM
SSC Eights!
Group: General Forum Members
Last Login: Today @ 6:45 AM
Points: 961,
Visits: 795
Why does the server get restarted automatically?
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
Post #897996
Joie Andrew
Joie Andrew
Posted Tuesday, April 06, 2010 4:54 PM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Monday, May 06, 2013 5:58 AM
Points: 535,
Visits: 1,010
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"
Post #898010
Paul White
Paul White
Posted Tuesday, April 06, 2010 5:07 PM
SSChampion
Group: General Forum Members
Last Login: Wednesday, May 08, 2013 10:33 AM
Points: 10,989,
Visits: 10,529
All these messages are perfectly normal, and just reflect the fact that the database is being recovered and brought online.
Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi
Post #898014
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
