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 » performance » tempdb   (RSS)
  • SQL Server challenge: show me trace flag 1118 is significant -- a quick update

    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 ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on October 2, 2009
  • Performance impact: tempdb and update statistics

    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, ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on August 16, 2009
Privacy Statement