In the SQL Performance Investigator (SQL PI), Workload (or CPU ) | instance View, there is no data to display.
When navigating to "Workload | Instance View | SQL Statements", a message displayed : "No SQL Statements were found waiting for "Workload" related resources during the selected time."
When disabling SQL PI everything reverts back to normal.
CAUSE 1
The SQL PI environment does not meet the sizing requirements of the product.
CAUSE 2
Foglight Management Server (FMS) timezone was incorrectly set to America/Los Angeles which caused time & date mismatch between SQL PI and FMS.
RESOLUTION 1
Please review the Foglight for databases sizing guide to confirm the sizing requirements have been met.
RESOLUTION 2
Ensure that FMS and FglAM timezone are in sync.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center