Re: R2 Premium Install Locations

Hi Robert,

Thanks for your reply. So installing SQL WGE 2005 on my C drive and locating the data files on the raid 5 array is the way to go ? Many thanks.

Regards Colin.


"Robert Li [MSFT]" <v-robeli@xxxxxxxxxxxxxxxxxxxx> wrote in message news:emHcisOnHHA.5168@xxxxxxxxxxxxxxxxxxxxxxxxx
Hi Colin,

Thanks for posting in our newsgroup.

The major difference in performance between RAID 1 and RAID 5 is that RAID
5 experiences heavy write overhead because additional parity data has to be
created and written to the array. This is overhead that RAID 1 does not
experience. Because of this, write performance on RAID 1 is generally much
faster than RAID 5.

SQL log files, by their nature, are mostly written to, which means that
often RAID 1 is your best choice for performance. And then you need to
locate the data files on RAID 5 which has better security.

Hope the information helps.

If you need further assistance, please don't hesitate to let me know

Best regards,

Robert Li(MSFT)

Microsoft CSS Online Newsgroup Support

Get Secure! - www.microsoft.com/security

=====================================================

This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.

Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.

For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.

Any input or comments in this thread are highly appreciated.

=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
<From: "Colin" <colin@home>
<Subject: R2 Premium Install Locations
<Date: Tue, 22 May 2007 20:19:56 +0100
<Lines: 12
<Message-ID: <5B255D17-21FA-41F7-9345-4E9E102D5337@xxxxxxxxxxxxx>
<MIME-Version: 1.0
<Content-Type: text/plain;
< format=flowed;
< charset="iso-8859-1";
< reply-type=original
<Content-Transfer-Encoding: 7bit
<X-Priority: 3
<X-MSMail-Priority: Normal
<X-Newsreader: Microsoft Windows Mail 6.0.6000.16386
<X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16386
<X-MS-CommunityGroup-MessageCategory: {E4FCE0A9-75B4-4168-BFF9-16C22D8747EC}
<X-MS-CommunityGroup-PostID: {5B255D17-21FA-41F7-9345-4E9E102D5337}
<Newsgroups: microsoft.public.windows.server.sbs
<Path: TK2MSFTNGHUB02.phx.gbl
<Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.windows.server.sbs:38693
<NNTP-Posting-Host: TK2MSFTNGHUB02.phx.gbl 127.0.0.1
<X-Tomcat-NG: microsoft.public.windows.server.sbs
<
<Hi all,
<
<I am installing a new SBS 2003 R2 box for a client. The server has 2
arrays,
<raid 1 for the OS (2 x 80GB partitioned as C-25 GB and E-remainder) and a
<raid 5 (3 x 250GB + hot spare setup as 1 500GB partition) for the data. I
am
<comfortable installing SBS but SQL is not my speciality. During install of
<SQL WGE 2005, what is the recommended procedure ? Should I choose to
install
<it on the data drive or install in the root of C and relocate databases
etc
<? Any help on this would be appreciated.
<
<Regards Colin.
<
<


.

Relevant Pages

  • Re: Need help installing OS6 on Dell PowerEdge 2600 with PERC4/Di RAID
    ... > like a fresh install and porting their application and data to the new system. ... PERC4/Di RAID on the motherboard, Dell DLT tape drive, Dell slimline ... PATA connector usable for two PATA drives. ... After downloading drivers from both SCO and Dell to create the ...
    (comp.unix.sco.misc)
  • Re: Need to setup RAID in new hardware upgrade SBS2003
    ... I already moved the system to a new motherboard with an embedded Intel RAID ... controller a couple of months ago. ... did try but couldn't without wiping the drives first. ... install of the OS to get the RAID on the new board based on the Intel RAID ...
    (microsoft.public.windows.server.sbs)
  • Re: R2 Premium Install Locations
    ... Please install the SQL program to C. ... Please store the SQL database to RAID 5. ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Re: Cannot upgrade from FC6->F7. No upgrade option given in install screen. (and RAID remnant)
    ... with the raid device /dev/md0 mdadm will not operate on that device. ... I changed the physical device references for all partitions on ... CD and I eventually received the install / upgrade window! ... there was disk activity and I assumed that selinux-policy-targeted was ...
    (Fedora)
  • Re: Cannot update to FC5 kernel versions 2.6.16*
    ... ran "yum update" and found a new kernel version. ... RAID" since it is basically a software RAID with limited hardware ... no problems it doesn't matter from which disk I am booting. ... I want to install that wonderful drivers for my new Nvidia ...
    (Fedora)