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:[EMAIL PROTECTED]
www.cnoug.org
----- Original Message -----
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 16, 2003 3:45 AM
> 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 <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]
> > www.cnoug.org
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L"
> > <[EMAIL PROTECTED]>
> > 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 <[EMAIL PROTECTED]> 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
> > > > [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
> > > >
> > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
> > >
> > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
> >
> > 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: [EMAIL PROTECTED] (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: zhu chao
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
