When going into the SQL Performance area of the database dashboard, data can be selected for 1, 2 and 4 hours but no data is seen for a time frame greater than four hours.
SQL PI does not roll up data more than four hours
Eight hours of data cannot be seen in SQL PI
Insufficient permissions on the SQL PI WIndows host where the Foglight Agent Manager uses a named Windows Service account
Please refer to KB 154496 with details on setting the necessary Windows OS permissions for SQL PI repository servers using a named Windows Service Account.
* This is the most common resolution to this issue.
The SQL PI extension for the SQL PI repository needs to be disabled and then enabled to rectify this issue. To disable the SQL PI extension do the following:
This issue was logged as SSDB-15073 and fixed in the 188.8.131.52 and higher versions of the SQL Server cartridge