Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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