Register  Login
  Search
Location: BlogsSarah's SQL 2008 Blog    
Posted by: Sarah Barela 5/6/2008 9:24 AM

In SQL 2005, tempdb management became a bigger issue.  Truthfully I did not do much to manage tempdb on my 2005 servers, placed it on a separate drive when I could and made sure it a couple of gigs of space and then ignored it.  However, I have noticed that in SQL 2008 temp db may need a little more careful watch.  On these beta servers, I have allocated twice the space for tempdb than I did in SQL 2005 and several times we have run out of space.  I suspect that some users may be trying out the new features of table variables a little more in-depth than our customers.   I have set up a trace on the tempdb so I can get a better idea of how it is being used and I will let you know what I find out.

Permalink |  Trackback
 Member Blogs List Minimize

  
 Search Blogs Minimize

  
 Blog Archives Minimize

  
 Helpful Links Minimize

  
Copyright 2007 by SQL Server Beta   Terms Of Use  Privacy Statement