Re: Ideal setup wanted, SCSI or SAN/Fiber

Larry,

This is impossible to answer correctly without a lot more info on what you plan to do with the db and how you will access it. The size of the db tells us very little or nothing about what you need for storage. That will be more dictated by usage and things like HA and DR needs. The setup with the internal drives will suite most people just fine, especially if it will take 2 or 3 years to get to peak usage. By then the hardware is due for replacement anyway. But if you were trying to do 5K transactions a second it may not be suitable. Where do you plan on putting your backup files? What do you intend to do for HA and DR? SAN's and Direct attached storage each have their pros & cons but you need to decide what you need to support before you can decide which is the best solution.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors


"Larry Epn" <larryepn@xxxxxxxxxxxxxxx> wrote in message news:5BAAD152-870C-423D-90FE-26B81BF7036B@xxxxxxxxxxxxxxxx
We're going to be buying new hardware for a medium sized DB, let's say around
50-100GB within 2-3 years.
It seems like the net price difference is around $15,000 between a tower
server with 10-drives (2 Raid1 OS, 2 Raid1 Logs, 6 Raid10 Data) -vs- a couple
pizza-boxes connected to a SAN with the same drives.
I'm told, however, that a SAN Fiber-Channel setup will not perform as well
as SCSI in the same box.
There are probably 1000 permutations on any of these designs....
In general, I can't say "money is no object", but if there is a good reason
to justify the more expensive setup (especially future growth or possible use
by other servers that would connect to the SAN), then the money would be
there.
Any and all comments/opinions are welcome.
Thanks!
Larry

.

Relevant Pages

  • Re: Just signed up for "Wireless Email"
    ... Ok, what I did was setup my Comcast email account, then I tested it by ... I was told that the unlimited plan would cost 35. ... since, I didn't have to setup a new email for Cingular, I just login to my ...
    (alt.cellular.cingular)
  • RE: Help First Timer Lost with Networking
    ... Unless I find a better option a VPN is what I plan to use. ... Right now the reason that we are going to this setup is because we just ... scheduling, financial data, and job specific programs. ... program I do not see any other uses for the server. ...
    (microsoft.public.win2000.networking)
  • Re: Just signed up for "Wireless Email"
    ... unlimited PDA data connect plan, ... Ok, what I did was setup my Comcast email account, then I tested it by running with wifi turned on, and then turned off. ... since, I didn't have to setup a new email for Cingular, I just login to my pop3 using my passwords, etc. that I have always used. ...
    (alt.cellular.cingular)
  • Need Help On HA/Clustering/Load balancing the cheapest way
    ... Im planning to setup a small web hosting system. ... I plan to run Apache, ... PostgreSQL, PHP and email server. ...
    (comp.os.linux.networking)
  • Re: Is there a way to simulate a SAN for clustering purposes?
    ... Unless you're performing IO intensive performance tests, ... string fibre from your production SAN to these test systems. ... > this would allow me to setup clustering. ...
    (microsoft.public.win2000.advanced_server)
Loading