Friday, September 28, 2012

Capacity Planning for the Cloud, and General Capacity Planning

A friend wrote " I could not find any information on capacity planning (database) in Oracle Enterprise Manager Cloud Control 12c. The only information i could get is that, it is part of the "Chargeback and Capacity Planning" plugin. There is no documentation available on this. One of my customer was using this feature in 10g and 11g.. and now have moved to 12c and are unable to figure it out.  Any pointers would be of great help."

My answer:

There is no capacity planner in Oracle Enterprise Manager Cloud Control 12c right now. There is a consolidation planner. This is not a general capacity planning tool but rather a consolidation tool to access your current server workloads (CPU or memory or Network IO etc), and mathematically calculate if they can be consolidated to a physical or virtual consolidation target(s) that you specify. The SPECint benchmark is used in the case of CPU comparisons.

So far as the Chargeback and Capacity Planning Plugin that you mention, this does offer a view of the CPU and Memory etc TRENDS across the cloud infrastructure to the cloud administrator, so that the cloud admin can judge the capacity usage of the infrastructure and plan ahead for cloud infrastructure upgrades. So in that sense, it allows cloud capacity planning.,

Right now, metric historical data in EM 12c can be extracted and used for capacity planning by any customer in an external spreadsheet.




Tarun Agarwal said...

Hi Porus,

How can we extract metric historical data??
Is there aplugin for it?

Porus Homi Havewala (પોરસ હોમી હવેવાલા) said...

Metric data is in the repository and you can extract it using SQL. Raw metric data is retained for 7 days, one hour aggregated data is kept for 31 days, and one day aggregated data is kept for 365 days. These are in the management views.

Anonymous said...

Is there a licensing cost for this plugin ?
Does it have licensed dependencies/packs ?

Porus Homi Havewala (પોરસ હોમી હવેવાલા) said...

The consolidation planner is currently free. The cloud capabilities for database, schemas and middleware is offered as part of the cloud management pack. For databases, the prerequisite is the DBLM pack and for middleware it is the WLS management pack EE. For a proper quote you need to contact your local Oracle sales person.




Opinions expressed in this blog are entirely the opinions of the writers of this blog, and do not reflect the position of Oracle corporation. No responsiblity will be taken for any resulting effects if any of the instructions or notes in the blog are followed. It is at the reader's own risk and liability.