Microsoft SQL Server 2008 Enterprise & Microsoft SQL Server 2008 R2 Enterprise using page compression can experience access violations and unexpected shutdowns, leading to data corruption in Microsoft Team Foundation Server.
You may see this error with SQL Server 2008:
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.)
This may manifest itself as an 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. On SQL 2008 R2 there may be errors in the SQL Server error log indicating that EXCEPTION_ACCESS_VIOLATION has occurred. Here is a portion of one such occurrence, which happened in a call to stored procedure dbo.prc_Update_ForwardDeleted_CSS_Nodes from the Tfs_Warehouse database:
Issues internal to SQL Server cause these problems.
TFS 2010 Customers using SQL Server 2008 or SQL Server 2008 R2 Enterprise Edition should apply the latest Service Packs and Cumulative Updates to address the problem. The minimum patching level for your TFS data tier server(s) is as follows:
Since this issue only impacts customers using page compression, it is only applicable to customers running SQL Enterprise Edition. TFS customers on SQL Standard & Express are not impacted. Note: TFS configuration will enable page compression by default during installation if a SQL Server Enterprise Edition is being used.
SQL TFS Team Foundation Server compression corruption transport-level pipe Enterprise