If Top N and CLW queries create ongoing problems in your environment, you can set the properties mentioned in step 2, to limit the query resource consumption. By default, these properties are set to 0 (which means that there is no clamp). Please do the following:
1. Make sure the EM is configured and tunned by following below TEC DOC "APM Cluster Performance Health Check":
2. Update the following properties within the EnterpriseManager.properties file as below:
3. Restart the Enterprise Manager
NOTE: If running additional outside queries as noted above, if you find your cluster performing slowly while these queries are executing, you may want to lower the limits on the above properties. Please note that anytime you change those properties above, you need to restart the EM.