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 |
|
albertkohl
Aged Yak Warrior
740 Posts |
 Posted - 2007-11-12 : 12:21:47
|
| Okay, so i have a Dual Xeon SQL2k5 Server set up. it's got 4 10k RPM Raptor Drivers (160gb) on it all stripped together. my question is this, i was just doing all kinds of index tuning, and my server didnt have enough disk space to create 2two of the recommended adjustments. i'm curious, if i should just have those two indexes stored on the 1TB Backup array i have? (two 500gb 7200RPM drives)or should i backup the database, and expand the Raptor Array and then restore the database and create the indexes?i'm not really worried about down time as long as it doesnt exceed 2 days. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-11-12 : 12:55:45
|
| Sounds like you are running short of space so expanding would be a good idea before it becomes critical.==========================================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. |
 |
|
|
albertkohl
Aged Yak Warrior
740 Posts |
Posted - 2007-11-12 : 13:01:54
|
| that's the idea :o) but what i was trying to get and, and i probably didnt convey really well, is i have 2 raid arrays.1) 4 160gb 10kRPM drives (total of 640gb) used for all my data/indexing2) 2 500gb 7.2k RPM Drives (total of 1000gb) used for backups (not very often though, the database is fairly static)so the questions is, 1) add 2 more 160gb 10kRPM Drivers to Array 1or2) utilize unused diskspace on Array 2 Keep in mind again, i'm not to worried about down time. more interested in speed/cost efficiency |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-12 : 22:37:49
|
| Better to build a new array with 160gb 10kRPM drivers in performance point of view. |
|
|
|
|
|
|
Expanding Disk Space