Posted by: Colin Smith
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.
I applied SP2 and have not seen the issue since. Hope this will help.