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
will be a great complement to existing solutions.
Jack Li |Senior Escalation Engineer | Microsoft SQL Server
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.