Why does the "SQL Activity"dashboard only display data for the last 60 min?
SQL Server activity dashboard only reports the last 60 minutes because only sixty minutes of "Top Sessions" data is stored.
In the Foglight Cartridge there would not be a way of seeing historical sessions as the dashboard only has information for the last hour.
In Performance Analysis for SQL Server or SQL Performance Investigator the session information is available for the last one hour, under the "Real Time" tab. After one hour the data is visible in "History" tab, under different dimensions (for example: DBuser, OSUser, Program etc.).