Solve your tempdb problems with memory optimized tables
Published Jan 15 2019 04:54 PM 322 Views
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 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

Version history
Last update:
‎Jan 15 2019 04:54 PM
Updated by: