asked on

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

ASKER CERTIFIED SOLUTION

spiderwilk007

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Rads R

ASKER

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

blandyuk

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:

https://www.experts-exchange.com/questions/22789869/RAId-5-or-RAID-10-fro-SQL-200-server.html

Also, handy ref:

http://db-optimizer.blogspot.com/2010/01/baarf-battle-against-any-raid-5.html

Rads R

ASKER

thanks