We are very excited to announce the general availability of Foglight for Databases v5.9.7.20, featuring the new Performance Investigator (PI) for Azure SQL DB.
Background
PI is one of Foglight’s most popular features. Its main functionality is ...
Time to wrap up automation of alarm blackouts in Foglight.
In this post, we looked at using the command line to implement alarm blackouts. We used topology queries to match a host name or pattern for an instance (eg. dbss_instance.name like '%Y...
In this intro post, we looked at some basics of setting alarm blackouts via the command line. These commands can then be automated via script to include in a maintenance job, for example.
Any object can be referenced in the topology query - in this e…
There are two ways to manage blackouts in Foglight - from the UI and from the command line. The options are generally the same. The command line provides us the ability to automate the blackout by using the command line utility in our maintenance scr…
In the previous post on User-Defined Collections (UDC's), we looked at using a view to hide the underlying objects of the query, and also the tip of setting the datatype to string.
In this final post, I'll show how to use a stored ...
By now you may have noticed that I focus on parts of Foglight that you can easily customize in order to solve your specific use cases. We'll build on the previous post on User-Defined Collections (UDC's) in Foglight.
In the previous post...
In this post, some tips for working with User-Defined Queries (UDC's) were introduced.
We left off with the idea of creating a custom dashboard showing UDC results from multiple instances.
The Foglight data model is organized with a controlling r...
The ability to enter your own queries into Foglight for SQL Server, Oracle and DB2 opens up a world of additional data that you can use with Foglight. These are called User-Defined Collections, or UDC's for short.
There are some nuances to using them…
