Re: R2 Premium Install Locations

Hi Colin,

Thanks for upating.

You are right. Please install the SQL program to C. Also store the SQL log
files to C.

Please store the SQL database to RAID 5.

If you have any questions about this issue, 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>
<References: <5B255D17-21FA-41F7-9345-4E9E102D5337@xxxxxxxxxxxxx>
<emHcisOnHHA.5168@xxxxxxxxxxxxxxxxxxxxxx>
<In-Reply-To: <emHcisOnHHA.5168@xxxxxxxxxxxxxxxxxxxxxx>
<Subject: Re: R2 Premium Install Locations
<Date: Wed, 23 May 2007 10:59:52 +0100
<Lines: 113
<Message-ID: <96974AB4-E435-42B7-A249-265BA7CC0E8B@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-PostID: {96974AB4-E435-42B7-A249-265BA7CC0E8B}
<X-MS-CommunityGroup-ThreadID: 5B255D17-21FA-41F7-9345-4E9E102D5337
<X-MS-CommunityGroup-ParentID: E4B8247D-4A95-40D5-A739-9FB97E69F69E
<Newsgroups: microsoft.public.windows.server.sbs
<Path: TK2MSFTNGHUB02.phx.gbl
<Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.windows.server.sbs:38820
<NNTP-Posting-Host: TK2MSFTNGHUB02.phx.gbl 127.0.0.1
<X-Tomcat-NG: microsoft.public.windows.server.sbs
<
<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: 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: Possible virus!
    ... > didn't work then we might have to do a fresh install. ... Microsoft has these suggestions for Protecting your computer from the ... I'll mainly work around Windows XP, as that is what the bulk of this ...
    (microsoft.public.windowsxp.general)
  • Re: Does anybody know what virus ive got?
    ... > Internet Security after I install it. ... Microsoft has these suggestions for Protecting your computer from the ... keep it clean,secure and running at its top performance mark. ...
    (microsoft.public.windowsxp.newusers)
  • Re: Does anybody know what virus ive got?
    ... > Internet Security after I install it. ... Microsoft has these suggestions for Protecting your computer from the ... I'll mainly work around Windows XP, as that is what the bulk of this ...
    (microsoft.public.windowsxp.customize)
  • Re: Does anybody know what virus ive got?
    ... > Internet Security after I install it. ... Microsoft has these suggestions for Protecting your computer from the ... keep it clean,secure and running at its top performance mark. ...
    (microsoft.public.windowsxp.basics)