Getting Rid of Junk Alarms from Dashboard
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 servi...
Configure Alarms for a Sub-set of Instances – Part II
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 real...
Configure Alarms for a Sub-set of Instances
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...
Auditing SQL Server with Advanced Filters
I recently had a customer ask if they can audit SELECT operations for 1 table and 1 view in a specific database where the SELECT only contains certain keywords. This article covers advanced filtering ...
Using Foglight with Google Cloud SQL
We were recently asked if Foglight can be used to monitor Google Cloud SQL instances, specifically MySQL, PostgreSQL and SQL Server. To clarify, these are the PaaS (or DBaaS) offerings from Google. Wi...
Another Use Case for Database Groups
On the Foglight for Databases main dashboard, you can create groupings of instances. These can be used to filter the dashboard, enable easier user-level access, and even allow fine tuning of alarms. ...
Making sense of vmId and hostId.. wait, what?
Most of my blog topics come from customer questions and use cases. This is one I lost sleep over. The use case was to limit a disk usage rule from firing on a specific host. It got bigger when we dug ...
Adding Services to Infrastructure Dashboard
A few years ago, I wrote this blog detailing how to get host services created on the Hosts dashboard to show up in the Service Operations Console. Creating a service via the Hosts dashboard is quick a...
Another way to gather VMware metrics on SQL Server hosts
In this post, I alluded to 2 ways to capture VMware metrics with Foglight for SQL Server. The steps below apply to SQL Server running on Windows only. Since VMware Tools pulls metrics into the VM, we ...
Correlating VMware metrics with SQL Server Performance – in 2 Parts
There are a couple easy, free ways to get VMware metrics collected by Foglight for SQL Server. This first part shows the easier way. When setting up the monitor for SQL Server, you can select (or not)...
Foglight for Oracle – Invalid Objects Filtering
With Foglight for Oracle, invalid objects are monitored and alerted upon for each schema. While it's possible to exclude schema's from monitoring, this can be tedious if you only have a handful of sch...
Updating Foglight Agent Manager JVM Settings
Depending on how many databases, hosts, etc. that you wish to monitor, the JVM memory settings for the Foglight Agent Manager (Fglam) may need to be adjusted. There is a way to do this from the Fogl...