Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Sarat
Constraint Violating Yak Guru
265 Posts |
 Posted - 2002-11-29 : 12:30:19
|
| Hi, My database is 19GB big and I have Temp db drive with 10 GB space. I have heavy traffic against database 24/7. I want to know if there is a standard suggested size for Temp db drive for a 19 GB database.Thanks,Sarat. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-11-29 : 12:41:23
|
| Depends on what your system does and how it is written.Reporting systems tend to have large tempdbs, oltp's small.Tempdb can need to be larger than the database it is supporting.Just because there is a lot of traffic doesn't mean that tempdb needs to be used a lot so could be a few hundred mb.Anything that uses a temp table and probably anything with an order by or group by or subquery will use tempdb.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Sarat
Constraint Violating Yak Guru
265 Posts |
Posted - 2002-11-29 : 12:54:56
|
| Thanks nr! It is kind of hard for me to know if my database if read intensive or write, I would think both because I have an HRMS application where we do lot of writing to payroll and job/benefits tables + do lot of queries to generate interfaces, tax/benefits reports etc. I have an old backup file (old system) on Temp db drive which is taking up 13 GB and I wanted to know if I can keep it or move it to another drive depending upon the response I get from this website. I think I will get rid of it so that I have good 20 GB space on Temp db drive.Thanks,Sarat. |
|
|
|
|
|
|
Temp Db size