FogLight Footprint - Foglight for Databases - Foglight for Databases - Dell Community

FogLight Footprint

FogLight Footprint

This question is answered

What is the performance impact / footprint on each SQL Server instance for Foglight ? Does it support monitoring of SQL 2008 (inlcuding Reporting, Analysis Services ) ?

Verified Answer
  • 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,

    Jeff

All Replies
  • The Foglight SQL Server agent, like all Foglight agents, is designed to capture useful metrics for alerting and diagnosis with the smallest possible performance impact and footprint. The agent overhead will be higher if more data is collected more frequently and lower if less data is collected less frequently. The agent properties determine both the amount and frequency of data collection and can be tuned to minimize overhead or maximize diagnostic potential. According to the CartridgeForSQL2005.html guide, SQL Server 2008 is supported provided the hot-fix described in [url=https://support.quest.com/SUPPORT/index?page=solution&id=SOL46417]SOL46417[/url] on SupportLink is in place.

    Regards,
    Brian Wheeldon
  • I have a related question regarding Foglight and Foglight Performance analysis. Can accessing and using Foglight or Foglight PA impact the performance of the production systems being monitored if the foglight application and databases are located on a separate server? We want to grant more developers access to Foglight Performance Analysis and want to know if this can possibly impact the production systems they would be monitoring? Thanks! John.
  • 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,

    Jeff

  • Hi Jeff, That is exactly the information I was looking for. Thank you! John.