ms sql 2000 tempdb的相關文章
SQL Server tempdb one or multiple data files

SQL Server tempdb one or multiple data files

瀏覽:1319
日期:2025-06-25
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...看更多