473,385 Members | 1,344 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

New server setup and RAID recommendation

I have a database that is around 2 to 4 GB.
If I were to estimate some numbers like 4x growth or
even 10x, the database size could reach 40GB.
The new server will be running SQL Server 2005.

I am not sure which configuration option to take.
I've gathered some information from different places:

Configuration #1:
OS - Raid1 2x36GB
Logs - Raid1 2x36GB
Data - Raid 5 4x73GB
Configuration #2:
OS - Raid1 2x36GB
Logs - Raid5 (not sure how many drives)
Data - Raid5 (not sure how many drives)
Now if I am using a separate RAID array disks
for the database's transaction log, should I also put the
TempDB in this RAID also?

Here's the configuration I am thinking of right now.
Please give me your comments:

OS - Raid1 2x36GB
Logs & TempDB - Raid5 3x36GB = 2x36GB usable space
Data - Raid5 3x73GB = 2x73GB usable space

If you have other configurations you recommend please let
me know.
Thank you
May 18 '06 #1
1 2530
For the install and forget about I want protection and speed at a low
cost use RAID 5 for everything.

Now if you want the best performance and protect for the type of work
being done use the follow.

For the system files and executables, reading binaries doesn't really
put much overhead on the servers, so it is not a major concern. Any
RAID level could be used.

For data files, RAID 1 is preferable because it gives the best tradeoff
between performance, protection and cost. Because it is 100 percent
redundant, it both protects the data and the availability of your
system. Availability is the reason that you for using RAID with a
database, and even the loss of a small internal database can bring down
the database server. In this case, you will not lose any data but the
users will have to live without your system. If performance and
security are your major factors then RAID 10 should be used. No matter
what RAID level is used each RAID array should have as many physical
disks in the array as the controller will support. This allows reads
and writes to be performed simultaneously on each physical drive in the
array, significantly boosting disk I/O.

Log files, by their nature, are mostly written to, which means that
often RAID 1 is your best choice for performance. As with the
database files if performance and security are your major issues RAID
10 should be used.

May 18 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Murtix Van Basten | last post by:
Hi all, I will deploy a database project to an Oracle server, but I could not figure out which version of Oracle should I get. Here is my configuration: Hardware: Dell 1750 Dual Xeon 3.2Ghz,...
2
by: Matt | last post by:
Hello We are upgrading our DB server to a new machine and there is a heated debate about what spec machine to use. We have on this server a 15 GB DB that handled around 2-3 million...
3
by: Greg Adourian | last post by:
Hi, Still in the design process of a Windows 2003 web server with a SQL backend. Expecting to have about 2000 visitors a day accessing lists and search queries on a 200-300 MB db. This server...
8
by: 2centbob | last post by:
Has anyone had an issue with SQL Server not being able to expand against a RAID 5 file system? My current configuration is that the server is started and stopped using the local system account. I...
3
by: Hank Rouse | last post by:
Question, I have a dedicated SQL Server box, just the OS and SQL Server, and was curious as to where best to setup DB. Drive Size What Drive1 73GB OS & SQL Server Software...
19
by: dunleav1 | last post by:
I built a test job that loads data into the database. I get great performance with Oracle and I'm trying to tune Sql Server to get the same type of performance. Based on system monitoring it...
2
by: Parv | last post by:
Hi all I am having a SQL Server database of arround 110GB and 250 Users. What is best suited hardware requirements for handling of such a database. I am having following requirements from the...
8
by: justin.merth | last post by:
Is there any benefit in creating seperate file groups for a partitioned table on a multi-processor server with RAID5 and 1 Logical Drive?
2
by: Fred | last post by:
I have a server that will be running as a web server and a database server? To get the best performance is it better to install the database and web server on seperate physical hard drives? or it...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.