Does PROFILERs overhead affect how and where a site should use the product? Is PROFILER more likely to be used in Development/Test environments than in Production environments?
When PROFILER is not active, there should be virtually no overhead. When PROFILER is active, it monitors each and every NATURAL statement that is executed. Because of this, PROFILER can generate unnecessary overhead in a Production environment. For this reason, we do not recommend executing PROFILER in Production.