TEMP DB

• Krasavita

  SSC-Insane

  Points: 23138

  More actions

  September 24, 2008 at 6:23 am

  #93828

  I need help with temp db: I am working on tempdb. My temp tempdev: is 8MB and templog: is 1MB. My largest db is 630MB. Can I change from 8MB to 500mb and from 1 to 258 (20%) than biggest db, is this correct?

  Here is my setting for temp DB:

  DBSize Unalocated size

  tempdb 9.00 MB 7.22 MB reserve data index_size unused

  800 KB 248 KB 384 KB 168 KB

  tempdev

  PRIMARY 8192 KB Unlimited 10% data only

  templog

  NULL 1024 KB Unlimited 10% log only

  Also, do you usually do use unrestricted file grows or restricted, if restricted how do you run by?

  Thank you

• Chandra Sekhara Vyas Dhara

  SSChampion

  Points: 10207

  More actions

  September 24, 2008 at 6:39 am

  #876297

  Check the following link can know about tempdb

  http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx