One of the common questions we get during sales demos is “does VividCortex give advice on my database’s configuration?” The assumption is that since our product sees lots of information about the database, operating system, and current configuration, it can “optimize” the database configuration. Or, at least, point out really obviously bad things? Surely that is not too hard to do?
VividCortex doesn’t do that, and there are good reasons why. By way of explanation I’d like to tell a few war stories. Warning: you’re probably going to vow never to look at auto-generated tuning advice again.
Get Down Off The Ledge
At one point, a significant chunk of my career and earnings consisted of undoing the damage caused by configuration advisors. It was often very hard to convince people to reverse the changes the configuration advisors had urged them to make. It’s a psychological problem, not a technical one.
…[Read more]