To change the server for the databases for performance

I have about 3 databases on a server with the following dbf sizes as below

firstdb size= 98mb
seconddb size=448mb
thirddb size=17gb

I multiplied all these by 3 times and I got the results as 294mb , 1344mb and 50gb , Now I want to know how much disk space is needed to get all this databases on to a new server and multiplying by 3 times would be enough on a long term or do I need to do it by 5 times ...what do you suggest and what all should taken into consideration when getting the databases onto another server

thanks
rads
Radhs74Asked:
Who is Participating?
 
spiderwilk007Connect With a Mentor Commented:
Hi rads,

Looking at this question I think you may need to take a couple more things into account when choosing your Hard Disk space properly, Do you anticipate the databases to steadily grow at the same pace they have been growing? If so, you need to calculate how long it has taken the databases to grow to the size they are currently at and determine how soon they will reach 3 or 5 times the size they are currently, this will give you a timeline of when you can expect tehm to get that big. If you anticipate a spike in growth rate, by adding new users, more data, etc. then you will need to calculate that also. I would recommend going with a bigger hard drive to be safe, since Hard drives and storage are relatively inexpensive. As far as moving the databases to the new server it shouldn't be very hard just install SQL on the new server, create copies or backup the current databases, then attach or restore the databases on the new SQL Server, then point the clients to the new server and take the old server offline.  
0
 
Radhs74Author Commented:
ok they are supposed to be increasing steadily at the same pace they have been growing .. ok so you
think that hardrive of 55-100gb would be appropriate or needs more than that. please update

thanks for your time and cooperation
rads
0
 
blandyukCommented:
I agree with spider as above, but some other things to think about...

I don't know what type of RAID you'll have setup on your new server but I'd suggest RAID10 for it's speed. You might have already done this but just mentioning. RAID5 suffers from write speeds.

Here is a previous article on SQL speed issues:

http://www.experts-exchange.com/Storage/Storage_Technology/Q_22789869.html

Also, handy ref:

http://db-optimizer.blogspot.com/2010/01/baarf-battle-against-any-raid-5.html
0
 
Radhs74Author Commented:
thanks
0
All Courses

From novice to tech pro — start learning today.