Do you really mean that 30 active sessions eat 70% of 12 cpus, i.e 9 cpus? And how many concurrently active users would your dr box support? My best guess it would be most of those 30 wouldn't it? If so You'd be mad to choose anything other than an identically specced box. If on the other hand you actually intended 300 concurrent users and the dr box would only be supporting far fewer then you'd likely get away with fewer cpus.
I am sizing a server for a database which will be used for disaster purposes. It should support 25% of production load.
Right now I have a production server with 12 CPU and 48Gb memory, in peak time 70% of CPU usage is observed (30 Active database users) and 40GB is used. This supports 3600 users roughly.
Is this that simple divide my actual HW by 4? i.e 3 CPU and 12 GB to support 1200 users? I think I can do that for memory but not that sure for CPU usage.
-- Niall Litchfield Oracle DBA http://www.orawin.info -- //www.freelists.org/webpage/oracle-l