SQL Server TEMPDB - A key factor in monitoring and keeping up the performance!

You may think on the subject line why TEMPDB is a key factor, a simple term is the size and physical placement of the tempdb database can affect the performance of a system. Even a simple query requires the access/process to TEMPDB, which is a part of the system-processing load may be taken up with autogrowing tempdb to the size required to support the workload every time you restart the instance of SQL Server. So if the SQL Server instance TEMPD is spread across multiple files then you need to adjust...(<a href="http://sqlserver-qa.net/blogs/perftune/archive/2009/01/13/5269.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=5269" width="1" height="1">