What is the performance impact / footprint on each SQL Server instance for Foglight ? Does it support monitoring of SQL 2008 (inlcuding Reporting, Analysis Services ) ?
For the most part there would be no impact. All accesses of Performance Analysis data goes against the middleware server and long term repository so there is no impact on the monitored database or monitored database server as the collection agent is unaffected by the users access Performance Analysis. For Foglight, the vast majority of the data which is accessible in the dashboards is stored in the Foglight repository so there is no impact on the monitored server. However, there are two areas where there can be a minor effect on the monitored DB. As a user drills down into different dashboards, the collection frequency can change from offline, to online to real time. This is configurable but the default behavior would be some minimal additional load on the monitored DB. Additionally, a few dashboard allow for immediate data collection where the data is only collected if the user requests it on that dashboard, tablespace fragmentation and invalid object details are two examples of this. Neither would put a dramatic load on the DB, but it is more than zero.
I hope this helps,