In a perfect world Performance Tuning is an action performed at regular intervals by the Database team but all too often, with limited resources available, it is neglected and forgotten about and instead the call goes out for more and more powerful machines with more memory and faster CPU's.


Very often some fairly simple SQL code optimisation can lead to bigger performance improvements than even the costliest server upgrade can provide. This is certainly something we've experienced in the past where we've taken costly queries taken in excess of 10 minutes to run and optimised the code to run in half a minute or less. This might be an extreme example but in almost all databases we are able to achieve an improvement of at least 25%.


In addition to improving speed another important aspect of performance tuning is to spot any security issues or misconfigurations and in this way our performance tuning process acts as a kind of unofficial audit which can give an early heads up on serious issues.