SQL Server tempdb one or multiple data files

SQL Server tempdb one or multiple data files

瀏覽:318
日期:2025-09-15
As we can see, on average, when the query runs on 2 tempdb files it is 2174 ms slower then when it runs on a single tempdb file. The reason why is that when sort operations spill over to tempdb they are pretty sequential. If we have two tempdb files, we a...看更多