John Maxwell

John Maxwell, senior product marketing manager, SolarWinds (, is responsible for all aspects of product marketing for SolarWinds Database Performance Analyzer (DPA).

Articles by John Maxwell

As with everything, there are trade-offs when it comes to indexes. A sign of a good database performance tuning and optimization solution is that it will analyze every query per database instance, look at all the tables used with each query, and then make a recommenda­tion for table tuning if there's a positive impact.

Posted February 10, 2020

Remember when standing up a new database instance involved modeling the application using the underlying database to figure out what hardware (server, storage, etc.) was needed to support the new instance? And, since most organizations did capacity planning on a spreadsheet using linear metrics, there was a lot of estimating involved, thus over-provisioning the hardware was standard procedure.

Posted December 01, 2019