SQL Server tempdb one or multiple data files

SQL Server tempdb one or multiple data files

瀏覽:831
日期:2024-05-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...看更多