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
twitter
|
pssdiag
|
Sql Nexus
