Full Disclosure: I currently work for AppDynamics.
AppDynamics was designed from the ground up for high volume production environments but works equally well in both prod and non-prod. It's currently running in production in some of the worlds largest mission critical application environments at Netflix, Exact Target, Edmunds, and many others. Here are a few quotes from existing customers…
"It's like a profiler that you can run in production" -- Leonid Igolnik, Taleo
"We found that the overhead was negligible" -- Jacob Marcus, Care.com
"We wanted a monitoring solution that wouldn't impact our production runway" -- John Martin, Edmunds
AppDynamics overhead is extremely low but I suggest you test it and see for yourself. You can download and use it for free from the AppDynamics website. Good luck in your search for the right APM tool.