Solve your tempdb problems with memory optimized tables
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