Where can UI Queries be Used in Foglight?
In my Introduction to UI Queries post, the building of a simple query to return all SQL Server Agent Jobs was shown. Let's back up a step, and take a look at where UI Queries can be used in Foglight....
Simple Way to Add E-Mail Notifications
Foglight has a robust rules engine for alerting and notification. It's often the case that you can get to the same end zone in Foglight by many different plays. Using the Service Builder is an easy wa...
Monitor Postgres Disk Space Usage with Foglight
Many things can happen if the database runs out of disk space. None of them are good. DBAs understand that it is essential to monitor database disk space so that critical business processes are uninte...
Ch-Ch-Ch-Ch-Changes (-David Bowie)
“The Only Thing That Is Constant Is Change “- Heraclitus. Development, new applications, upgrades, patches, maintenance, schema updates…the list goes on and on around ways that changes are introduced ...
“License and Registration, please…” Spotlight
So, you’ve downloaded and installed an evaluation of Spotlight Enterprise. Good news…it comes with a 30-day evaluation license key! Spotlight is fully functional (not limited trial functionality). It ...
How Do You Solve a Problem with Maria(DB)? Or Cassandra Or Mongo or SQLServer?
Apologies to Rogers and Hammerstein; but the title fits. In addition to listening to the scores of old musicals, one of my hobbies is watching the weather. I have about 20 years of weather data in ...
Slacking off? How to Send Foglight Alarms to #slack
This post will show how to integrate Foglight alarms into a #slack channel. It is a very easy and quick process. The longest step will likely be to request email app access from your slack admin. Once...
Creating Rule for User-Defined Queries in Foglight
One of the powerful features of Foglight for Oracle and Foglight for SQL Server is the ability to enter your own database queries (SQL) and have the Foglight collector execute these and return data. T...
Why be NORMAL?
When monitoring databases for performance, we certainly want to understand things like CPU spikes, memory pressure, I/O latency, and the like. If we see this type of performance, the next step is to t...