Tempdb contention on sysmultiobjrefs (2:1:103) causes performance problems - by Michael J. Swart

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 777072 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 1/21/2013 10:46:34 AM
Access Restriction Public


We have experienced tempdb contention (PAGELATCH_EX contention) which caused performance problems. The resource is always (2:1:103) and it is seen when many temp tables are created often. 

I understand that this is a know issue, but I'm opening this issue to enable feedback/voting from others.
Sign in to post a comment.
Posted by Microsoft on 2/20/2013 at 2:49 PM
Hi Michael. As you mentioned, this is a known issue. We did do some updates in this area that may address some (but unfortunately not all) of these scenarios. These should be in the latest release of SQL Server 2008 R2 and SQL Server 2012. If possible, can you please try out the latest updates and see if they help? Again, this won't fix every scenario. I am going to close this Connect item as fixed but if you are still seeing issues with specific scenarios, can you please open new Connect issues to track those?
Posted by Microsoft on 2/15/2013 at 8:41 AM
Hi Michael, thanks for your feedback. We are currently investigating to see what can be done here.
Posted by Michael J. Swart on 1/23/2013 at 5:40 AM
More info at http://michaeljswart.com/2013/01/pagelatch-contention-on-21103/