Home » RDBMS Server » Performance Tuning » How to calculate ROI on performance gain (Oracle 11gr2, sun)
How to calculate ROI on performance gain [message #621364] Tue, 12 August 2014 20:41 Go to next message
AviatoR
Messages: 43
Registered: February 2009
Member
Hello all,

I have recently did tuning on a performance issue and the gains were massive. Can you please guide me how to calculate ROI(Return on Investment) for this performance tuning. DBA's usually calculate performance gains monetarily. Can anyone please let me know how to do that. Thanks in advance.

Re: How to calculate ROI on performance gain [message #621365 is a reply to message #621364] Tue, 12 August 2014 20:57 Go to previous messageGo to next message
BlackSwan
Messages: 25796
Registered: January 2009
Location: SoCal
Senior Member
>I have recently did tuning on a performance issue and the gains were massive.
which metric measured the performance gains?
why was this not detected & revealed earlier in code review or QA testing prior to deployment?

>DBA's usually calculate performance gains monetarily
please post URL which shows above is true.

post monetary value (Dollar, Franc, Pound, Mark, yen, etc.) for specific amount of CPU time & same for I/O activity.
How much is a 1 minute reduction in elapsed response time worth in your monetary unit.

is there any type of OS system resource or chargeback accounting now in place?

Re: How to calculate ROI on performance gain [message #621366 is a reply to message #621365] Tue, 12 August 2014 21:09 Go to previous messageGo to next message
AviatoR
Messages: 43
Registered: February 2009
Member
thanks blackswan,

testers used load testing on the database, before tuning it was 30 secs now it is around 1 sec.


> why was this not detected & revealed earlier in code review or QA testing prior to deployment?

it was detected earlier, but the dba was busy in doing other stuffs, so they didn't take care of this.

sorry, how to calculate the CPU time and I/O time monetarily? (USD)
I've never done performance ROI before.

[Updated on: Tue, 12 August 2014 21:09]

Report message to a moderator

Re: How to calculate ROI on performance gain [message #621367 is a reply to message #621366] Tue, 12 August 2014 21:23 Go to previous message
BlackSwan
Messages: 25796
Registered: January 2009
Location: SoCal
Senior Member
all monetary units in this response are US Dollars.

Say single computer system (CPU & RAM) cost $50,000 to purchase.
System contains 8 cores.
System has expected useful life of 3 years.
3 years * (365 days /year) * (24 hours/ day) * (60 minutes/hour) * (60 seconds/minute) * 8 cores = 756,864,000 core-seconds
$50000/756864000 = .000066 cents/second
How many times will this query run over the next 3 years?
Previous Topic: Parallel Threads Waiting
Next Topic: Reading byte data from BLOB vs File System
Goto Forum:
  


Current Time: Fri Jan 19 18:15:41 CST 2018

Total time taken to generate the page: 0.05145 seconds