THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Best Practices » Benchmark » Waits   (RSS)
  • SQL Server challenge: show me trace flag 1118 is significant

    Here is a SQL Server challenge as I have failed so far:   Describe a reproducible workload that would see significant throughput improvement when trace flag 1118 is enabled.   I have seen a lot of chatters, anecdotes, and stories on the impact of trace flag 1118 on reducing tempdb contentions. But I have not seen ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on October 1, 2009
Privacy Statement