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
1  2558 
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.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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, 2GB Ram, 3x36GB Hdd on Raid 5
Operating System: Redhat Linux 9
I will deploy only 1 database for the application. Only 1 DBA will use the
Oracle server when necessary. When the database once deployed, Only 1
|
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
transactions / day, 50% updates and 50& reads roughly, the main goal
since it is used by an interactive end user application is speed for
updates and reads, it does not need to do any heavy calculations at
all during daytime, at nighttime it does a lot of...
|
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 will be collocated in a datacenter.
I have a few scenarios that I would appreciate in getting some
comments/criticism on:
Scenario 1:
Box 1, SBS 2003 Premium (with SQL 2000), 2GB RAM, Raid 5 HD
|
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 have
only one database (besides the master, model,etc)on the server. What
has happend to me several times is that the primary database in
question try's to expand the main datafile for the database (.mdf). I
setup the database to not expand...
|
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
Drive2 73GB mirror of Drive 2
Drive3 300GB Actual DBs
Drive4 300GB mirror of Drive 3
In doing so, my reasoning would be to leave the OS alone. Will be running
| | |
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 looks like an I/O issue. So I started
investigating based on sql server perfromance tuning technical
reference.
Here are my system monitor findings:
The system monitor shows during my job:
|
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 server:
1. Feeding purpose : On which continously feeding is done by average
200 users.
2. Reporting purpose : on which average hundred of repords are running
at a time.
|
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?
|
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 doesn't matter?
I have a total of 8 harddrives, what RAID setup should i choose?
Thanks,
Fred
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
