
Free TempDB allocation performance booster
One of our main processes was performing badly. During the investigation, we found that most of the time is wasted on creating temporary tables, and indexes on temporary tables. We started checking a few of the regular suspects: 1. Trace flag 1118 was on. 2. Tempdb was spread across 8 files equally sized, so there shouldn’t be any big problem with GAM, SGAM and PFS. 3. Looking at performance monitor, we didn’t see any high latency on the tempdb disks. So what could go wrong?