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

twitter| pssdiag |Sql Nexus