I posted the following SQL Server challenge yesterday:   Describe a reproducible workload that would see significant throughput improvement when trace flag 1118 is enabled.   In response, Konstantin Korobkov wanted to know whether the number of data files in tempdb would make a difference.   I did test that scenario and did ...

In SQL Server, one of the most significant architectural legacies from Sybase is the use of a single globally shared tempdb database. Any time you have something globally shared in a highly concurrent system, the shared resource can become a huge impediment to the scalability of the whole system. Tempdb is no exception.   Consequently, ...