SQL Server Performance series: TEMPDB - can't live it and can't get rid of it. Why not rename it as ImportantDB?

TEMPDB - as it sounds it is a temporary database in SQL Server, that has undergone number of changes from 2005 version onwards. As you may be aware that tempdb is used for various purpsoes such as storing intermediate results, sorting and keepng row versions, unless a good I/O &amp; CPU subsystem is supporting the cause. Now and then I see many questions in Forums stating the performance is hampered and root cause was tempdb. Just back to basics that TEMPDB is similar to a user database to store...(<a href="http://sqlserver-qa.net/blogs/perftune/archive/2011/02/15/9972.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=9972" width="1" height="1">