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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.