Billy Pang
tuxedoman888 at gmail.com
Thu Jul 26 11:22:27 CDT 2007
tempdb is created when sql server service starts (old one is dropped) tempdb is copied from the model db http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx On 7/26/07, jwcolby <jwcolby at colbyconsulting.com> wrote: > > Under what condition is a tempdb created? How can I predict the size? > > I am looking at using a hardware ram disk to store the tempdb but I don't > want to get into this only to find out that the tempdb is larger than the > available ram disk (4 or possibly 8 gbytes max). > > John W. Colby > Colby Consulting > www.ColbyConsulting.com > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > > -- Billy Pang http://dbnotes.blogspot.com/ "Once the game is over, the King and the pawn go back in the same box." - Italian proverb