FIX: Poor performance on I/O when you execute select into temporary table operation in SQL Server 2012

Gælder for: SQL Server 2012 EnterpriseSQL Server 2012 DeveloperSQL Server 2012 Standard

Symptoms


Assume that you use Microsoft SQL Server 2012. When you perform select into temporary table operation, poor performance on I/O occurs in the system database tempdb.

Cause


The issue occurs because a select into temporary table operation causes eager write.

Resolution


The issue was first fixed in the following cumulative update of SQL Server.

Cumulative Update 1 for SQL Server 2012 SP2

Cumulative Update 10 for SQL Server 2012 SP1

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.