SQL Server Performance

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

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Jan 12, 2009.

  1. Anonymous New Member

    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">

Share This Page