RE: Capacity Planning
- From: "Herring Dave - dherri" <Dave.Herring@xxxxxxxxxx>
- To: "LiShan Cheng" <exriscer@xxxxxxxxx>
- Date: Thu, 23 Feb 2006 09:15:29 -0600
Got it! I'm a little OEM CP-focused right now due to management of an
existing system.
As for initial CP, our company has done its best to use past experiences
across many, many installs to help predict new installs needs. Our CP
has to make many assumptions, as almost all installs for us are DWs.
Normally we have a few 3rd party tools such as Cognos, Affinium, SAS, a
known list of "power" users and "light" users, estimated logical row
counts from the data (x number of customers, x number of accounts),
refresh frequency, etc. As others have mentioned, you end up with a
guess that's +- 50%. It actually might work better if initial plans
matched in any way what gets delivered!
Wish I could offer more help!
Dave
-------------------------------------
Dave Herring, DBA
Acxiom Corporation
3333 Finley
Downers Grove, IL 60515
wk: 630.944.4762
<mailto:dherri@xxxxxxxxxx <mailto:dherri@xxxxxxxxxx> >
-------------------------------------
________________________________
From: LiShan Cheng [mailto:exriscer@xxxxxxxxx]
Sent: Thursday, February 23, 2006 9:06 AM
To: Herring Dave - dherri
Cc: Mladen Gogala; Ranko Mosic; oracle-l
Subject: Re: Capacity Planning
No, nothing wrong with OEM.
I was really asking how can a DBA predict the hardware requirement such
as CPU, Memory for a new application.
Cheers
LSC
On 2/23/06, Herring Dave - dherri <Dave.Herring@xxxxxxxxxx> wrote:
What's wrong with good ol' OEM's Capacity Planner? I found it works
great for tracking I/O, CPU, storage (at any level), and memory usage
for any system. You can even create your own queries in case you want
info broken up in a different way, such as storage being allocated into
logical areas. CP roles up the information by hour, day, week, month,
and year, easily lets you graph data you have (and change criteria and
regraph quickly), plus estimate for x amount of time in the future based
on current trends.
This does nothing for a system yet to be developed, but sure is helpful
for an existing system, especially since the graphs are the eye candy
that management responds to, when requesting more hardware.
Dave
-------------------------------------
Dave Herring, DBA
Acxiom Corporation
3333 Finley
Downers Grove, IL 60515
wk: 630.944.4762
< mailto:dherri@xxxxxxxxxx <mailto:dherri@xxxxxxxxxx> >
-------------------------------------
________________________________
*************************************************************************
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be
legally privileged.
If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.
If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.
Thank you.
*************************************************************************
Other related posts:
