CPU vs Wait time Ratio
With response time analysis being the new black, a lot of 'web' information recommends looking at the ratio of DBA CPU to DBA WAIT time Ratios. A very rough rule of thumb seems to be that you want the CPU time to be high and the Wait time to be low.
Many systems these days (and more into the future) are based on middleware architectures where we tend to have large numbers of pre-created and often idle connections sitting on our databases waiting for work to do.
When I query our databases to look at "Database Wait Time Ratio" I often see it up in the 80s.
Am i correct in thinking that idle connections contribute to the "Database Wait Time Ratio" metric and therefore in a "middleware" architectured environment, these ratios are particularly meaningless?
FWIW our prod database returns the following ratios, and it's humming along quite nicely..
METRIC_NAME VALUE
---------------------------------------------------------------- ----------
Database Wait Time Ratio 78.1162793
Database CPU Time Ratio 21.8837207