Comments (4)

  1. Hey Robert,
    I see that Matt Wrock also blogged about 2:1:103 contention here:
    http://www.mattwrock.com/post/2011/09/10/Latch-waits-on-21103-You-are-probably-creating-too-many-temp-tables-in-Sql-Server.aspx

    It seems like volume of ad hoc temp table (or table variable) creation is the issue. I followed the link in Paul’s newsletter and found a video demonstrating a lot of tempdb space consumed by tempdb. But I didn’t see a video that would demonstrate 2:1:103 contention. Were you thinking of another demo?

    It’s a tricky subject with not a lot to go on. The comments in another of Paul’s tempdb contention post http://www.sqlskills.com/blogs/paul/misconceptions-around-tf-1118/ indicate it’s tricky.

    1. Thanks Michael. I updated the post to have the link for the right video demo.

      Yes, it’s an issue of too many temporary objects.

  2. […] Davis blogged about 2:1:103 contention in Tempdb Contention That Can’t Be Soothed. His advice is to remove statements in code like “SELECT … INTO”.  However, I […]

  3. […] Davis blogged about 2:1:103 contention in Tempdb Contention That Can’t Be Soothed. His advice is to remove statements in code like “SELECT … INTO”.  However, I […]

Leave a Reply