As a Senior Oracle DBA with decades of experience optimizing databases, I was initially skeptical about AI's ability to handle the nuanced art of SQL optimization. Two days and hundreds of automated tests later, I had built a tool that proved AI...
Back in May, Amit Parikh wrote about the four ways to transform your business in the ROI of proactive database observability. We're excited to share that the recent release of Foglight 8.0 is engineered to help you realize these benefits. But first,…
AI adoption is accelerating at an alarming pace (you'll see what I did there), revolutionizing industries and fundamentally changing how companies, institutions, and people address data challenges.
Quest's Foglight for Databases is no exception with …
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&nb...
The Problem: When PGA Memory Goes Wild
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 t...
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...
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.…
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 t...
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 isolate…
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 …
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 pro…
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&…
