First published on MSDN on Mar 25, 2016
if you are on SQL Server 2014 and above and have tempdb problems, SQL Server In-Memory OLTP Program Manager Jos de Bruijn just posted a great blog titled “ Improving temp table and table variable performance using memory optimization ”. While methods documented in https://support.microsoft.com/en-us/kb/328551 are sufficient to most scenarios, some high workloads may continue experience tempdb issues including blocking on system tables. Jos’s blog will be a great complement to existing solutions.
Jack Li |Senior Escalation Engineer | Microsoft SQL Server
Updated Jan 16, 2019
Version 2.0