On Thursday, September 24, 2020, Postgres version 13 was officially released. As opposed to a release full of "new features", Postgres 13 largely improves upon existing functionality. The Release Notes can be found here -> https://w...

Expand Foglight Monitoring Beyond Infrastructure View the webcast here This webcast covered: How to use script agents, User Defined Collections and the REST API to monitor things like freezer temperatures, soil moisture levels or the air conditionin…

Foglight for Databases now includes enhancements to the Performance Investigator Repository, new alarms, FIPS compliance & a quick start tour.

In this post, we looked at a simple way to adjust the global threshold for an alarm. We'll build on that now. What if we have a 1:n relationship between, for example, an instance and databases, jobs, etc.? A common request is to set a different t...

I usually tell Foglight customers that there are going to be multiple ways to do something to reach an end goal. If you want to adjust the global threshold for an alarm, a very easy way is to click on the alarm as it happens, and go to the Sourc...

This use case came in recently - "How can we build an ‘exec’ view that doesn’t include a bunch of junk alarms?"  This is a great case for the Service Builder and Alarm Filters. When you create a service, you can also use that…

In this post, alarms were configured to only fire upon the instances contained within a Database Group. These groups are created and managed from the Databases dashboard, but underneath, they are really service definitions. Now, what if we are using …

We often get requests to only fire certain alarms (eg. hours since last log backup) on a specific set of instances (or other objects, like jobs, databases, etc.). One way to do that is to leverage the Database Groupings and use those to limit the ala…

SQL Server provides us with a number of high availability and disaster recovery solutions. Two of them are Always On Availability Groups and Always On Failover Cluster offerings. In order to leverage these options, they themselves need to be constan…

One of the primary needs of those responsible for maintaining the health of database environments is to efficiently find poorly performing queries. Are there resource-intensive queries running? Are there long-running queries running? Who is running t…

Spotlight reports are designed in SQL Server Report Definition files (RDL) and stored in the local installation folder of Spotlight client application making them accessible to Spotlight users. By default this path in Spotlight is C:\Program Files (x…

Spotlight users sometimes ask if it offers baseline capabilities. Though Spotlight does not learn a baseline of workload activity, it does provide the ability to view particular metric values over customizable timeframes. In doing so, it may allow fo…