Performance Monitoring

Way back in 2020, these posts formed the building blocks of using the command line to automate alarm blackouts in Foglight: Part 1 Part 2 Part 3  In Part 3, we looked at adding objects (instances, hosts, etc.) to a service definition, and then h...

Foglight for Databases helps reduce database skills gaps in hybrid IT environments while diminishing operational risks.

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 blog post you will learn new features for analyzing execution plans with Spotlight on SQL Server Enterprise.

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 ...

Hybrid cloud environments present many risks for organizations. Learn the risks when hybrid IT becomes your new reality and how to best overcome them.

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…