Dear list,
As promised, I have summarized the issues that folks
on this list are dealing with, when deploying Oracle
in a SAN/NAS enviroment. I really appreciate the time
that you took to respond to my questions. Thanks to
everyone who responded.
Issues:
- Lack of performance consistency in multiple volume
groups. For example, if there are 2 volume groups v1
and v2 and they both are 4-way striped and mirrored,
v1 should not outperform v2 in any way shape or form.
- Volume Groups that require “rebuilds” during
extension (growth).
- Lack of simplicity in what the DBA needs to
interface. Too many components...require just “mount
points” or directories to put stuff.
- Lack of storage throughput capacity planning (IOPS,
Transfer rate) in the volume groups, regardless of
“h/w cache” present.
- Lack of functionality that proactively eliminates
(prevents) single point of failures.
- Lack of “logical-to-physical” mapping of volumes.
Need to know whether multiple logical volumes are
sharing the same physical disks.
- Lack of Oracle performance data correlation through
the various layers of a SAN.
- Lack of automation in filesystem placement and
management. Ideally, it should be done based on I/O
consumption and data criticality.
- Lack of segregating NAS traffic from regular LAN
traffic (underlying problem – single LAN segment).
- Not considering REDO and UNDO as “corporate data”
and NOT placing them in a SAN.
- Lack of ease in administration functions such as
adding new “mount points” in a SAN.
- Lack of automation of backups in a SAN
environment.
- Lack of proactive detection of “configuration
issues” such as dynamic multi path (DMP) and the
impact of that on controller/fibre-card utilization.
- Not recommending the amount of zoning that is
required for a given environment.
Cheers,
Gaja
Gaja Krishna Vaidyanatha
Principal Technical Product Manager,
Application Performance Management, Veritas Corporation
E-mail : gaja_at_veritas.com Phone: (650)-527-3180
Website:
http://www.veritas.com
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gaja Krishna Vaidyanatha
INET: oraperfman_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).
Received on Mon Oct 06 2003 - 15:54:24 CDT
