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

Velja za: SQL Server 2012 EnterpriseSQL Server 2012 DeveloperSQL Server 2012 Standard


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.


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



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