%3CLINGO-SUB%20id%3D%22lingo-sub-318707%22%20slang%3D%22en-US%22%3ESolve%20your%20tempdb%20problems%20with%20memory%20optimized%20tables%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-318707%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20MSDN%20on%20Mar%2025%2C%202016%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%3CP%3Eif%20you%20are%20on%20SQL%20Server%202014%20and%20above%20and%20have%20tempdb%20problems%2C%20SQL%20Server%20In-Memory%20OLTP%20Program%20Manager%20%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2Fjdebruijn%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20Jos%20de%20Bruijn%20%3C%2FA%3E%20just%20posted%20a%20great%20blog%20titled%20%E2%80%9C%20%3CA%20href%3D%22https%3A%2F%2Fblogs.msdn.microsoft.com%2Fsqlserverstorageengine%2F2016%2F03%2F21%2Fimproving-temp-table-and-table-variable-performance-using-memory-optimization%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20Improving%20temp%20table%20and%20table%20variable%20performance%20using%20memory%20optimization%20%3C%2FA%3E%20%E2%80%9D.%26nbsp%3B%26nbsp%3B%20While%20methods%20documented%20in%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fkb%2F328551%22%20title%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fkb%2F328551%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fkb%2F328551%20%3C%2FA%3E%20are%20sufficient%20to%20most%20scenarios%2C%26nbsp%3B%20some%20high%20workloads%20may%20continue%20experience%20tempdb%20issues%20including%20blocking%20on%20system%20tables.%26nbsp%3B%26nbsp%3B%26nbsp%3B%20Jos%E2%80%99s%20%3CA%20href%3D%22https%3A%2F%2Fblogs.msdn.microsoft.com%2Fsqlserverstorageengine%2F2016%2F03%2F21%2Fimproving-temp-table-and-table-variable-performance-using-memory-optimization%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20blog%20%3C%2FA%3E%20will%20be%20a%20great%20complement%20to%20existing%20solutions.%3C%2FP%3E%0A%20%20%3CP%3E%3C%2FP%3E%0A%20%20%3CP%3EJack%20Li%20%7CSenior%20Escalation%20Engineer%20%7C%20Microsoft%20SQL%20Server%3C%2FP%3E%0A%20%20%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2Fjackli8898%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Etwitter%20%3C%2FA%3E%20%7C%20%3CA%20href%3D%22http%3A%2F%2Fdiagmanager.codeplex.com%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20pssdiag%20%3C%2FA%3E%20%7C%20%3CA%20href%3D%22http%3A%2F%2Fsqlnexus.codeplex.com%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20Sql%20Nexus%3C%2FA%3E%3C%2FP%3E%0A%20%0A%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-318707%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Mar%2025%2C%202016%20if%20you%20are%20on%20SQL%20Server%202014%20and%20above%20and%20have%20tempdb%20problems%2C%20SQL%20Server%20In-Memory%20OLTP%20Program%20Manager%20Jos%20de%20Bruijn%20just%20posted%20a%20great%20blog%20titled%20%E2%80%9CImproving%20temp%20table%20and%20table%20variable%20performance%20using%20memory%20optimization%E2%80%9D.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-318707%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EInMemory%20OLTP%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPerformance%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft
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