Rads R
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
ASKER
thanks
ASKER
think that hardrive of 55-100gb would be appropriate or needs more than that. please update
thanks for your time and cooperation
rads