We’re proud to announce the general availability of Foglight® Cloud, the latest evolution of Quest’s powerful database monitoring and optimization solution. Built for today’s hybrid and cloud-first enterprises, Foglight Cloud introduces…
We’re proud to announce the general availability of Foglight® Cloud, the latest evolution of Quest’s powerful database monitoring and optimization solution. Built for today’s hybrid and cloud-first enterprises, Foglight Cloud introduces…
Recently, a customer approached us with a common yet challenging issue: “We have many queries consuming a lot of PGA memory. Can Foglight help us find which queries consume the most?”
This question touches…
On a customer call recently and the customer was asking if our Foglight for Oracle agent included an alert for blocking locks.
This is a rare question for me, since Oracle database customers don’t tend to see issues with blocking locks compared to SQL…
Integrating Foglight alerts with incident.io can streamline your incident management process. This guide will walk you through the steps to set up this integration efficiently.
A customer recently asked if Foglight alerts can integrate with Incident.io…
This will be a short post, but I didn't want to gloss over this new feature in Foglight Cloud 7.3.1.
SQL Performance Investigator (SQL PI) keeps workload data for two years, but there will be different granularity levels depending on the age of the…
In Foglight Cloud 7.3.1, you now have the ability to generate and view the execution plan for PostgreSQL.
Within SQL Performance Investigator, you can choose your time frame and drilldowns. In this case I started with the most recent hour and isolated…
Foglight Cloud 7.3.1 went GA this week with a new feature to interact with alarms.
It is a separate feature that will need to be enabled for your subscription.
Once enabled, you can bring up an alarm and investigate further with the "Foglight Alarms AI…
So here is an interesting example of using Quest solutions together. What if you have Foglight, you are monitoring a database, you find a SQL Server stored procedure that is getting slower, and slower and you want to know what the purpose of this proc…
Every day we see technologies evolve and we are requiring to handle more data and tasks, this applies to multiple services and data pipelines that maintain them. Whilst we adapt to fast changing environments, it's important to monitor them and setup…
Foglight offers the capability to use scripts to build monitoring agents for any purpose. This blog describes a custom agent to monitor Informix instances. Please understand this cartridge as an example and template that can be customized and improved…
From Foglight version 6.3 onwards a lot of development has gone into updating the security of Foglight, that could be upgrading various components to the latest versions but also ensuring the agents negotiate the highest security protocols when connecting…
Configuring user-defined collections (UDCs) and adding rules to alert upon the result have been covered previously in this blog.
With Oracle and SQL Server, UDCs are stored in the Foglight topology model at the instance level.
I found a special case with…
I've got our database load testing product, Benchmark Factory (bmf), running load tests on various database platforms in our lab. Sometimes the host reboots and then BMF needs to be restarted. Since I'm monitoring the host with Foglight, I decided to…
A common requirement for any monitoring solution is to integrate with a service desk ticketing system.
Most will accept an email or API call to create tickets if the monitoring solution detects an issue.
I recently worked with a customer who needed their…
One of my favourite features to write about in Foglight isn't really a feature at all - it's more like a foundational building block that enables you to do interesting things.
UI queries are simply a path to the underlying data. They are particularly…
For those that have used the Database Expansion Pack in the past, you may have noticed 2 rules for alarm automation.
I've broken these rules out into a separate cartridge for ease of use.
The cartridge is installed via the Cartridge Inventory dashboard…
A customer recently asked if they could integrate Foglight alerts with everbridge xmatters. I took a look into it and within 30 minutes it was working.
Start by logging into your xmatters account and add the "Trigger Alerts by email" workflow.…
Data being the lifeblood of organizations now, it stands to reason that keeping the right data available to the right people is a key to success in business today. And lowering costs while still positioning the organization for desired growth and positive…
We're thrilled to announce the general availability of Foglight Cloud, a transformative solution reshaping how organizations manage and monitor their IT environment. Foglight Cloud…
I was recently talking to a customer who wanted some help tracking Oracle process memory usage on Windows. They had a problem with a bug causing a memory leak and had a support case open for that. They were happy with the SQL PI feature in Foglight that…
Foglight 6 development switched to using Angular for UI components. Examples of these are Alarm Templates, Notification Channels, Audit Log and the fantastic enterprise SQL view Query Insights.
One thing that is not in the new UI is the ability to create…
I was asked recently if there are any alerts when Foglight has a problem collecting data.
The answer is, there are several ways.
For SQL Server, there is a rule named "DBSS-Collection Status" that can be managed via alarm templates and notification channels…
I received a question today from a customer about alerting on index fragmentation within Foglight. We don’t provide this feature out of the box, but we could add this as a custom feature.
So, to begin with, let’s consider how we find this information…
So, assuming you have the agent collecting (from the previous blog post: Real life question. Love Foglight for SQL but could it also help us with monitoring files? Answer Yes) we can navigate to Create Rule and start to create the rule.
I’ve highlighted…
So, this question came up recently with a customer. Lots of teams also have these additional questions that would make their lives so much easier.
I decided to mock up an example and document it for them. They have a process that dumps csv files in folder…
