I am sure that I’m not the only one out there that has gone thru this but scenario. A user has application performance issues. Initial consensus is to do what? You guessed it, buy new server hardware for the database to fix the problem. After migrating to the new hardware guess what? You guessed it again, the application issues still persist. In some cases, not as bad but still there to the point that it’s noticeable by the end users. Even on the newer hardware, issues that persist must be related to hardware right? Well…that’s typically where most of the troubleshooting efforts are placed. More time goes by still with issues so guess what is needed? If you guessed, new servers and storage hardware with virtualization, I suggest you head to Las Vegas right now. Even after more new faster hardware stuff performance problems are still there so maybe it’s time to start looking for the root of the problem.
I guess the moral of the story is that hardware will not fix application issues. Put some time into getting down to the root of an issue and also step back to see the big picture. Just because that application worked with no issues a month ago doesn’t mean it should never have a problem. Things change all the time, like user load, operating system and software patches/updates, to additional processes, and more. If you have any feedback I’d like to know what others think about this.