| How to calculate ROI on performance gain [message #621364] |
Tue, 12 August 2014 20:41  |
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 #621366 is a reply to message #621365] |
Tue, 12 August 2014 21:09  |
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 |
 |
BlackSwan
Messages: 26766
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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
