From: Viren Gupta (virender_gupta@TIMEINC.COM)
Date: Mon Oct 28 2002 - 10:45:34 EST
Theresa:
We have high end boxes , S80's, S85 and p690 (Regatta), all running
several Oracle databases, ranging in size from 100 gb to 1 tb. One
system is also used to run home grown C++ and Syncsort apps which are
very CPU intensive. Since all systems have 12 or more processors , I
have rarely seen any major CPU bottlenecks except the one system with
C++ and Syncsort apps. However, on numerous occasions I noticed large
I/O waits. Data is coming out of two Sharks fiber connected via a SAN
with 2109 data switches.
I have tuned the systems with data collected from vmstat, tprof, svmon,
filemon, iostat etc and have managed to bring down I/O wait to
manageable levels.
To allow for growth I would definitely go with 6 processors and 8 gb
memory. Get as much memory as your budget allows, because as databases
grow the memory requirement grows too and remember most databases,
Oracle in particular are absolute memory hogs. I haven't worked much
with other databases, but would some care to comment on the memory usage
habits of DB2, Sybase etc.
Viren Gupta
Time Inc.
IFMC.tsarver@SDPS.ORG wrote:
>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