Foglight Database Expansion Pack

Hello all.  I am pleased to provide the latest release of my Foglight Database Expansion Pack for general use.  Any customer (current or future) is encouraged to install this pack into their Foglight deployment in order to take advantage of the dashboard and reports it provides.  If anyone has any comments, questions, concerns, or ideas for future dashboards, please post below!

Current version: 5.1.1 (minor update with customer specific enhancement to Enterprise Always On Dashboard) <CLICK FILE BELOW TO DOWNLOAD>

Database_Expansion_Pack-5_1_1.zip

* I've found an issue with running the pack on a version 5.7.1 Foglight Management Server.  I have not yet been able to diagnose and fix the issue, so those running that version will currently be unable to use the SQL Server dashboards.  The Oracle dashboards and all of the reports seem to work fine on 5.7.1.  Those who are on 5.7.1 that would like to use the expansion pack will need to upgrade their Foglight Management Server to 5.7.5, or wait until I have a chance to fix the problem.  No ETA at the moment.

** Disclaimer ** This custom cartridge will only fully function against Foglight version 5.6.4 w/ the SQL Server and Oracle 5.6.4 cartridges (and higher). Installing this custom cartridge to a prior version of Foglight may yield errors.

 

Attached you will find the current release of my "Database Expansion Pack". The goal of this custom cartridge, is to showcase the wide range of possibilies that Foglight's custom tooling can provide our customers. I hope that the dashboards and reports included in this pack, will serve as added motivation for all of our customers to extend upon Foglight's out of the box capabilities, and make the solution their own.

 

This pack should be considered beta. I have tested it's functionality to the extent that I am able, and therefore cannot make any guarantee's that there will not be issues. As issues are reported I will do by best to address them.

 

Currently included in the pack are the following dashboards/reports:

 

  • DB Expansion Pack
    • Oracle
      • Dashboards
        • CPU Summary: For a particular Oracle Instance, displays CPU relevant metrics.
        • Enterprise Execution Rate Summary: For all monitored Oracle instances, displays execution rate statistics.
        • Enterprise Instance Availability Summary: For all monitored Oracle instances, displays avaiability metrics.
        • Enterprise Oracle Performance Summary: For all monitored Oracle instancesm displays high level performance metrics.
        • Instance Execution Rate Summary: For a particular Oracle instance, displays trended execution rate metrics.
        • Memory Summary: For a particular Oracle instance, displays trended Memory metrics.
        • Network Summary: For a particular Oracle instance, displays trended Network metrics.
        • Tablespace Growth Summary: For a particular Oracle instnace, displays trended tablespace growth.
    •  

      • Reports
        • Enterprise Instance Availability Report: For all monitored Oracle instances, reports on instance availability.
        • Enterprise Oracle Execution Rate Report: For all monitored Oracle instances, reports on execution rate statistics.
        • Enterprise Oracle Performance Summary Report: For all monitored Oracle instances, reports on high level performance metrics.
        • Tablespace Growth Report: For a particular Oracle instance, reports on tablespace growth.

       

    • SQL Server
      • Dashboards
        • Capacity Planning: For a particular SQL Server Instance, displays database growth and future storage projections.
        • CPU Summary: For a particular SQL Server Instance, displays CPU relevant performance metrics trended over a user defined time range.
        • Database Backups: For a particular SQL Server instance, displays all SQL Server databases, and how long it has been since a backup has occurred.
        • Database Transaction Rate Summary: For a particular SQL Server instance, summarizes transaction rate metrics. Batches/sec per database, and query volume metrics are included.
        • Enterprise Capacity Planning Summary: For all SQL Server instances, displays aggregated storage metrics, along with future storage projections.
        • Enterprise Instance Availability Summary: For all SQL Server instances, displays instance and OS availability. Updated to show real time and historical availability for all instances, along with color coding to highlight instances with availability problems.
        • Enterprise Filtered Availability Summary: Similar to dashboard above, however only shows servers that have experienced availability issues.
        • Enterprise SQL and Windows Host Comparison Summary: For all SQL Server instances, displays SQL and Host CPU/Memory Statistics.
        • Enterprise SQL Database Files Summary: For all SQL Server Instances, displays all data and log files along with storage (space used, allocated, and autogrow settings), and performance (virtual file stats) metrics.  Searching and filtering allows for quick access to specific databases/files.
        • <NEW>Enterprise SQL Server Always On Summary: Displays all SQL Server Always On Availability Groups in an environment, along with where each replica sits, and what each replica's role is, along with alarm and latency metrics.
        • Enterprise SQL Server Backup Summary: For all SQL Server instances, displays last backup time (recovery point) for each database.
        • Enterprise SQL Server Config Summary: For all SQL Server instances, displays sp_configure settings. Searching, sorting, and filtering can be used to isolate specific servers and configures.  Useful in comparing configuration settings across servers.
        • Enterprise SQL Server Job Summary: For all SQL Server instances, displays job statistics with searching and filtering capabilities.
        • Enterprise SQL Server Performance Summary: For all SQL Server instances, displays high level performance stats.
        • <NEW>Enterprise SQL Server Resource Utilization Dashboard: For all SQL Server instances, displays CPU utilization, Memory Page Life Expectancy, Disk Latency, and Storage consumption.  Servers are color coded by those that are over (red) or under (green) utilized.  Also included are a list of all SQL Server databases across all instances, with transactions per second metrics.
        • Enterprise Transaction Rate Summary: For all SQL Server isntances, displays transaction rate statistics.
        • IO Summary: For a particular SQL Server Instance, displays IO rate statistics, broken down by disk device and process.
        • Memory Summary: For a particular SQL Server Instance, displays memory specific metrics.
        • Monitored Instance and Database Count: Displays the total number of instances and databases being monitored, trended over time.
        • Network Summary: For a particular SQL Server Instance, displays network specific metrics.

         

      • Reports
        • Capacity Planning Report: For a particular SQL Server Instance, displays database growth and future storage projections.
        • Database File Growth Report: For a particular SQL Server Instance, displays data and log file growth.
        • Database Transaction Rate Report: For a particular SQL Server instance, summarizes transaction rate metrics. Batches/sec
        • Enterprise Availability Summary Report: For all SQL Server Instances, displays instance and OS availability.
        • Enterprise Capacity Planning Report: For all SQL Server instances, displays aggregated storage metrics, along with future storage projections.
        • Enterprise SQL Database Files Report: For all SQL Server Instances, displays all data and log files along with storage (space used, allocated, and autogrow settings), and performance (virtual file stats) metrics. 
        • Enterprise SQL Server Backup Summary Report: For all SQL Server instances, displays last backup time (recovery point) for each database.
        • Enterprise SQL Server Job Summary Report: For all SQL Server instances, displays job statistics.
        • SQL Server and Windows Host Resource Comparison Report: For all SQL Server instances, displays SQL and Host CPU/Memory Statistics.
        • SQL Server Resource Usage Report: For a particular SQL Server instance, displays performance metrics trended over time.

  

In the Administration -> Cartridges -> Cartridge Inventory dashboard, press the "Install Cartridge" button. Point to the downloaded cartridge file, and click the "Install Cartridge" button. Once loaded, you should see the "DB Expansion Pack" module in the left hand navigation tray (you may need to refresh the browser for it to show up). You can expand this module and select the dashboards or reports to view.

 

 

I'm interested in any and all feedback!

  • Thank you!  Handy features you have in this dashboard.  Just about everything I would build in a dashboard!  

    Is it possible to add a database drop down feature to allow the user to select a database (server) more easily than going through the "Page Inputs" -> "General" section?  Maybe the ability for the end-user that has only limited access, to select from THEIR selection of databases.

    Thanks again!

  • In reply to john.waclawski:

    This is theoretically possible, however I'll need to balance the the complexity of creating and maintaining something like that, vs. the fairly simply method provided out of the box using the Page Inputs that you've seen. I'll definitely take a look and see if something jumps out as a potential solution.