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…

A database team at a global logistics company uses Foglight to rapidly identify and resolve the root cause of SQL Server performance issues.

I've written about the Service Builder before, but I wanted to step back and go through the steps to create a "simple" service definition. This one will simply have some Oracle instances and some hosts (eg. App server, web server, etc.) We start with…

Quest Software is excited to announce our extended Spotlight® Cloud offering which will deliver deep performance diagnostics to both on-premises and cloud SQL Server environments from a single, innovative SaaS platform. Background Two years ago, ...

In the world of Performance Monitoring, you are certainly going to hear about use-cases that require integration with third-party solutions such as those used for IT Service Management (ITSM).  For our customers using Foglight for Cross Platfor...