• Monitor for allocation contention. That's all that multiple files and traceflag 1118 are for, if you don't have allocation contention then there's no point in adding the traceflag.

    Ed's right, with Express limited to a single core it's incredibly unlikely that you can generate the concurrent load required to cause allocation contention in TempDB.

    Are you seeing allocation contention? If not, why are you considering traceflag 1118?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass