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 |
|
Kleber
Yak Posting Veteran
67 Posts |
 Posted - 2005-11-04 : 10:20:27
|
| Hi,I have my tempdb database in a disk with 40gb free. Few days ago it used all freespace. After shrink the database file I added anoter filhe in other disk with 50gb free.Last night all 40gb of the first disk was full again and TEMPDB didn't use the new second disk's space.the two files is in primary group.What can I do to make TEMPDB use the space of my two disks?Kleber |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-11-04 : 11:16:56
|
| This is just my opinion, but if you've got tempdb using 40GB, i'd say you a bigger problem than trying to get tempdn to use 2 drives...How big are the tranny logs? Are you performing maint on them?Check this...in Enterprise Manager, right click on tempDB and select properties...look at the data and log files and let use know what hey say...Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx |
 |
|
|
Kleber
Yak Posting Veteran
67 Posts |
Posted - 2005-11-04 : 11:22:08
|
| The tempdb uses 40gb only when I run certain scripts, once per month. And it wants to use more. So I add a new disk. But the second file have not been used. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-11-04 : 11:27:43
|
| Sounds like you need to work on those scripts, instead of worrying about using the second disk for tempdb.How big is your database? How big are the tables you are working with?CODO ERGO SUM |
|
|
|
Kleber
Yak Posting Veteran
67 Posts |
Posted - 2005-11-04 : 11:38:22
|
| The database is 25Gband the bigest tables have 9gb and 5gb.I have to work on this script. I know, but not now. I still don't have authority to change it. Just to deal with its effects.And the most recent effect is that this script use more than 40gb, I must run it, I can't change its code, so I put another disk. But the SQL server refuses to use this new disk. |
|
|
|
anuj164
Starting Member
49 Posts |
Posted - 2005-11-04 : 11:49:37
|
| you can point your temp db files to the new disk which will have more disk space; we have a reporting sertver on that we have oe disk where we only have temp db files |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
TEMPDB Full