A UI Query can be used to add either static or dynamic components to a service definition via the Service Builder dashboard. This in turn offers a great range of additional things Foglight can do. Thi...
In the first part of this series, we will learn how to export SQL statements from Foglight SQL Performance Investigator, and import them into SQL Optimizer. Start by opening SQL PI, and selecting a da...
A UI Query can be used as a shortcut to building a custom dashboard or report. This can save time and frustration by publishing either frequently accessed or hard to find data in an easy to use spot. ...
A UI Query can be used as an input to a report. This can simplify and offer a broader range of inputs when running or scheduling a report. For a refresher on creating UI Queries, this post covers the...
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....
Think of a UI Query as a shortcut to data that you can use in a report, dashboard, service definition, etc. This post will show how to get started building queries. The example today will be to get a...
We haven't added voice command to Foglight yet, but we can still get Foglight to play some tunes. I setup a small monitoring environment with a Foglight Management Server in a public cloud. I put a lo...
Creating your own dashboard in Foglight is as easy as putting up the Festivus pole. In this post, a service containing all MySQL instances was created. A great feature of Foglight is the ability to c...
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...
When you first monitor a database instance, you have the option of adding the host too. But sometimes, the checkbox is un-checked. Now what? To add a host to monitor on it's own, switch the left-hand...
When you setup monitoring for SQL Server or Oracle, the checkbox to enable SQL PI is off initially. Here's what to do to enable it after setting up a monitoring connection. From the Databases dashboar...
What if you could get a list of all metrics and observations collected by Foglight, and have the ability to filter/sort by cartridge and topology type? That would be groovy. My colleague Mark.Bai deve...
