Reduce the Contention on tempdb with Trace Flag 1118: Take 2

re: Reduce the Contention on tempdb with Trace Flag 1118: Take 2

JohnW — Thu, 05 Jun 2008 13:40:34 GMT

I know this is an old post at this point...

I'm not sure I drew the same conclusion as you did. I can be up to ~18% faster w/o 1118, iff i have a lower load level. But if i have a lower load level, I'm probably not that worried about performance. When I do have a higher load level, I am worried about performance, and ~13% slower would catch my eye.

re: Reduce the Contention on tempdb with Trace Flag 1118: Take 2

Linchi Shea — Fri, 25 Sep 2009 22:23:00 GMT

JohnW;

Points taken. Of course, it's more critical when the load is high.

SQL Server challenge: show me trace flag 1118 is significant

Linchi Shea — Thu, 01 Oct 2009 16:22:18 GMT

Here is a SQL Server challenge as I have failed so far: Describe a reproducible workload that would see

SQL Server challenge: show me trace flag 1118 is significant -- a quick update

Linchi Shea — Fri, 02 Oct 2009 20:42:05 GMT

I posted the following SQL Server challenge yesterday: Describe a reproducible workload that would see