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

Applies to: 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


Status


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