Please find below the recommended below configuration in "APM Insight .NET Agent Configuration Options" in production environment:
Log level ("Basic Configuration Profiles" tab) - OFF or ERROR.
Sampling factor ("Web Transactions Configurations" / "Background Transactions Configurations" tab) - 10 to 20 depending on the traffic on the website(s) being monitored.