Performance Monitoring

We are proud to announce the general availability of Foglight Evolve. This release brings significant product enhancements that many of our customers requested.

SQL tuning is challenging and time consuming. Janis Griffin, Oracle Ace shares her top manual and automated tips for tuning SQL statements.

Challenges with costs, resource allocations, and performance monitoring for cloud migrations are discussed. Foglight can help reduce risks in these hybrid IT operations.

Many of us don’t like to ask for directions…. https://www.youtube.com/watch?v=mqVzRD_nWLQ&t=16s That said, getting advice, directions, help, or suggestions will provide a faster path to success. My Dad always said, “When in d...

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