Custom Dashboards and Reports in Foglight 7
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 th...
Alerting when Foglight Data Collection has a Problem
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...
Removing Artifacts in Foglight
Foglight has a retention policy for the data that is collected from the monitored environment. For SQL Server, the default is "medium" or 90 days. If an object (eg. a database) is removed from the mon...
Problems Configuring a SQL Server Connection in Spotlight Enterprise
*Record Scratch* *Freeze Frame* Yup, that's me. You're probably wondering how I got into this situation... I was just minding my own business, trying to configure a SQL Server connection in Spotlight...
Setting up Email Notification for Specific Objects in Foglight
Let's take a closer look at narrowing down the scope of a rule. The use case I normally hear is, we have some important jobs, databases, etc. that we want alarms for, but we don't want alarms for the ...
Adding Email Notification to Database Alarms
Foglight ships with a rich set of pre-configured rules to alert you when issues arise with your databases. The default action is to put an alarm message on the dashboards within Foglight. Email notifi...
Using Alarm Templates in Foglight 6
In this post, we looked at how to create an alarm template via the Databases dashboard. If you followed the steps outlined, you would've ended up in the Alarm Templates dashboard with a new template. ...
Introduction to Alarm Templates in Foglight 6
With the release of Foglight version 6, alarm management has been simplified with the use of alarm templates. You can access Alarm Templates directly from the left-hand panel in the new UI. However, ...
Setting Different Thresholds for Tablespaces
We're often asked how to create an alarm threshold exception for certain types of objects. Using the Databases -> Configure Alarms dashboard, you can change thresholds at the instance level. That work...
Foglight Database Ports
I was trying to come up with a clever title for this post, and even googled "good network port jokes" but they were all blocked. Badum-Tiss.. For this post, we can refer to this general Foglight archi...
Exploring User Level Access for Databases
I recently worked with a customer on the following use case. They've successfully integrated Active Directory logins with Foglight and wish to match up an AD Group with a group on the Databases dashbo...
Getting the “All Clear” from Foglight
A customer asked how to implement and email that indicates an alarm has been cleared. In Foglight, there are typically several ways to do that. In this post, we'll look at creating a new rule that fi...