Hey all.  I’m happy to offer the newest launch of my Foglight Database Enlargement Pack for common use.  Any buyer (present or future) is inspired to put in this pack into their Foglight deployment in an effort to make the most of the dashboard and reviews it supplies.  If anybody has any feedback, questions, considerations, or concepts for future dashboards, please publish beneath!

Present model: 6.6.2 Replace now features a Cross Platform Database Heatmap!  Accessible from the Analytics folder within the DB Enlargement Pack module.

THIS VERSION REQUIRES FOGLIGHT MANAGEMENT SERVER 5.9.3 OR HIGHER.  IF YOU ARE RUNNING A PRIOR VERSION OF THE FOGLIGHT MANAGEMENT SERVER, PLEASE DOWNLOAD THE OLDER VERSION BELOW:

<CLICK FILE BELOW TO DOWNLOAD VERSION 6.6.2 for FOGLIGHT MANAGEMENT SERVER 5.9.3 AND UP>

7571.Database_Expansion_Pack-6_6_2.zip

<CLICK FILE BELOW TO DOWNLOAD VERSION 5.4.5 for FOGLIGHT MANAGEMENT SERVERS PRIOR TO 5.9.3>

2627.Database_Expansion_Pack-5_4_5.zip

Connected you can see the present launch of my “Database Expansion Pack”. The aim of this practice cartridge, is to showcase the wide selection of possibilies that Foglight’s customized tooling can present our clients. I hope that the dashboards and reviews included on this pack, will function added motivation for all of our clients to increase upon Foglight’s out of the field capabilities, and make the answer their very own.

 

This pack must be thought of beta. I’ve examined it is performance to the extent that I’m in a position, and due to this fact can’t make any assure’s that there is not going to be points. As points are reported I’ll do by greatest to deal with them.

 

Presently included within the pack are the next dashboards/reviews/guidelines:

 

Customized Dashboards and Stories

  • DB Enlargement Pack
    • Analytics
      • <NEW>Database Heatmap: Throughout all monitored cases, shows an alarm oriented heatmap.  Servers can be shade coded and sized based mostly on alarm severity and rely.
    • Cross Platform
      • Dashboards
        • Enterprise Disk House Abstract: Throughout all monitored working programs, shows disk area utilization.
    • Oracle
      • Dashboards
        • CPU Abstract: For a specific Oracle Occasion, shows CPU related metrics.
        • Enterprise Execution Fee Abstract: For all monitored Oracle cases, shows execution fee statistics.
        • Enterprise Occasion Availability Abstract: For all monitored Oracle cases, shows avaiability metrics.
        • Enterprise Oracle Efficiency Abstract: For all monitored Oracle instancesm shows excessive stage efficiency metrics.
        • Occasion Execution Fee Abstract: For a specific Oracle occasion, shows trended execution fee metrics.
        • Reminiscence Abstract: For a specific Oracle occasion, shows trended Reminiscence metrics.
        • Community Abstract: For a specific Oracle occasion, shows trended Community metrics.
        • Tablespace Development Abstract: For a specific Oracle instnace, shows trended tablespace progress.
    •  

      • Stories
        • Enterprise Occasion Availability Report: For all monitored Oracle cases, reviews on occasion availability.
        • Enterprise Oracle Execution Fee Report: For all monitored Oracle cases, reviews on execution fee statistics.
        • Enterprise Oracle Efficiency Abstract Report: For all monitored Oracle cases, reviews on excessive stage efficiency metrics.
        • Tablespace Development Report: For a specific Oracle occasion, reviews on tablespace progress.

       

    • SQL Server
      • Dashboards
        • Capability Planning: For a specific SQL Server Occasion, shows database progress and future storage projections.
        • CPU Abstract: For a specific SQL Server Occasion, shows CPU related efficiency metrics trended over a consumer outlined time vary.
        • Database Backups: For a specific SQL Server occasion, shows all SQL Server databases, and the way lengthy it has been since a backup has occurred.
        • Database Transaction Fee Abstract: For a specific SQL Server occasion, summarizes transaction fee metrics. Batches/sec per database, and question quantity metrics are included.
        • Enterprise Capability Planning Abstract: For all SQL Server cases, shows aggregated storage metrics, together with future storage projections.
        • Enterprise Occasion Availability Abstract: For all SQL Server cases, shows occasion and OS availability. Up to date to indicate actual time and historic availability for all cases, together with shade coding to focus on cases with availability issues.
        • Enterprise Filtered Availability Abstract: Much like dashboard above, nonetheless solely reveals servers which have skilled availability points.
        • Enterprise SQL and Home windows Host Comparability Abstract: For all SQL Server cases, shows SQL and Host CPU/Reminiscence Statistics.
        • Enterprise SQL Database Information Abstract: For all SQL Server Cases, shows all information and log recordsdata together with storage (area used, allotted, and autogrow settings), and efficiency (digital file stats) metrics.  Looking and filtering permits for fast entry to particular databases/recordsdata.
        • Enterprise SQL Server All the time On Abstract: Shows all SQL Server All the time On Availability Teams in an atmosphere, together with the place every reproduction sits, and what every reproduction’s function is, together with alarm and latency metrics.
        • Enterprise SQL Server Backup Abstract: For all SQL Server cases, shows final backup time (restoration level) for every database.
        • Enterprise SQL Server Config Abstract: For all SQL Server cases, shows sp_configure settings. Looking, sorting, and filtering can be utilized to isolate particular servers and configures.  Helpful in evaluating configuration settings throughout servers.
        • Enterprise SQL Server Job Abstract: For all SQL Server cases, shows job statistics with looking out and filtering capabilities.
        • Enterprise SQL Server Efficiency Abstract: For all SQL Server cases, shows excessive stage efficiency stats.
        • Enterprise SQL Server Useful resource Utilization Dashboard: For all SQL Server cases, shows CPU utilization, Reminiscence Web page Life Expectancy, Disk Latency, and Storage consumption.  Servers are shade coded by these which might be over (pink) or beneath (inexperienced) utilized.  Additionally included are a listing of all SQL Server databases throughout all cases, with transactions per second metrics.
        • Enterprise Transaction Fee Abstract: For all SQL Server isntances, shows transaction fee statistics.
        • IO Abstract: For a specific SQL Server Occasion, shows IO fee statistics, damaged down by disk system and course of.
        • Reminiscence Abstract: For a specific SQL Server Occasion, shows reminiscence particular metrics.
        • Community Abstract: For a specific SQL Server Occasion, shows community particular metrics.

         

      • Stories
        • Capability Planning Report: For a specific SQL Server Occasion, shows database progress and future storage projections.
        • Database File Development Report: For a specific SQL Server Occasion, shows information and log file progress.
        • Database Transaction Fee Report: For a specific SQL Server occasion, summarizes transaction fee metrics. Batches/sec
        • Enterprise Availability Abstract Report: For all SQL Server Cases, shows occasion and OS availability.
        • Enterprise Capability Planning Report: For all SQL Server cases, shows aggregated storage metrics, together with future storage projections.
        • Enterprise SQL Database Information Report: For all SQL Server Cases, shows all information and log recordsdata together with storage (area used, allotted, and autogrow settings), and efficiency (digital file stats) metrics. 
        • Enterprise SQL Server Backup Abstract Report: For all SQL Server cases, shows final backup time (restoration level) for every database.
        • Enterprise SQL Server Job Abstract Report: For all SQL Server cases, shows job statistics.
        • SQL Server and Home windows Host Useful resource Comparability Report: For all SQL Server cases, shows SQL and Host CPU/Reminiscence Statistics.
        • SQL Server Useful resource Utilization Report: For a specific SQL Server occasion, shows efficiency metrics trended over time.
See also  Desmos – Gold & Ratios

 

Customized Guidelines

This newest launch of the Enlargement Pack additionally consists of two customized guidelines designed to assist Foglight admins clear and purge outdated alarms they could not care about.  These alarms are disabled by default, however will be enabled by way of the Administration -> Guidelines & Notifications -> Guidelines interface, choosing the alarms, and clicking the allow button:

These alarms reference two registry variables (AlarmClearAfterDays and AlarmDeleteAfterDays).  These registry variables outline after what number of days alarms can be cleared, and likewise deleted.  The default conduct is that alarms can be cleared after 3 days, and deleted after 30 days, nonetheless these variables will be personalized nonetheless you want.  The screenshot beneath reveals the place these registry variables will be personalized within the Administration -> Guidelines & Notifications -> Handle Registry Variables interface:

  

 

To Set up the Database Enlargement Pack Cartridge

Within the Administration -> Cartridges -> Cartridge Stock dashboard, press the “Install Cartridge” button. Level to the downloaded cartridge file, and click on the “Install Cartridge” button. As soon as loaded, you must see the “DB Expansion Pack” module within the left hand navigation tray (you could have to refresh the browser for it to indicate up). You possibly can increase this module and choose the dashboards or reviews to view.

 

 

I am fascinated about any and all suggestions!

Leave a Reply

Your email address will not be published.