providing DB hardware specs(CPU requirements) for production
Date: Wed, 8 May 2013 16:15:30 -0400
Message-ID: <CAE-dsOKTCEUi3NM3b-MZHcbCPrZ6k_ua114ezvPFiQ82x+y3MQ_at_mail.gmail.com>
Brand new application and brand new database. finally getting what we think will be production level data. We are generating it and its guesswork.
I have pretty good estimates on usage (not an OLTP the system is queried by jobs and data is inserted by jobs).
I do not have a like system to estimate this off of.
So I am testing our queries against the production volume and getting back some buffer_gets that I am plugging into a spreadsheet to come up with an estimate of buffer_gets/hour.
I need to provide estimates for hardware specs for production without having any kind of environment that even remotely mimics production. So I am guessing.
I think Jonathan Lewis posted a way to roughly estimate how much CPU you use based on your buffer_gets several years ago. Are there any good methods for charting this in a spreadsheet using Oracle 'events' to get a rough estimate of CPU.
I was am planning on using Cary Milsaps spreadsheets from Oracle Performance. I have had the book for years, but never used his spreadsheet.
For right now I really just need to estimate CPU. My development environment has my DBs on VMs and we are very tight on hardware. So performance is hurt by other VMs. I can't get a VM on a box separate. We just don't have resources.
There is alot of guessing.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed May 08 2013 - 22:15:30 CEST