Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Advice needed on move to Sun
15K (losing spindles)
Our CIO has suggested that we get a Sun 15K to
house all of our
databases. This has some
Theoretically, if the activity of the database doesn't involve too much
disk writing, and the cache is large enough, etc., etc., you can use
parity. When disk drives cost a lot of money, there was some justification
for it. Now that drives are cheap, there really is no justification. To
[EMAIL PROTECTED]
cc:
Subject:Advice needed on move to Sun 15K (losing spindles)
Our CIO has suggested that we get a Sun 15K to house all of our
databases. This has some advantages (communication between the various
boxes would be much faster) but I have some
partitioning to retain this functionality.
Jared
Miller, Jay [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/09/2002 11:53 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Advice needed on move to Sun
recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Advice needed on move to Sun 15K (losing spindles)
Our CIO has suggested that we get a Sun 15K to house all of our
databases. This has some advantages (communication between the various
boxes would be much faster) but I
JayMiller To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
@TDWaterhousecc:
.comSubject: RE: Advice needed on
move to Sun 15K (losing spindles)
Sent by: root
ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Advice needed on move to Sun 15K (losing spindles)
Our CIO has suggested that we get a Sun 15K to house all of our
databases. This has some advantages (communication between the various
boxes would be much faster) but I have some
I've cussed and discussed the topic of one big stripe versus multiple small
stripes with different people and have yet to come across anyone who has
conducted a real test of various scenarios. If you stripe across all disks,
then you have the advantage of guaranteed, perfectly balance I/O --
partitioning to retain this functionality.
Jared
Miller, Jay [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/09/2002 11:53 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Advice needed on move to Sun
Title: RE: Advice needed on move to Sun 15K (losing spindles)
Lets say a guy only has one finger on each hand to tie his
shoe (mirroring). If he had five fingers (striping) he can
accomplish the job quite a bit faster. Now give him 1000
shoes to tie and listen to him bitch about how he could
respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Advice needed on move to Sun 15K (losing spindles)
Our CIO has suggested that we get a Sun 15K to house all of our
databases. This has some advantages (communication
partitioning to retain this functionality.
Jared
Miller, Jay [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/09/2002 11:53 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Advice needed on move to Sun
PROTECTED]
Sent by: [EMAIL PROTECTED]
10/09/2002 11:53 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Advice needed on move to Sun 15K (losing spindles)
Our CIO has suggested that we get a Sun 15K
on move to Sun 15K (losing spindles)
Our CIO has suggested that we get a Sun 15K to house all of our
databases. This has some advantages (communication between the various
boxes would be much faster) but I have some performance concerns.
Specifically, our main OLTP database would go down
One thing that should be made clear: Never, ever, stripe with parity (i.e.
RAID 5, etc.) unless you are force, at gunpoint, to do it. That is BAD.
Your database will run faster on an abacus ... well ... maybe a slide rule.
-Original Message-
Yes, it's entirely separate CPUs and
]
Sent by: [EMAIL PROTECTED]
10/09/2002 11:53 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Advice needed on move to Sun 15K (losing
spindles)
Our CIO has suggested that we get a Sun 15K to house all
Fortunately my SA believes that so we were able to present a united front at
the presentation (and yes, the Sun rep said that with a large enough cache
RAID 5 works just as well as 1+0 - which is what we would be using).
Jay Miller
-Original Message-
Sent: Friday, October 11, 2002 4:54
to retain this functionality.
Jared
Miller, Jay [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/09/2002 11:53 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Advice needed on move to Sun 15K
Our CIO has suggested that we get a Sun 15K to house all of our
databases. This has some advantages (communication between the various
boxes would be much faster) but I have some performance concerns.
Specifically, our main OLTP database would go down from 18 spindles to 8
spindles.
Jay - I share your concerns. Can you elaborate more on how heavily loaded
the system is? Is it somewhat I/O bound? Basically you're saying that it
would have a single RAID0 set? If you divided the disks differently to
create 2 or 4 RAID sets, would there be enough room for your application?
I've
This one is so easy that even a high school student could answer it. Use
the theory of constraints (book called The Goal) to this one.
When you reduce the number of resources to process a job, sequentially or
concurrently, you induce bottlenecks within the process. Thus, by reducing
the number
Jay,
You will hit performance problems because of not having I/O bandwidth.
Databases don't need storage, they need IO operations. Two important
pieces of info that are missing from your post:
- How many databases in total are going to run on this Sun 15K ?
- How many concurrent users on all
by: [EMAIL PROTECTED]
10/09/2002 11:53 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Advice needed on move to Sun 15K (losing spindles)
Our CIO has suggested that we get a Sun 15K to house all of our
I bet you Sun rep , while trying to unload some hardware on you,
has never heard of the term Logical I/O.Many times when upgrading,
one can make things worse , not better. If you are having performance
problems, then zero in on what those could be and fix it there. Take
some snapshots,
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Advice needed on move to Sun 15K (losing spindles)
Jay,
You will hit performance problems because of not having I/O bandwidth.
Databases don't need storage, they need IO operations. Two important
Stephen hit it right on the head !!
Buy your CEO a copy of 'The Goal' ! It will be very useful in this and all
future for such 'adventures'.
How big is this Cache?
And how big are all the databases that will be running on this big server?
If database size is cache, then cash goes to the
26 matches
Mail list logo