搜尋本站文章

2012-03-10

TFS 2010 搭配 SQL Server 2008 可能會意外當機

影響環境:
1. SQL Server 2008、2008 R2 Enterprise Edition。
2. TFS 2010 或是 TFS 11 preview 版本。

SQL Server 2008 支援「頁面壓縮(page compression)」,但這項功能與 TFS 搭配時,可能會導致意外當機。

遭遇的錯誤訊息是:
Msg 109, Level 20, State 0, Line 0

A transport-level error has occurred when receiving results from the server. 
(provider: Shared Memory Provider, error: 0 - The pipe has been ended.)

可能的解決作法:
1. SQL Server 2008 Enterprise Edition 搭配 TFS,建議:升級到 SP1 CU6(2011/04/07) 以上,或是 SP2。

2. SQL Server 2008 R2 Enterprise Edition 搭配 TFS,建議:升級到 RTM CU7(2011/06/16) 以上,或是 SP1 CU1(2011/08/25)。




參考資料

Make sure your SQL Server enterprise edition is up to date
http://blogs.msdn.com/b/bharry/archive/2012/02/01/make-sure-your-sql-server-enterprise-edition-is-up-to-date.aspx

TFS data corruption with SQL Server 2008 & 2008 R2 Enterprise
http://support.microsoft.com/kb/2668489

FIX: Access violation when you insert data into a new partition of a partitioned table after you drop a column of the table in SQL Server 2008 R2
http://support.microsoft.com/default.aspx?scid=kb;EN-US;2504090