High CPU usage on DB host?
Its Unix 101 statement, but I have heard it wrong so many time, so decided to put a blog for it. If in OLTP environment, per ‘top’ %wa (IOWAIT) is major contributor for CPU busy, adding CPU would not help. There is no need for more CPU. Period. ************** %wa IS PERCENTAGE WHAT COUNT TO […]