My latest article on Simple-Talk was published recently. In this article I dig into how to track allocation bitmap contention in tempdb in SQL Server 2012 using Extended Events. The method described in this article redefines how you troubleshoot this type of problem, leveraging the advanced diagnostic capabilities of Extended Events to track the problem.
This is a topic that comes up a lot for us as consultants and I realized recently that I have never blogged about it. Usually