Earlier this year I had the opportunity to speak at VMWorld in San Francisco. The session title was “Using Virtual SAN to Maximize Database Performance”, and in that session I spent time focusing on performance as well as recovery. Why would recovery be a part of the talk? Because:
The role of information technology inside of corporations is not new; it has existed for decades. With each passing year we see acceleration in the speed and complexity of changes to our roles as IT professionals.
CPUs are running faster now than ever before, solid-state drives are replacing spinning disks, and database servers have terabytes of RAM. Because these resources are plentiful and increasingly affordable, it can seem tempting to solve database performance issues with hardware. But consider this example: if CPU utilization shoots up to 90% on one of your servers and stays at that level for a day or two, is the problem lack of CPU power or something else?