I have two databases with the same data, running on the same physical server.
They are performing differently (one is twice as fast as the other). I've compared the Initialization Parameters and updated the SPFILE parameters so that they are identical. The only difference is the slower one is running on an install with a slightly newer patch level.
Before I roll back the patch on the slower one, is there some tool out there that will tell me all the differences in the configuration between the two databases? I'm under the impression that not everything can be found in the Initialization Parameters/SPFile.