A SQL query beginning with the following text causes high CPU and waits when SQL PI is enabled.
JVM sizing on the FMS and/or Foglight Agent Manager were insufficient.
Confirm that the JVM heap sizing requirements in the Foglight for Databases Deployment Guide are met on the FMS and Foglight Agent Manager servers.
If the JVM heap sizing has been met, then try increasing the JVM heap sizing on both the FMS and FglAM.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center