The Multifunctioning DBA

Jun 21 2011   3:54PM GMT

SPIDS disconnecting from DB



Posted by: Colin Smith
Tags:
Performance
SP
SPIDS drop

Ever run into the following issue?

<Date><Time> <spid> Error: 18056, Severity: 20, State: 29.

I did and it was a mess. Production system just starting dropping spids. It finally stopped with me doing nothing except trying to find out what it was. It took a while but I finally got it figured out. This is a bug in SQL Server 2008 and is patched in SP1 CU14. Here is a link to the article.

http://support.microsoft.com/kb/2543687

I applied SP2 and have not seen the issue since. Hope this will help.

 Comment on this Post

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: