Re: Databases and Enterprise Storage

The only (? useful) comment I might offer is regarding downtime and distributed usage.

Is it absolutely necessary for all of the data to be located together on the same machine
at the same location? (Consider San Francisco's earthquake problems)

One might also see a performance improvement using distributed machines if primary
users are distributed.

Working in a shop supporting a multi-hospital / multi-state system (one large system serving
mutliple hospitals in a multi-state region): whenver we had to bring down the application down
for whatever reason, all 4000 users were out of service (Tandem crap).

Your central (repository?) database could be updated once per day/week/etc.

Good luck

Steve.

"Doug Coan" <dcoan_at_aegonusa.com> wrote in message news:8a5l9s$hbs$1_at_nnrp1.deja.com...
> Question for the big shops out there. Our company is currently reviewing
> the potential of Enterprise storage options.
>
> We currently use a mixture of partially/fully dedicated EMC, COMPAQ and
> SSA for our database servers. We have about 50 Oracle servers (NT, SUN,
> AIX) with @100 instances as small as 500M and as large as 1 TB. A couple
> of 2-3 TB databases will be here soon.
>
> Any comments for/against loading all this up on a SINGLE (probably EMC)
> FRAME ALONG WITH all our file servers, print servers, application
> servers, MSSQL servers, Sybase servers, web servers, mainframe systems,
> VIC 20s :-) , etc.....
>
> You can imagine the stance I am taking from a common sense DBA
> perspective as my minor dealing with only partially dedicated DASD has
> been horrendous. But, I wonder if anyone out there actual lives in this
> type of environment. I would like to share your stories (good or bad)
> with our decision makers and perhaps learn if there are some tpis/tricks
> which make this remotely feasable.
>
> Thanks much........
>
>
> --
> Doug Coan
> Oracle Certified Professional DBA
> AEGON USA
> dcoan_at_aegonusa.com
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Mar 08 2000 - 00:00:00 CST