What’s so temporary about tempdb?

Published Mar 23 2019 04:54 AM 224 Views
Microsoft
First published on MSDN on Apr 13, 2007

Other than #temptables, @localvariables and many other objects being stored in tempdb what’s so temporary about it?  TempDB is always present on each SQL Server instance and can be a determining factor of your overall performance.  In many ways tempdb could be named scratchdb or pagefiledb.  The following papers will help you understand what goes into tempdb and how to plan your deployments.  These articles are for both developers and administrators.



Working with tempdb in SQL Server 2005


http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx



Capacity Planning for tempdb


http://msdn2.microsoft.com/en-us/library/ms345368.aspx



Enjoy..


Tony Voellm

Version history
Last update:
‎Mar 23 2019 04:54 AM
Updated by: