If this is full blown sql, i'd avoid putting the sql app on the SBS
server and have an app server and a SBS server.
Bill
David Lum wrote:
Thanks for the replies. I will likely just punt and return the hardware (heck
maybe I'll buy it from them, I could likely find a use for it at home in my
lab) vs. the risk of flipping things around, the LAST thing I want is to kill
something that works! This hardware was pretty inexpensive at just under $600,
the quote I gave them earlier this year for a new server was $7500 soup to nuts
(new server, SBS 2011, etc). IIRC the SBS software was almost as much as the
physical box.
I had hoped that this would buy them some time and that when they move to a new
server this external array could be leveraged as local backup storage (they go
disk-disk and disk-Internet now, but the local disk is RAID-nonexistant).
I'll tell them to go back to the server upgrade plan as previously suggested.
Dave
-----Original Message-----
From: Ben Scott [mailto:[email protected]]
Sent: Thursday, October 13, 2011 4:35 AM
To: NT System Admin Issues
Subject: Re: What would YOU do?
On Thu, Oct 13, 2011 at 1:27 AM, David Lum <[email protected]> wrote:
I figured I'd create a RAID5 volume and point SQL over to this new
drive array and performance should be much improved ...
You generally don't want database log files on a RAID5 array.
Additionally, most cheaper RAID cards (i.e., anything that costs less than
several hundred dollars) don't have good RAID5 performance.
(Some of them are downright awful.) Given how big today's disks are, and the
small size of the system, I'd go with mirrored disks for everything.
Is there any way to put the existing SATA array on a different card
(say, a PCIe 1x SATA RAID card) without having to rebuild the volumes?
Moving RAIDed disks to new RAID cards is tricky at best. That said, if you
stay within the same card manufacturer, it is usually possible.
I would look to replace the existing RAID card with something with enough
ports for both the inside disks and the external disks
I don't think putting disk I/O on a PCIe 1x slot is a good idea, so I'd stay
on the PCIe 4x slot.
AFAIK, all of Dell's RAID cards are rebadged LSI Logic MegaRAID cards, so if
Dell doesn't sell a suitable card, you might be able to switch to something
from them.
Finally: What's the cost of this project vs the cost of just getting a new
server and moving the existing software to that?
-- Ben
~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~
<http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
---
To manage subscriptions click here:
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to [email protected]
with the body: unsubscribe ntsysadmin
~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
---
To manage subscriptions click here:
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to [email protected]
with the body: unsubscribe ntsysadmin
~ Finally, powerful endpoint security that ISN'T a resource hog! ~
~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~
---
To manage subscriptions click here:
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to [email protected]
with the body: unsubscribe ntsysadmin
