From: Theresa Sarver (IFMC.tsarver@SDPS.ORG)
Date: Mon Oct 28 2002 - 12:53:09 EST
Thanks to all who replied - I appreciated all the feedback and have put in a request for either a 6M1 (750 MHZ) w/ 10GB RAM...followed by my second choice the 6H1 (750 MHZ) w/ 8GB RAM. So now I guess we'll see which one I can get. ;)
Thanks again;
Theresa
>>> Bill_Verzal@BCBSIL.COM 10/28/02 08:49AM >>>
6-way will help, but I think you still may see a pretty busy system.
BV
--------------------------------------------------------------------------------------------------------
Bill Verzal
Technical Consultant
Forbes Technical Consulting
(312) 653-3684
bill_verzal@bcbsil.com
MailStop: 27.202B
"Theresa
Sarver" To: aix-l@Princeton.EDU
<IFMC.tsarver@ cc:
SDPS.ORG> Subject: Re: Help spec'ing out a new server
Sent by: "IBM
AIX Discussion
List"
<aix-l@Princet
on.EDU>
10/28/2002
08:18 AM
Please respond
to "IBM AIX
Discussion
List"
Here is a sample of the vmstat output we've been seeing since mid-Sept
(after the largest oracle db was added) - this is average for the run
queue, though depending on what the users are doing, this field will have
over 25 processes waiting in it.
kthr memory page faults cpu
----- ----------- ------------------------ ------------ -----------
r b avm fre re pi po fr sr cy in sy cs us sy id wa
3 2 358611 277 0 0 1 57 162 0 536 14519 575 38 9 51 1
11 2 358425 122 0 0 2 54 329 0 880 42432 1367 80 20 0 0
8 2 357889 288 0 0 2 40 450 0 823 42547 1128 85 15 0 0
8 2 358101 336 0 0 0 58 875 0 779 44679 1132 83 17 0 0
9 2 358653 128 0 0 2 58 1337 0 779 46044 1127 79 21 0 0
Based off this, is everyone still in agreement that a 6-way @ 750Mhz will
work sufficiently?
Thank you again for all the help!
Theresa
>>> Bill_Verzal@BCBSIL.COM 10/28/02 07:48AM >>>
I would opt for multiple CPU's, so a 6-way would probably be better for a
database server, but you would need to check run-q depth versus CPU
utilization to be sure.
--------------------------------------------------------------------------------------------------------
Bill Verzal
Technical Consultant
Forbes Technical Consulting
(312) 653-3684
bill_verzal@bcbsil.com
MailStop: 27.202B
"Theresa
Sarver" To: aix-l@Princeton.EDU
<IFMC.tsarver@ cc:
SDPS.ORG> Subject: Help spec'ing out a
new server
Sent by: "IBM
AIX Discussion
List"
<aix-l@Princet
on.EDU>
10/25/2002
04:43 PM
Please respond
to "IBM AIX
Discussion
List"
Hi all;
This is a rather odd post, but I'm looking for a little guidence in picking
out a new Oracle database server. I'll tell you what I have in mind and
I'd appreiate any advice on the matter.
As is now we have an SP node with the following spec's:
4-375Mhz CPU's
4GB RAM
2GB Paging
Running the following databases:
NAME USERS SIZE SGA [total] Size in 3 years
DB1 1500 100GB 500MB Double in size
DB2 80 10GB 115MB Double in size
DB3 70 4GB 80MB Double in size
This node sits at 100% CPU utilization almost constantly. Paging isn't a
big constant issue, though depending on what the users are doing then it
becomes one. The DBA's and I have worked nearly every angle and we cannot
get the CPU utilization to drop. Oh, and FYI...we're looking to upgrade to
Oracle 9i fairly soon and I can't find a whole lot of info on any
additional overhead the 9i product may have.
Anyway, I've been told to spec out a new [IBM] server, I had the P660-6H1
in mind w/ 6-750Mhz (would 600 MHz suffice? - or for that matter could I
get away with 4-750Mhz processers?) processors and 8 GB of RAM. Does this
sound like it would work okay? Does anyone have any other suggestions or
recommendations? I'm just not real familiar with Oracle and what it
requires to be happy.
Thanks in advance for your help;
Theresa
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:16:17 EDT