Re: Datafiles on SAN?

Hi,

    I think the performance requirement varies according to your application profile.

    Bandwidth data is valuable for DSS type database server, while IOPS is valuable for OLTP systems. For bandwidth test, maybe simple dd can do the trick?

    For IOPS test, it is a bit difficult., you can get some tools to do the test, or write some procedure to do random select/DML and see if gives god performance? I would like to hear from other friends' words in the list.

    Good luck.
Regards
zhu chao
msn:chao_ping_at_163.com
www.cnoug.org
----- Original Message -----
From: "Jose Luis Delgado" <joseluis_delgado_at_yahoo.com> To: <chao_ping_at_vip.163.com>
Sent: Wednesday, July 16, 2003 3:45 AM
Subject: Re: Datafiles on SAN?

> Hi Chao...
>
> thanks for the info... I'll take into account.
>
> We just bought the SAN solution and we're in the
> testing process...
>
> do you know how can I conduct a test?
> i.e. Bandwith, performance, etc...
>
> Regards!
> JL
>
> --- zhu chao <chao_ping_at_vip.163.com> wrote:
> > Hi, JL:
> > I think you need the multipathing solution for
> > your platform. In a SAN
> > environment, there is more devices, so more chance
> > that device fail. So you
> > need multiple path from host to storage. That means
> > multipathing IO support,
> > like Veritas DMP or Sun AP or HP pvlinks or storage
> > specific solutions.
> > Good luck.
> > Regards
> > zhu chao
> > msn:chao_ping_at_163.com
> > www.cnoug.org
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L"
> > <ORACLE-L_at_fatcity.com>
> > Sent: Wednesday, July 16, 2003 1:19 AM
> >
> >
> > > I have them...
> > >
> > > one of the things that I can tell you is that...
> > >
> > > sometimes (at least here at work) the ports
> > switches
> > > fail and you lost your connectivity to your
> > > filesystems...
> > >
> > > it does not mean that your database goes down...
> > just
> > > have to reassign your LUNs to another SP processor
> > and
> > > that's it...
> > >
> > > anyway, in my case I lost about 30 mins (the time
> > to
> > > detect/reassign/correct the problem)...
> > fortunately
> > > was a test database...
> > >
> > > I would like to help/comment you more, but, that's
> > > what we have seem until now.!
> > >
> > > HTH
> > > JL
> > >
> > >
> > > --- Tim Levatich <tpl10_at_cornell.edu> wrote:
> > > > Is anyone putting datafiles on SAN storage?
> > > > Success? Horror? Tell me a story.
> > > >
> > > >
> > >
> >
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> > > > Tim Levatich, Database Administrator
> > > > Cornell Laboratory of Ornithology, 159
> > Sapsucker
> > > > Woods Road, Ithaca, New
> > > > York 14850
> > > > TPL10_at_cornell.edu phone 607-254-2113 fax
> > > > 607-254-2415
> > > > http://birds.cornell.edu
> > > > http://birdsource.cornell.edu
> > > >
> > >
> >
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ:
> > > > http://www.orafaq.net
> > > > --
> > > > Author: Tim Levatich
> > > > INET: tpl10_at_cornell.edu
> > > >
> > > > Fat City Network Services -- 858-538-5051
> > > > http://www.fatcity.com
> > > > San Diego, California -- Mailing list and
> > web
> > > > hosting services
> > > >
> > >
> >
> ---------------------------------------------------------------------
> > > > To REMOVE yourself from this mailing list, send
> > an
> > > > E-Mail message
> > > > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > > > 'ListGuru') and in
> > > > the message BODY, include a line containing:
> > UNSUB
> > > > ORACLE-L
> > > > (or the name of mailing list you want to be
> > removed
> > > > from). You may
> > > > also send the HELP command for other information
> > > > (like subscribing).
> > >
> > >
> > > __________________________________
> > > Do you Yahoo!?
> > > SBC Yahoo! DSL - Now only $29.95 per month!
> > > http://sbc.yahoo.com
> > > --
> > > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net
> > > --
> > > Author: Jose Luis Delgado
> > > INET: joseluis_delgado_at_yahoo.com
> > >
> > > Fat City Network Services -- 858-538-5051
> > http://www.fatcity.com
> > > San Diego, California -- Mailing list and
> > web hosting services
> > >
> >
> ---------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > > (or the name of mailing list you want to be
> > removed from). You may
> > > also send the HELP command for other information
> > (like subscribing).
> > >
> > >
> >
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.net
> > --
> > Author: zhu chao
> > INET: chao_ping_at_vip.163.com
> >
> > Fat City Network Services -- 858-538-5051
> > http://www.fatcity.com
> > San Diego, California -- Mailing list and web
> > hosting services
> >
> ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from). You may
> > also send the HELP command for other information
Received on Tue Jul 15 2003 - 17:52:22 CDT